The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement解决方法

mysql>mysql -u root -p

mysql>输入密码登录。

mysql>set password for root@localhost = password('新密码'); 

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> set password for root@localhost = password('新密码');
Query OK, 0 rows affected (0.00 sec)

mysql>quit //成功退出