ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables opt

mysql跳过权限: mysqld -nt --skip-grant-tables opt

登录:mysql -uroot -p

修改root密码 set password for 'root'@'localhost' = password('新密码');

报错:ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables opt

原因:权限没有刷新

解决:flush privileges

posted @ 2016-04-07 14:01  麥片  阅读(13437)  评论(0)    收藏  举报