首页 > 代码库 > You must SET PASSWORD before executing this statement解决

You must SET PASSWORD before executing this statement解决

[转载] MySql5.6操作时报错:You must SET PASSWORD before executing this statement解决
转载: http://blog.csdn.net/yanzi1225627/article/details/8694358

参考前文利用安全模式成功登陆,然后修改密码,等于给MySql设置了密码。登陆进去后,想创建一个数据库测试下。得到的结果确实:

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

非常诡异啊,明明用密码登陆进去了,怎么还提示需要密码。

mysql>  SET PASSWORD = PASSWORD(‘123456‘);这句话重新设置一次密码!
mysql>  flush privileges;


来自为知笔记(Wiz)


You must SET PASSWORD before executing this statement解决