Difference between revisions of "Reset MySQL root password"

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

@@ Line 4: / Line 4: @@
 }}
 To reset the root password of a MySQL server, first go to a root shell and stop MySQL:
-{{code|<pre>
+<source>
-/etc/init.d/mysql stop
+service mysql stop
-</pre>}}
+</source>
 Next, run MySQL in safe mode in the background:
-{{code|<pre>
+<source>
-/usr/local/mysql/bin/safe_mysqld --user=mysql --skip-grant-tables --skip-networking &
+mysqld_safe --skip-grant-tables &
-</pre>}}
+</source>
 Reset the MySQL root password:
-{{code|<pre>
+<source>
-/usr/local/mysql/bin/mysqladmin -u root flush-privileges password "******"
+mysql -u root
-</pre>}}
+use mysql
+update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
+flush privileges;
+quit
+</source>
 And restart the MySQL server again:
-{{code|<pre>
+<source>
-/etc/init.d/mysql restart
+service mysql start
-</pre>}}
+</source>