mysql 修改root密码提示1064语法错误问题解决

mysql> set password for root@localhost = password('123456');
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

mysql> update user set authentication_string=password('123456') where user='root';
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 '("123456") where user="root"' at line 1

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'psd_12334';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

mysql> SET PASSWORD = '123456';
Query OK, 0 rows affected (0.14 sec)