首页 > 代码库 > 安装完绿色版MySQL修改密码:ERROR 1820 (HY000): You must reset your password using ALTER USER statement befo re executing this statement.

安装完绿色版MySQL修改密码:ERROR 1820 (HY000): You must reset your password using ALTER USER statement befo re executing this statement.

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

 

参考:http://dev.mysql.com/doc/refman/5.6/en/alter-user.html

 

直接执行:set password=password(‘密码‘);

搞定!!!

安装完绿色版MySQL修改密码:ERROR 1820 (HY000): You must reset your password using ALTER USER statement befo re executing this statement.