忘记mysql root密码

vi /etc/my.cnf

在[mysqld]的段中加上一句：skip-grant-tables

保存

重启 service mysqld restart

怎样就可以不用密码登录了

mysql -u root

use mysql;
UPDATE user SET authentication_string = password('jsyx2016!') WHERE User = 'root';

flush privileges;

quit;

修改密码后记得把/etc/my.cnf的skip-grant-tables注释掉