ERROR 1820 (HY000): You must reset your password using ALTER USER statement befo re executing this s

来源:互联网 发布:exec php 执行不了 编辑:程序博客网 时间:2024/05/22 10:40

mysql> update mysql.user set password=PASSWORD('123456') where User='root';
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

解决方法:

mysql>set password=password('密码');

0 0
原创粉丝点击