You can recover MySQL database server password with following five easy steps.
Stop services:
# /etc/init.d/mysql stop # mysqld_safe --skip-grant-tables &
Login:
#mysql -u root
Output:
Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.1.15-Debian_1-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql>
Type:
mysql> use mysql;
mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
mysql> flush privileges;
mysql> quit
Done!
Just make sure you stop mysql then start normal:
/etc/init.d/mysql stop /etc/init.d/mysql start
Give a try login with root then type your new password:
mysql -u root -p
Have fun!
©Web design Costa del Sol | SEO Marbella
