mysql.user 表 Password 列存儲的是雜湊值,非明文。直接插入明文會導致驗證失敗:
-- 錯誤示範
INSERT INTO user (Host, User, Password) VALUES ('%', 'user', 'plainpass'); -- 失敗
FLUSH PRIVILEGES;
INSERT INTO mysql.user (Host, User, Password) VALUES ('%', 'new_user', PASSWORD('StrongPass!'));
FLUSH PRIVILEGES;
SET PASSWORD FOR 'new_user'@'%' = PASSWORD('StrongPass!');
GRANT ALL PRIVILEGES ON *.* TO 'new_user'@'%' IDENTIFIED BY 'StrongPass!';
mysqladmin -u root -p'oldpass' password 'StrongPass!'
# 首次設置 root 密碼 (無舊密碼)
mysqladmin -u root password 'StrongPass!'
mysql.user 表 (INSERT/UPDATE/DELETE) 後**必須執行**。SET PASSWORD、GRANT、REVOKE、CREATE USER、DROP USER **自動刷新,無需手動執行**。mysqladmin -u root reload 或 mysqladmin -u root flush-privileges。-p 交互式或 --defaults-extra-file。mysql_native_password,遷移至 caching_sha2_password (8.0 默認) 或 sha256_password。SELECT User, Host, plugin FROM mysql.user WHERE plugin NOT IN ('caching_sha2_password','sha256_password');