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":"
mysql \uc811\uadfc IP \ubcc0\uacbd 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 MySql> update user set host = ‘10.10.99.%’ […]<\/a><\/p>\n<\/div>","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[11],"tags":[],"class_list":["post-121","post","type-post","status-publish","format-standard","hentry","category-centos"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/121","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=121"}],"version-history":[{"count":0,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/121\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=121"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=121"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}