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

原创 2016年06月01日 15:47:20
   昨天登录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> set password=password("youpassword");
2、刷新权限
mysql> flush privileges;
版权声明:本文为博主原创文章,未经博主允许不得转载。

相关文章推荐

ubuntu14.10下解决"ERROR 1820 (HY000): You must SET PASSWORD before executing this statement"

1. 问题描述 在ubuntu14.10终端下, 执行命令 $ mysql -uroot -p 并输入密码后进入mysql的shell, 然后在显示所有数据库时出现以下信息 ERROR 1820 (H...

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

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

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...

解决ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

今天在MySql5.6操作时报错:You must SET PASSWORD before executing this statement解决方法,需要的朋友可以参考下 ERROR 1820 (H...
  • july_2
  • july_2
  • 2014-12-12 16:53
  • 8866

mysql my.cnf 配置建议

mysql的配置文件是/etc/my.cnf,通过修改它来配置mysql。 /etc/my.cnf来自以下文件: 如果你的内存≤64M,则复制/usr/local/share/mysql/my-s...

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...

【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...

yum 安装mysql5.7 是 出现无法登陆问题以及mysql error You must reset your password using ALTER USER statement befor

centos7 mysql5.7.17 error You must reset your password using ALTER USER statement before executing t...

mysql5.7设置简单密码报错ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

【问题】 有时候,只是为了自己测试,不想密码设置得那么复杂,譬如只想设置root的密码为123456。 SET PASSWORD FOR 'root'@'localhost' = PASSWORD...
  • kuluzs
  • kuluzs
  • 2016-07-16 14:40
  • 6027

mysql安装在centos7报错ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

【问题】: 首次在centos下安装mysql,客户端连接mysql时报错: [root@localhost opt]# /usr/bin/mysql -u root ERROR 1045 (280...
  • kuluzs
  • kuluzs
  • 2016-07-16 13:44
  • 4301
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:深度学习:神经网络中的前向传播和反向传播算法推导
举报原因:
原因补充:

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