mysql数据库修改用户密码

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

SET PASSWORD FOR 'john'@'localhost' = PASSWORD('new_secret');

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

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

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

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

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

SHOW VARIABLES LIKE 'validate_password%';

sudo systemctl status mysql