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 & [1] 1001 Starting mysqld daemon with databases from /var/lib/mysql mysqld_safe[1002]: 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 #
done!
You may also want to read these posts:
- Postfix + Centos + Policyd V2 + MySQL
- Memcached And PHP, Caching Mysql Query Result
- Securing MySQL traffic with stunnel
- Postfix, Dynamic OverQuota User Map Script Using Bash And Inotifywait
- How-To Make the root filesystem read-only
- Postfix Create Blackhole For Authenticated User’s Outgoing Submission
- How To Use LIKE In MYSQL Stored Procedure Select Statement?
- Postfix Change Header From: outgoing mail using altermime
- Why is My Root File System Read-Only?
- auto remote backup with unison