Forgot your MySQL root password? Don’t worry I’ll tell you the simplest way to reset MySQL root password. This guide will work for Linux and Windows OS as well.
So without wasting any valuable time lets start with the:
Steps to reset MySQL Root Password:
Step 1: Stop MySQL service: You can do this using two methods:
service mysql stop
Stopping MySQL database server: mysqld.
Step 2: Start MySQL with –skip-grant-tables option:
Starting mysqld daemon with databases from /var/lib/mysql
Step 3: Login to MySQL server without password simply execute:
mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.5.15-Debian_1-log
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.
Step 4: Set new password for root user.
use mysql; SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass'); flush privileges;
Then change the
'root'@'localhost' account password. Replace the password with the password that you want to use. To change the password for a
root account with a different host name part, modify the instructions to use that host name.
You have successfully reset your MySQL root password, you should now be able to connect to the MySQL server as
root using the new password. Stop the server and restart it normally.
Step 5: Simply restart the mysql and use new password for login.
service mysql restart
Now login with your new root password:
mysql -u root -p
Now you should be successfully able to login to MySQL using new password, let me know in case you face any problem.
Comment if you face any problem.