Difference between revisions of "Reset MySQL root password"
From Organic Design wiki
m (Redirected page to MediaWiki SQL queries#Reset MySQL root password) |
(rv) |
||
| Line 1: | Line 1: | ||
| − | + | {{procedure | |
| + | |status = In use | ||
| + | |role = sysop | ||
| + | }} | ||
| + | To reset the root password of a MySQL server, first go to a root shell and stop MySQL: | ||
| + | <source> | ||
| + | service mysql stop | ||
| + | </source> | ||
| + | |||
| + | |||
| + | Next, run MySQL in safe mode in the background: | ||
| + | <source> | ||
| + | mysqld_safe --skip-grant-tables & | ||
| + | </source> | ||
| + | |||
| + | |||
| + | Reset the MySQL root password: | ||
| + | <source> | ||
| + | mysql -u root | ||
| + | use mysql | ||
| + | update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root'; | ||
| + | flush privileges; | ||
| + | quit | ||
| + | </source> | ||
| + | |||
| + | |||
| + | And restart the MySQL server again: | ||
| + | <source> | ||
| + | service mysql start | ||
| + | </source> | ||
Latest revision as of 11:04, 22 July 2019
|
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
