Thursday, August 2, 2012

Recover MySQL root password

step1: stop mysql

root@bilal# service mysqld stop
root@bilal# /usr/sbin/mysqld --skip-grant-tables &  
 

step2: Login in to your mysql shell

root@bilal:/# mysql -u root
mysql> UPDATE mysql.user SET Password=PASSWORD('Newpassword') WHERE User='root';
mysql> FLUSH PRIVILEGES; 

No comments:

Post a Comment