Go: Linux environment mysql root user password reset

The root password of MySQL is often set, it is forgotten, this kind of thing still happens frequently. Transfer from others (http://www.osyunwei.com/archives/2014.html), right to take notes. Linux environment, Workaround:

1. Edit MySQL configuration file my.cnf

VI/ETC/MY.CNF #编辑文件, find [mysqld], add a line below Skip-grant-tables

[Mysqld]

Skip-grant-tables

: wq! #保存退出

Service mysqld Restart #重启MySQL服务

　　

2. Enter MySQL Console

Mysql-uroot-p #直接按回车, you do not need to enter the root password.

　　

3. Change the root password

Update Mysql.user set Password=password (' 123456 ') where user= "root" and host= "localhost";

Flush privileges; #刷新系统授权表

Grant all on * * to ' root ' @ ' localhost ' identified by ' 123456 ' with GRANT option;

4, cancel the/etc/my.cnf in the Skip-grant-tables

VI/ETC/MY.CNF Edit the file, find [mysqld], delete the Skip-grant-tables line

: wq! #保存退出

5. Restart MySQL

Service mysqld Restart #重启mysql, this time the root password of MySQL has been modified to 123456

6. Enter MySQL Console

Mysql-uroot-p #进入mysql控制台

123456 #输入密码

Above.

Go: Linux environment mysql root user password reset