Change MySQL root PWD

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

Resetting MySQL Root Password: Red Hat and CentOS If you’ve forgotten your MySQL root password (or are involved with some nefarious activity), here is how you can reset that password on a Red Hat (RHE

Resetting MySQL Root Password: Red Hat and CentOS If you’ve forgotten your MySQL root password (or are involved with some nefarious activity), here is how you can reset that password on a Red Hat (RHE

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