Difference between revisions of "Reset MySQL root password"

Revision as of 22:34, 8 April 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

@@ Line 5: / Line 5: @@
 To reset the root password of a MySQL server, first go to a root shell and stop MySQL:
 {{code|<pre>
-/etc/init.d/mysql stop
+service mysql stop
 </pre>}}
@@ Line 18: / Line 18: @@
 {{code|<pre>
 mysql -u root
-use mysql;
+use mysql
 update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
 flush privileges;
@@ Line 27: / Line 27: @@
 And restart the MySQL server again:
 {{code|<pre>
-/etc/init.d/mysql restart
+service mysql start
 </pre>}}