推荐点击下面图片，通过本站淘宝优惠价购买:
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.hqyman.cn/post/3998.html 非本站原创文章欢迎转载，原创文章需保留本站地址！
休息一下，本站随机推荐观看栏目:
