ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this
mysql操作错误：
mysql> use mysql;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql>
原因：没有设置允许远程连接的权限；
解决方法：
mysql> alter user user() identified by "123456";
Query OK, 0 rows affected (0.02 sec)
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
Query OK, 0 rows affected (0.01 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
给用户设置密码及访问权限，最后刷新flush即可。