1
2
3
4
5mysql> SET GLOBAL validate_password_policy='LOW';
mysql> SHOW VARIABLES LIKE 'validate_password%';
mysql> ALTER USER USER() IDENTIFIED BY 'root';
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'rootroot';
mysql> ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;