Difference between revisions of "Reset MySQL root password"
From Organic Design wiki
m |
(Change source-code blocks to standard format) |
||
| Line 4: | Line 4: | ||
}} | }} | ||
To reset the root password of a MySQL server, first go to a root shell and stop MySQL: | To reset the root password of a MySQL server, first go to a root shell and stop MySQL: | ||
| − | + | <source> | |
service mysql stop | service mysql stop | ||
| − | </ | + | </source> |
Next, run MySQL in safe mode in the background: | Next, run MySQL in safe mode in the background: | ||
| − | + | <source> | |
mysqld_safe --skip-grant-tables & | mysqld_safe --skip-grant-tables & | ||
| − | </ | + | </source> |
Reset the MySQL root password: | Reset the MySQL root password: | ||
| − | + | <source> | |
mysql -u root | mysql -u root | ||
use mysql | use mysql | ||
| Line 22: | Line 22: | ||
flush privileges; | flush privileges; | ||
quit | quit | ||
| − | </ | + | </source> |
And restart the MySQL server again: | And restart the MySQL server again: | ||
| − | + | <source> | |
service mysql start | service mysql start | ||
| − | </ | + | </source> |
Revision as of 18:11, 22 May 2015
|
Reset MySQL root password Organic Design procedure |
To reset the root password of a MySQL server, first go to a root shell and stop MySQL:
service mysql stop
Next, run MySQL in safe mode in the background:
mysqld_safe --skip-grant-tables &
Reset the MySQL root password:
mysql -u root
use mysql
update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
flush privileges;
quit
And restart the MySQL server again:
service mysql start
