MySQL: Changing the root user’s password

 

If you need to change the MySQL root user’s password use the following from a command prompt:

 

mysqladmin -u root -p password NEWPASSWORD

 

Enter the current root password when prompted and replace NEWPASSWORD with the desired password. This should return you to the command prompt, and you can test whether it was successful by logging in:

 

mysql -u root -p


Posted

in

by