Difference between revisions of "Reset MySQL root password"

From Organic Design wiki
(rv)
 
Line 1: Line 1:
#redirect [[MediaWiki SQL queries#Reset MySQL root password]]
+
{{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

Procedure.svg 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