MySQL Root Password modification

Small partners to install a code version control software on the previous server, to use the database, but want to find the root password or forget, other installed services are used in the private account configuration file to find the root user's password. Use the following method to force the password to be fixed:

1. Running the MySQL service in Safe mode requires system root privileges

sudo suservice mysql stopmysqld_safe--skip-grant-table

2. Connect a terminal with the MySQL client to enter the database, modify the password of the root user in the MySQL library

mysqlmysql> use mysql;mysql> UPDATE user SET Password=password ("mysql_root_passwd") WHERE user= ' root ';mysql> Flush privileges;

3. Run MySQL again in the normal way.

Service MySQL stopservice MySQL start