With lots of server to maintained, sometimes this occasionally happened. how to reset root password you forgotten root password?? seems like chicken egg problem to me Don’t worry here’s the solutions First of all you will need to ensure that your database is stopped:
# service mysqld stop
Now we should start the database with –skip-grant-tables which would allow us to connect to it without a password.
# /usr/bin/mysqld_safe --skip-grant-tables &  1001 Starting mysqld daemon with databases from /var/lib/mysql mysqld_safe: started
Let’s change the root password:
# mysql --user=root mysql Enter password: mysql> update user set Password=PASSWORD('new-password-here') WHERE User='root'; Query OK, 2 rows affected (0.04 sec) Rows matched: 2 Changed: 2 Warnings: 0 mysql> flush privileges; Query OK, 0 rows affected (0.02 sec) mysql> exit Bye
Now that you’ve done that you just need to stop the temporary unsecure server, so that you can go back to running a secure MySQL server with password restrictions in place. First of all bring the server you started into the foreground by typing “fg”, then kill it by pressing “Ctrl+c” afterwards. start original secure MySQL server
# service mysqld start Starting MySQL database server: mysqld. Checking for corrupt, not cleanly closed and upgrade needing tables..
Now everything should be done and you should have regained access to your MySQL database Go ahead and try it
# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 202718 to server version: 5.0.22 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> \q Bye #