-- 允許 root 從任意 IP 連接(生產環境慎用!)
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'StrongPassword2024!';
FLUSH PRIVILEGES;
-- 推薦:僅允許特定應用服務器 IP
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.100' IDENTIFIED BY 'StrongPassword2024!';
FLUSH PRIVILEGES;
-- 或建立專用業務帳號(最小權限原則)
GRANT SELECT,INSERT,UPDATE,DELETE ON app_db.* TO 'app_user'@'192.168.1.%' IDENTIFIED BY 'AppPass2024!';
FLUSH PRIVILEGES;
[mysqld]
# 註釋掉或改為 0.0.0.0 監聽所有介面
# bind-address = 127.0.0.1
bind-address = 0.0.0.0
修改後必須 service mysqld restart。
# iptables(CentOS 6/7)
iptables -I INPUT -p tcp --dport 3306 -j ACCEPT
service iptables save
# firewalld(CentOS 7+)
firewall-cmd --permanent --add-port=3306/tcp
firewall-cmd --reload
# ufw(Ubuntu/Debian)
ufw allow 3306/tcp
# 客戶端機器
mysql -h -u root -p
telnet 3306
REQUIRE SSL)