centos重置mysql密码

1.编辑/etc/my.cnf
vim /etc/my.cnf
[mysqld]下增加skip-grant-tables
2.重启mysql
service mysqld restart
3.进入mysql
mysql
4.进入mysql数据库
use mysql;
5.修改密码
update user set authentication_string=password('newpassword') where user='root' ;
6.刷新权限
flush privileges;
7.退出并删除刚才添加的
quit
[mysqld]`删除下增加`skip-grant-tables
8. 重启MySQL
service mysqld restart