ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
参考自:https://dev.mysql.com/doc/refman/5.7/en/alter-user.html
需要用ALTER USER重置一次密码才能执行sql语句,
ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码
' PASSWORD EXPIRE NEVER; -- 密码永不过期
ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码
' PASSWORD EXPIRE; -- 密码有过期时间