Chenhui: Created page with "= MySQL = Please note that you can reset the MySQL root password by the following procedure: 1- Stop the services. # service cmd stop # service mysql stop 2- ..."

2015-04-01T15:16:32Z

Created page with "= MySQL = Please note that you can reset the MySQL root password by the following procedure: 1- Stop the services. <syntaxhighlight> # service cmd stop # service mysql stop </syntaxhighlight> 2- ..."

New page

= MySQL =
Please note that you can reset the MySQL root password by the following
procedure:

1- Stop the services.
<syntaxhighlight>
# service cmd stop
# service mysql stop
</syntaxhighlight>

2- Start MySQL in safe mode.
<syntaxhighlight>
# mysqld_safe --skip-grant-tables &
# mysql -u root
</syntaxhighlight>

3- Change the password
<syntaxhighlight>
mysql> use mysql;
mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where
User='root'; flush privileges;
quit
</syntaxhighlight>

Replace the string NEW-ROOT-PASSWORD inside the double quotes with your
new password.

4- Restart the services.
<syntaxhighlight>
# service mysqld stop
# service mysqld start
# service cmd start
</syntaxhighlight>

Bright:mysql - Revision history

Chenhui: Created page with "= MySQL = Please note that you can reset the MySQL root password by the following procedure: 1- Stop the services. # service cmd stop # service mysql stop 2- ..."