参考前文利用安全模式成功登陆,然后修改密码,等于给MySql设置了密码。登陆进去后,想创建一个数据库测试下。得到的结果确实:
ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
非常诡异啊,明明用密码登陆进去了,怎么还提示需要密码。
参考官方的一个文档,见http://dev.mysql.com/doc/refman/5.6/en/alter-user.html。如下操作后就ok了:
mysql> create database yan1;
ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
mysql> SET PASSWORD = PASSWORD('123456');
Query OK, 0 rows affected (0.03 sec)
mysql> create database yan1;
Query OK, 1 row affected (0.00 sec)
也就是用mysql> SET PASSWORD = PASSWORD('123456');这句话重新设置一次密码!大爷的,真费劲啊。
这位仁兄也遇到了相同的问题。
分享到:
相关推荐
今天在MySql5.6操作时报错:You must SET PASSWORD before executing this statement解决方法,需要的朋友可以参考下
ERROR 1820 (HY000): You must reset your ...今天在MySql5.6操作时报错:You must SET PASSWORD before executing this statement解决方法,需要的朋友可以参考下 参考前文利用安全模式成功登陆,然后修改密码,等于
请求命令后报错误:ERROR 1820 (HY000): You must SET PASSWORD before executing this statement ,使用phpMyAdmin管理工具也无法登录,显示错误:#1862 无法登录 MySQL 服务器 错误解决 进入mysql的服务器中使用...
You must reset your password using ALTER USER statement before executing this statement. alter user user() identified by "123456"; Your password does not satisfy the current policy requirements set ...
然后我们使用show databases查看所有数据库,这个时候如果提示:ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. 我们就输入 set password=...
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. 需要使用下面的命令来修改密码 mysql> alter user user() identified by ‘password'; Query OK...
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. mysql> use test; ERROR 1820 (HY000): You must reset your password using ALTER USER ...
报错:BUILD FAILEDD:\workspace\ganji\build.xml:144: The following error occurred while executing this line:D:\workspace\ganji\build.xml:271: Unable to delete file D:\workspace\ganji\tmp\proguard\tmp....
1、ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. 解决方式如下: mysql> ALTER USER USER() IDENTIFIED BY 'Xiaoming250'; 2、修改root密码 ...
本人做系统时遇到的一些Hibernate问题及解决方案。
MySQL Stored Procedure Programming Advance Praise for MySQL Stored Procedure Programming Preface Objectives of This Book Structure of This Book What This Book Does Not Cover Conventions ...
Remove any discs from the CD-W540E before executing this program. 3-2. Do not try to access the drive while update is in process. 3-3. The firmware update may not work properly while certain ...
D:\workspace\ganji\build.xml:144: The following error occurred while executing this line: D:\workspace\ganji\build.xml:271: Unable to delete file D:\workspace\ganji\tmp\proguard\tmp.jar 解决: 已经...
实用负载均衡技术:网站性能优化攻略.((英)Peter Membrey
Error while executing: npm ERR! /usr/bin/git ls-remote -h -t https://github.com/nhn/raphael.git npm ERR! npm ERR! fatal: unable to access 'https://github.com/nhn/raphael.git/': Failed connect to ...
FixIDAPython - 修复IDA加载IDAPython时出现的错误
vivado FIFO的使用
Note: output_handler must be empty if this is set 'On' !!!! ; Instead you must use zlib.output_handler. ; http://php.net/output-handler ;output_handler = ; Transparent output compression using the ...