修改数据库密码报错[ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it]

 

1.登陆mysql服务 

mysql -uroot -pxxxx

 2.修改密码和权限、这里密码设置为123456、生产上要符合密码规范

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123456');

ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;

3.刷新MySQL的系统权限

FLUSH PRIVILEGES;

4.切换到mysql数据库，重新登陆完成修改

use mysql