关于mysql validate_password plugin deprecated导致的问题

问题一：ERROR 1193 (HY000)

set global validate_password_XXX=XXX;

ERROR 1193 (HY000): Unknown system variable 'validate_password_XXX'

解决方案：中间变成点号，如set global validate_password.length

问题二：ERROR 1064 (42000)

SET PASSWORD = PASSWORD('xxxx');

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('xxxx')' at line 1

解决方案：使用SET PASSWORD ='xxxx';更建议用ALTER USER USER() IDENTIFIED BY 'XXXX';

具体可能从随着版本更新可能会有更多的变化，可参考

1.早期版本（关于validate_password plugin）

https://dev.mysql.com/doc/refman/5.7/en/validate-password.html

https://dev.mysql.com/doc/refman/5.7/en/set-password.html

2.80版本（关于validate_password component）

https://dev.mysql.com/doc/refman/8.0/en/validate-password.html

https://dev.mysql.com/doc/refman/8.0/en/validate-password-options-variables.html