记一次 MYSQL 5.6 版本 ERROR 1290 (HY000):

修改mysql密码时出现错误如下

ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables opt
ion so it cannot execute this statement

原因是权限没有刷新 ps：可能上次修改了配置  没有刷新导致的。

执行一次权限刷新就OK

mysql> set password = password('123456a');
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables opt
ion so it cannot execute this statement
mysql> flush privileges;
Query OK, 0 rows affected (0.10 sec)

在此修改密码

mysql> set password = password('123456a');
ERROR 1133 (42000): Can't find any matching row in the user table
mysql> set password for 'root'@'localhost'= password('123456a');
Query OK, 0 rows affected (0.00 sec)

记得刷新权限

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

对了，在修改密码时 出现另一个错误

Can't find any matching row in the user table  缺少指定账户

mysql> set password = password('123456a');
ERROR 1133 (42000): Can't find any matching row in the user table

mysql> set password for 'root'@'localhost'= password('123456a');
Query OK, 0 rows affected (0.00 sec)