mysql -u root -p
USE mysql;
UPDATE user SET authentication_string = PASSWORD('new_pass') WHERE User = 'root';
FLUSH PRIVILEGES;
關鍵點:MySQL 5.7+ 密碼欄為 authentication_string,5.6 為 password。PASSWORD() 為單向雜湊。
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new_pass');
FLUSH PRIVILEGES;
mysqladmin -u root -p'old_pass' password 'new_pass'
mysqladmin -u root -p'new_pass' flush-privileges
GRANT ALL PRIVILEGES ON db.* TO 'user'@'localhost' IDENTIFIED BY 'new_pass';
-- 無需 FLUSH PRIVILEGES,GRANT 即時生效
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_pass';
-- 8.0 預設使用 caching_sha2_password 插件,更安全
systemctl stop mysqld 或 service mysql stopmysqld_safe --skip-grant-tables --skip-networking &--skip-networking 防止遠端未授權連入mysql -u rootUSE mysql;
UPDATE user SET authentication_string = PASSWORD('new_pass') WHERE User = 'root';
FLUSH PRIVILEGES;
mysqld_safe 進程,systemctl start mysqldFLUSH PRIVILEGES 強制重新讀取 mysql.user、db、tables_priv 等授權表GRANT、ALTER USER、SET PASSWORD 內部已隱含刷新,無需額外執行root@'%' 而非 root@'localhost',導致本地登入仍用舊密碼FLUSH PRIVILEGES 以為生效實則未生效PASSWORD() 函數移除,需用 ALTER USER 或 SET PASSWORD