How do I change MySQL root password under Linux, FreeBSD, OpenBSD and UNIX?
Method #1: Use mysqladmin command to change root password
If you have never set a root password for MySQL server, the server does not require a password at all for connecting as root.
To setup root password for first time, use mysqladmin command at shell prompt...
