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 as follows:

$ mysqladmin -u root password NEWPASSWORD However, if you want to change (or update) a root password, then you need to use the following command:

$ mysqladmin -u root -p'oldpassword' password newpass

For example, If the old password is abc, you can set the new password to 123456, enter:

$ mysqladmin -u root -p'abc' password '123456'
0 views0 comments

Recent Posts

See All

Common MySQL Commands

Common Useful MySQL Commands Applicable to Centos Versions: Centos 5.x Centos 6.x Requirements Explanation of requirements. MySQL and MySQL-server installed on a Centos 5.x system DBA access rights to

Common MySQL Commands

Common Useful MySQL Commands Applicable to Centos Versions: Centos 5.x Centos 6.x Requirements Explanation of requirements. MySQL and MySQL-server installed on a Centos 5.x system DBA access rights to

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 pro