Reset MySQL root Password

Recently, I forgot the root password for MySQL and went about resetting it as below:

1. Stop mysqld and restart it with:
   

   # service mysqld stop
   # mysqld_safe --skip-grant-tables --user=root
   

2. Connect to the mysqld server with this command:

   sql> mysql -u root
   

3. Issue the following statements in the mysql client:

   mysql> UPDATE mysql.user SET Password=PASSWORD('newpassword') WHERE User='root';
   mysql> FLUSH PRIVILEGES;
   

   Replace “newpassword

   Bookmark/Search this post with:

   • 
   • 
   • 
   • 
   • 
   • 
   • 
   • 
   • 
   • 
   • 
   • 
   ‹ MySQL Random Notes...upSome frequently used MySQL commands for reference... ›