{"id":622,"date":"2026-03-30T10:19:04","date_gmt":"2026-03-30T01:19:04","guid":{"rendered":"https:\/\/ubuntu.auctionpro.co.kr\/?page_id=622"},"modified":"2026-03-30T10:25:02","modified_gmt":"2026-03-30T01:25:02","slug":"mysql-8-0-45-%ec%84%a4%ec%b9%98","status":"publish","type":"page","link":"https:\/\/ubuntu.auctionpro.co.kr\/?page_id=622","title":{"rendered":"mysql 8.0.45 \uc124\uce58"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Mysql \uc124\uce58<\/h4>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:vim decode:true \" title=\"mysql\" >sudo apt install mysql-server -y\n\n\n#\ubcf4\uc548 \uc124\uc815\nsudo mysql_secure_installation\n\n# YES NO\nVALIDATE PASSWORD \u2192 N\nRemove anonymous users \u2192 Y\nDisallow root login remotely \u2192 Y\nRemove test database \u2192 Y\nReload privilege tables \u2192 Y\n\n# \uc811\uc18d\nsudo mysql<\/pre><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">\uacc4\uc815 \uc0dd\uc131<\/h4>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:vim decode:true \" title=\"CREATE USER\">CREATE USER 'admin01'@'%' IDENTIFIED BY '11119999';\nGRANT ALL PRIVILEGES ON *.* TO 'admin01'@'%';\nFLUSH PRIVILEG<\/pre><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">mysql conf<\/h4>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:vim decode:true \">sudo vi \/etc\/mysql\/mysql.conf.d\/mysqld.conf\n\n# \uc8fc\uc11d\ucc98\ub9ac\n \n#bind-address           = 127.0.0.1\n#mysqlx-bind-address    = 127.0.0.1<\/pre><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">mysql \uc7ac\uc2dc\uc791 \/ \ubc29\ud654\ubcbd \uc624\ud508<\/h4>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:vim decode:true \"> sudo systemctl restart mysql\n \n sudo ufw allow mysql<\/pre><\/div>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Mysql \uc124\uce58 \uacc4\uc815 \uc0dd\uc131 mysql conf mysql \uc7ac\uc2dc\uc791 \/ \ubc29\ud654\ubcbd \uc624\ud508<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-622","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/ubuntu.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/pages\/622","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ubuntu.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/ubuntu.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/ubuntu.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ubuntu.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=622"}],"version-history":[{"count":2,"href":"https:\/\/ubuntu.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/pages\/622\/revisions"}],"predecessor-version":[{"id":626,"href":"https:\/\/ubuntu.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/pages\/622\/revisions\/626"}],"wp:attachment":[{"href":"https:\/\/ubuntu.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=622"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}