mysql 5.7.x reset password
發表於 : 2023年 1月 13日, 18:33
SHOW VARIABLES LIKE 'validate_password%';
SET GLOBAL validate_password_length = 6;
SET GLOBAL validate_password_number_count = 0;
SET GLOBAL validate_password_policy = 0;
update user set authentication_string=PASSWORD("1234") where User='root';
FLUSH PRIVILEGES;
SET GLOBAL validate_password_length = 6;
SET GLOBAL validate_password_number_count = 0;
SET GLOBAL validate_password_policy = 0;
update user set authentication_string=PASSWORD("1234") where User='root';
FLUSH PRIVILEGES;