You must reset your password报错

mysql连接成功之后,执行sql报错ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.需要修改初始化密码如果修改的密码不符合密码策略会报错ERROR 1819 (HY000): Your password does not satisfy the current policy requirements默认密码策略(长度,字符,数字要求)修改密码策略

mysql连接成功之后,执行sql报错ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

需要修改初始化密码

#连接mysql并输入密码mysql -u root -p#修改初始化密码ALTER USER USER() IDENTIFIED BY 'TESTtest1234.';

如果修改的密码不符合密码策略会报错ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

默认密码策略(长度,字符,数字要求)

修改密码策略

#连接mysql并输入密码mysql -u root -p#设置密码策略set global validate_password_policy=0;set global validate_password_length=1;