MySQL修改密码&修改密码策略

• 更新密码

USE mysql;

UPDATE user SET authentication_string = PASSWORD('newpasswd') WHERE user = 'dbadmin' AND host = 'localhost';

FLUSH PRIVILEGES;

1
2
3
4
5
6

• 查看 MySQL 的密码策略

SHOW VARIABLES LIKE 'validate_password%';
1

• 修改MySQL密码策略

set global validate_password_length=6;
1