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

原创 2016年06月01日 15:43:19

昨天登录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>


问题解决

版权声明:本文为博主原创文章,未经博主允许不得转载。

MySQL5.7 错误:ERROR 1820 (HY000): You must reset your password using ALTER USER statement before ...

mysql> alter user 'root'@'localhost' identified by '111111'; 输入以上语句,会提示: ERROR 1819 (HY000): Your...
  • shell2008
  • shell2008
  • 2016年08月31日 00:01
  • 4208

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this st

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this st...
  • u011647962
  • u011647962
  • 2016年11月17日 18:06
  • 3042

mysql 5.7 ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executi

搭建slave 库, 主库执行: mysql> grant replication slave on *.* to repl@"192.168.40.132" identified by 'roo...
  • huangliang0703
  • huangliang0703
  • 2015年11月24日 16:41
  • 13155

5.7 以后的MYSQL 登录数据库还是报错ERROR 1820 (HY000): You must reset your password using ALTER USER statement be

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this st...
  • qq_16410203
  • qq_16410203
  • 2016年12月25日 16:34
  • 219

You must reset your password using ALTER USER statement before executing this statement.

centos7.0安装完mysql5.7.11之后使用mysql -u root -p 连接数据库。操作提示:You must reset your password using ALTER USER...
  • jiaoshenmo
  • jiaoshenmo
  • 2016年03月28日 14:46
  • 5878

mysql5.7免安装版报错处理You must reset your password using ALTER USER statement before executing

安装完mysql 之后,登陆以后,不管运行任何命令,总是提示这个 step 1: SET PASSWORD = PASSWORD(‘your new password‘); step 2:...
  • wenshu12321
  • wenshu12321
  • 2016年04月17日 00:11
  • 9555

【mysql】You must reset your password using ALTER USER statement before executing this statement.

故障现场:登陆到MySQL服务器,不管你执行什么命令都报这个错 mysql> show databases; ERROR 1820 (HY000): You must reset your pass...
  • hj7jay
  • hj7jay
  • 2017年03月24日 09:42
  • 1479

You must SET PASSWORD before executing this statement的解决方法 详细出处参考:http://www.jb51.net/article/39187.

原文地址:http://www.jb51.net/article/39187.htm
  • YYZhQ
  • YYZhQ
  • 2014年04月12日 12:02
  • 6423

mysql5.7 You must reset your password using ALTER USER statement before executing this statement.

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this st...
  • liwei2633
  • liwei2633
  • 2017年05月20日 14:47
  • 566

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

昨天登录mysql(Server version: 5.7.11) 还是很好的,今天登录后执行任何命令都报下面的错误 mysql> help contents ERROR 1820 (HY000):...
  • Brighter_Xiao
  • Brighter_Xiao
  • 2016年06月01日 15:47
  • 1065
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:mysql 报错ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executin
举报原因:
原因补充:

(最多只允许输入30个字)