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?
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:
Post a Comment