taishan2280(centos7.6)mysql设置密码出错

taishan2280(centos7.6)mysql设置密码出错：

：ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'password('123456')' at line 1

1、测试：

alter user 'root'@'localhost' identified by 'jsZ123.';

提示：

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

2、设置密码的验证强度等级：将validate_password_policy 的全局参数为 LOW 即可：

 set global validate_password.policy=LOW; 

3、输入：

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456'；

提示：Query OK, 0 rows affected (0.01 sec)；

设置成功。