mysql \uc811\uadfc IP \ubcc0\uacbd<\/p>\n
1.\ud638\uc2a4\ub97c % \ub85c \uc9c0\uc815\ud560\uba74 \ubaa8\ub4e0 remote \uc5d0\uc11c \uc811\uc18d \uac00\ub2a5, 10.10.99.% =\u00a0 10.10.99.0 ~ 10.10.99.255<\/p>\n
MySql> update user set host = '10.10.99.%' where user = 'root' and host='localhost';\nMysql> commit;<\/pre>\n\u00a0<\/p>\n
2. MySql \ud658\uacbd \ud30c\uc77c \ubcc0\uacbd<\/p>\n
> sudo vi \/etc\/mysql\/my.conf\nbind-address = 127.0.0.1 --> #bind-address =127.0.0.1 \uc8fc\uc11d\ucc98\ub9ac\ud55c\ub2e4.<\/pre>\n\u00a0<\/p>\n
3. MySql \uc7ac\uc2dc\uc791<\/p>\n
> sudo systemctl mysql restart\n> sudo \/etc\/init.d\/mysql restart (\uad6c\uba85\ub839\uc5b4)<\/pre>\n\u00a0<\/p>\n
4.\ubc29\ud654\ubcbd \uc624\ud508<\/p>\n
# nano \/etc\/sysconfig\/iptables\n\nSimply add (after all of the existing entries):\n\n-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT<\/pre>\n\u00a0<\/p>\n
Lastly, restart iptables:<\/p>\n
# sudo systemctl iptables restart\nsudo etc\/init.d\/iptables restart\u00a0 (\uad6c\uba85\ub839\uc5b4)<\/pre>\n\u00a0<\/p>\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"