linux mysql 报错ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

1、报错信息

ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

2、报错原因

这个报错的意思是执行某个mysql语句需要更改原始密码

3、解决方案

登录mysql

mysql -u root -p

修改密码

mysql> SET PASSWORD = PASSWORD('123456'); 

4、报错

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

意思是你设置的密码复杂度不够，最好是数字+字母+特殊字符