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