ssh -L 3306:localhost:3306 user@jump_host 或啟用 MySQL SSL (REQUIRE SSL)nmap -p 3306 驗證無回應bind-address = 10.0.0.10 (非 0.0.0.0)DROP USER ''@'%';ALTER USER 'root'@'localhost' IDENTIFIED BY '...'; UPDATE user SET Host='localhost' WHERE User='root';bcrypt/scrypt/Argon2,資料庫僅存哈希validate_password (長度、大小寫、數字、特殊字元、字典檢查)REVOKE ALL ON mysql.user FROM 'app'@'%';GRANT SELECT,INSERT,UPDATE,DELETE ON biz_db.* TO 'app'@'app_server_ip';--safe-updates 或應用層強制LOAD DATA INFILE '/etc/passwd' 讀取系統檔GRANT ... WITH MAX_QUERIES_PER_HOUR 1000 MAX_CONNECTIONS_PER_HOUR 100GRANT SELECT (id, name) ON db.tbl TO 'masked'@'%'; 實現敏感欄位遮罩WITH GRANT OPTION 僅限 DBA,嚴禁應用帳號INSTALL PLUGIN audit_log SONAME 'audit_log.so'; 記錄所有連線/查詢/錯誤SHOW GRANTS;、SELECT User,Host FROM mysql.user;、慢查詢日誌分析systemctl stop mysqld
mysqld_safe --skip-grant-tables &
mysql -u root
FLUSH PRIVILEGES;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewStrongPass#2024';
systemctl restart mysqld
注意:MySQL 8.0 需 FLUSH PRIVILEGES; 後才能 ALTER USER。