HQY

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('新密码'); //这句好像不行啊

mysql> ALTER USER 'root' IDENTIFIED WITH MYSQL_NATIVE_PASSWORD BY '新密码';

Query OK, 0 rows affected (0.00 sec)

mysql>quit //成功退出

推荐本站淘宝优惠价购买喜欢的宝贝:

本文链接：https://www.jinbel.cn/post/3998.html 非本站原创文章欢迎转载，原创文章需保留本站地址！

分享到：