mysql -u root -p
USE mysql;
UPDATE user SET host = '%' WHERE user = 'root';
FLUSH PRIVILEGES;
-- 任意 IP
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'StrongPass!';
-- 僅特定 IP
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.100' IDENTIFIED BY 'StrongPass!';
-- 業務帳號(最小權限)
GRANT SELECT,INSERT,UPDATE,DELETE ON app_db.* TO 'app_user'@'192.168.1.%' IDENTIFIED BY 'AppPass!';
FLUSH PRIVILEGES;
[mysqld]
# bind-address = 127.0.0.1 # 註釋或改為
bind-address = 0.0.0.0
service mysqld restart 生效。
# iptables
iptables -I INPUT -p tcp --dport 3306 -j ACCEPT
service iptables save
# firewalld
firewall-cmd --permanent --add-port=3306/tcp
firewall-cmd --reload
# 客戶端
mysql -h -u root -p
telnet 3306
REQUIRE SSL、配置 ssl-ca/cert/key