原因: 链接数据库忘记用户密码, 配置文件/etc/my.cnf中增加skip-grant-table 跳过密码登录,进入服务器修改密码时,出现如下报错信息: mysql> alter user root@'localhost' ident
原因: 链接数据库忘记用户密码, 配置文件/etc/my.cnf中增加skip-grant-table 跳过密码登录,进入服务器修改密码时,出现如下报错信息:
mysql> alter user root@'localhost' identified by '123';ERROR 1290 (HY000): The MySQL Server is running with the --skip-grant-tables option so it cannot execute this statement
解决方法:
重启数据库服务器
]# service Mysql restart
链接数据库服务器
]# mysql
mysql> flush privileges; 刷新权限列表
mysql> alter user root@'localhost' identified by '123'; 更改用户密码
mysql> flush privileges;Query OK, 0 rows affected (0.01 sec)mysql> alter user root@'localhost' identified by '123';Query OK, 0 rows affected (0.00 sec)
3、退出数据库服务器,注释配置文件 #skip-grant-table, 重启数据库服务器器
验证用户是否登录
[root@master-2 mysql]# mysql -uroot -p123mysql: [Warning] Using a password on the command line interface can be insecure.Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 8Server version: 8.0.31 MySQL Community Server - GPLCopyright (c) 2000, 2022, Oracle and/or its affiliates.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> exit
来源地址:https://blog.csdn.net/weixin_70661795/article/details/131663215
--结束END--
本文标题: The MySQL server is running with the --skip-grant-tables option so it cannot execute this state
本文链接: https://www.lsjlt.com/news/401707.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-02
2024-05-02
2024-05-02
2024-05-02
2024-05-02
2024-05-02
2024-05-02
2024-05-02
2024-05-02
2024-05-02
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0