第一次安装完mysql，修改默认密码的时候，报“The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement”。
先刷新mysql然后再重新修改密码即可。
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456'; ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456'; Query OK, 0 rows affected (0.01 sec)
————————————————
版权声明：本文为CSDN博主「终码一生」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/best_luxi/article/details/107088355
- skip-grant-tables 密码 execute running serverskip-grant-tables密码execute running skip-grant-tables statement execute running lock_write_growth statement execute running already running server vnc execute request cannot server update_servers exception unhandled execute server docker run sql super-read-only running办法server execution pattern方式server skip-grant-tables