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

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

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