mysql更改用户名密码

ALTER USER 'username'@'host' IDENTIFIED BY 'new_password';

ALTER USER 'john'@'localhost' IDENTIFIED BY 'new_secure_password';

SET PASSWORD FOR 'username'@'host' = 'new_password';

SET PASSWORD FOR 'john'@'localhost' = 'new_secure_password';

UPDATE mysql.user SET Password = PASSWORD('new_password') WHERE User = 'username' AND Host = 'host';
FLUSH PRIVILEGES;

UPDATE mysql.user SET Password = PASSWORD('new_secure_password') WHERE User = 'john' AND Host = 'localhost';
FLUSH PRIVILEGES;

USE mysql;
UPDATE user SET Password = PASSWORD('new_secure_password') WHERE User = 'john' AND Host = 'localhost';
FLUSH PRIVILEGES;

SET GLOBAL validate_password_policy = LOW; -- 设置为LOW级别，降低密码复杂性要求

CREATE USER 'john'@'localhost' IDENTIFIED BY 'new_secure_password';