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  麥片  阅读(13244)  评论(0编辑  收藏  举报