安装完绿色版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.

原文：http://www.cnblogs.com/t1508001/p/5821452.html