How to : mysqladmin command to change root password
If you have never set a root password for MySQL, 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 as follows:
$ mysqladmin -u root password NEWPASSWORD
However, if you want to change (or update) a root password, then you need to use following command
$ mysqladmin -u root -p’oldpassword’ password newpass
For example, If old password is xyz, and set new password to NewPasswd, enter:
$ mysqladmin -u root -p’xyz’ password ‘NewPasswd’
Possibly Related Posts:
- Linux : Error: mysql: Got a packet bigger than ‘max_allowed_packet’ bytes
- linux : How do I enable EPEL (Extra Packages for Enterprise Linux) repo and install the packages under CentOS Linux?
- AutoMySQLBackup: Regularly Backup Your MySQL
- Linux tool :Fdupes
- Backtrack : TestDisk ( Digital forensics ,forensics analysis)