Labels

Tuesday, October 22, 2013

How can I reset my MySQL password?

How can I reset my MySQL password?

1. Stop the mysql demon process using this command :
root@web_01: sudo /etc/init.d/mysql stop

2. Start the mysqld demon process using the --skip-grant-tables option with this command
root@web_01: sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking &

3. start the mysql client process using this command
root@web_01: mysql -u root

4. from the mysql prompt execute this command to be able to change any password
mySql> FLUSH PRIVILEGES;

5. Then reset/update your password
mySql> SET PASSWORD FOR root@'localhost' = PASSWORD('password');

6. Then stop the mysqld process and relaunch it with the classical way: 
root@web_01: sudo /etc/init.d/mysql stop
root@web_01: sudo /etc/init.d/mysql start
OR
root@web_01: sudo /etc/init.d/mysql restart



Enjoy .......
---------------------------------------------------------------------
How can I reset my MySQL password?
change mySql password
how to change MySQL password?

No comments: