Resetting the Root Password for mysqld on Unix Systems

“These are taken from the mysql website and is for refrence and documentation purpose”

On Unix, use the following procedure to reset the password for all MySQL root accounts. The instructions assume that you will start the server so that it runs using the Unix login account that you normally use for running the server. For example, if you run the server using the mysql login account, you should log in as mysql before using the instructions. Alternatively, you can log in as root, but in this case you must start mysqld with the --user=mysql option. If you start the server as root without using --user=mysql, the server may create root-owned files in the data directory, such as log files, and these may cause permission-related problems for future server startups. If that happens, you will need to either change the ownership of the files to mysql or remove them.


10 reasons why India will not and must not become a superpower

During his animated one-hour lecture on ten reasons why India will not and must not become a superpower at Toronto’s Munk Centre, Dr. Ramachandra Guha lamented that in the present lower house of the Indian Parliament, not more than five members would have read a 1949 speech given by Dr. B.R. Ambedkar, the chief architect of India’s constitution, that advised the citizens of a yet-to-be-born republic to eschew three pitfalls.


Adding routes in AIX

Configuring a gateway in AIX

To configure a machine to act as a gateway, use these instructions.

For clarity, this procedure assumes that the gateway machine
connects two networks, and that the gateway machine has already been minimally
configured on one of the networks.

  1. Install and configure the second network adapter.
  2. Choose an IP address for the second network interface.
  3. Add a route to the second network.
  4. To use a machine as an internetwork router over TCP/IP networks,

    no -o ipforwarding=1

AIX commands you should not leave home without


How would I know if I am running a 32-bit kernel or 64-bit kernel?

To display if the kernel is 32-bit enabled or 64-bit enabled, type:

bootinfo -K

Creating a DVD repository on AIX,.

Do yourself a favour and get a spot of space (couple of GBs) and get all your media onto this file system with the following commands:

1. Put the first media CD/DVD into your drive – you do not have to mount it.
2. Make sure you have you file system mounted.
3. Look at what filesets are on the media you are about to build:
gencopy -d /dev/cd0 -t /repository-filesystem -U -X -L all | wc -l
gencopy -d /dev/cd0 -t /repository-filesystem -U -X -L all | more
4. Write it out to a file somewhere:
gencopy -d /dev/cd0 -t /repository-filesystem -U -X -L all >/tmp/filename.txt
5. Do the actual copy/repository build:
gencopy -d /dev/cd0 -t /repository-filesystem -U -X all
6. Stick in the next cd/dvd:
7. Redo steps 1 to 6 until you are done.
8. TAKE NOTE that the actual build takes quite some time.
9. ALSO, make sure you have enough space on /var and /tmp to accommodate the lists the o/s builds to do the media build.
Once done, you will have 1 file system with ALL your media filesets in it.
Then do your ‘smitty install’ and check if you can get your rsct.basic.rte sorted.