mysql 报错ERROR 1820 (重置密码后)

2018/10 17 11:10

mysql 报错ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executin

版权声明:本文为博主原创文章,未经博主允许不得转载。 https://blog.csdn.net/Brighter_Xiao/article/details/51556532

昨天登录mysql(Server version: 5.7.11) 还是很好的,今天登录后执行任何命令都报下面的错误

mysql> help contents
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> help contents
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

解决办法
1、 修改用户密码
mysql> alter user 'root'@'localhost' identified by 'youpassword';

或者

mysql> set password=password("youpassword");
2、刷新权限
mysql> flush privileges;

mysql> help contents
You asked for help about help category: "Contents"
For more information, type 'help <item>', where <item> is one of the following
categories:
Account Management
Administration
Compound Statements
Data Definition
Data Manipulation
Data Types
Functions
Functions and Modifiers for Use with GROUP BY
Geographic Features
Help Metadata
Language Structure
Plugins
Procedures
Storage Engines
Table Maintenance
Transactions
User-Defined Functions
Utility
mysql>

问题解决

--转载请注明: http://91o.cc/mysql-%e6%8a%a5%e9%94%99error-1820-%ef%bc%88%e9%87%8d%e7%bd%ae%e5%af%86%e7%a0%81%e5%90%8e%ef%bc%89/

作者 - 分类 未分类

发表回复

(必填)