{"id":4600,"date":"2022-08-30T13:52:24","date_gmt":"2022-08-30T04:52:24","guid":{"rendered":"https:\/\/i-kiin.net\/?p=4600"},"modified":"2023-01-09T16:17:08","modified_gmt":"2023-01-09T07:17:08","slug":"%ec%9a%b0%eb%b6%84%ed%88%ac%ec%97%90%ec%84%9c-mysql-db-%ec%99%b8%eb%b6%80-%ec%a0%91%ec%86%8d-%ed%97%88%ec%9a%a9-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"https:\/\/i-kiin.net\/?p=4600","title":{"rendered":"\uc6b0\ubd84\ud22c\uc5d0\uc11c MySQL DB \uc678\ubd80 \uc811\uc18d \ud5c8\uc6a9 \ubc29\ubc95"},"content":{"rendered":"<p>\uc81c\ubaa9 \uadf8\ub300\ub85c \uc544\ub798\uc640 \uac19\uc740 \ud658\uacbd\uc5d0\uc11c \uc678\ubd80\uc5d0\uc11c MySQL DB\uc5d0 \uc811\uc18d\ud558\ub294 \ubc29\ubc95\uc774\ub2e4.<\/p>\n<ul>\n<li>OS : Ubuntu 22.04<\/li>\n<li>Apache : 2.4.52<\/li>\n<li>PHP : 8.1.2<\/li>\n<li>MySQL : 8.0.30<\/li>\n<li>ufw status : inactive (\ube44\ud65c\uc131)<\/li>\n<li>DBMS Client : DBeaver Community 22.1.5<\/li>\n<\/ul>\n<p>\uc801\uc6a9 \uc804\uc5d0 \uc544\ub798 \uae00\ub4e4\uc744 \ucc38\uace0\ud588\ub2e4.<\/p>\n<ul>\n<li><a href=\"https:\/\/kaminion.tistory.com\/49\" target=\"_blank\" rel=\"nofollow noopener\">\ub9c8\ub9ac\uc544DB(Maria DB) \uc678\ubd80\uc811\uc18d \ud5c8\uc6a9\ubc95 \uc6b0\ubd84\ud22c(ubuntu) 18.0<\/a><\/li>\n<li><a href=\"https:\/\/deeplify.dev\/database\/troubleshoot\/public-key-retrieval-is-not-allowed\" target=\"_blank\" rel=\"nofollow noopener\">[Mysql] Public key retrieval is not allowed \uc5d0\ub7ec \ud574\uacb0<\/a><\/li>\n<li><a href=\"https:\/\/abc1211.tistory.com\/537\" target=\"_blank\" rel=\"nofollow noopener\">\uc6b0\ubd84\ud22c mysql\uc5d0 \uc678\ubd80\uc5d0\uc11c \uc811\uc18d\ud558\uae30<\/a><\/li>\n<\/ul>\n<p>\uc774\uc5b4\uc11c \uc801\uc6a9\ud55c \uc21c\uc11c\ub294 \uc544\ub798\uc640 \uac19\ub2e4.<\/p>\n<ol>\n<li>\ud130\ubbf8\ub110\uc5d0\uc11c <code>netstat -tnlp<\/code>\u00a0 \uc785\ub825<\/li>\n<li><code>127.0.0.1:3306<\/code> \u21d2 <code>localhost(127.0.0.1)<\/code>\ub9cc \uc811\uc18d \uac00\ub2a5\ud558\uace0 \uc678\ubd80 \uc811\uc18d\uc740 \ube44\ud5c8\uc6a9 \uc0c1\ud0dc \ud655\uc778<br \/>\n<a href=\"https:\/\/i-kiin.net\/wp-content\/uploads\/2022\/08\/2022-08-30_104839.png\" rel=\"lightbox\"><img decoding=\"async\" class=\"aligncenter size-full\" src=\"https:\/\/i-kiin.net\/wp-content\/uploads\/2022\/08\/2022-08-30_104839.png\" alt=\"\" width=\"100%\" \/><\/a><\/li>\n<li>\ud130\ubbf8\ub110\uc5d0\uc11c <code>mysql -u root -p<\/code> \uc785\ub825<\/li>\n<li><code>mysql&gt; GRANT ALL PRIVILEGES ON &lt;\uc811\uc18dDB&gt;.* TO '&lt;\uc0ac\uc6a9\uc790\uba85&gt;'@'%';<\/code> \u21d2 \uc678\ubd80 \uc811\uc18d \uac00\ub2a5\ud558\ub3c4\ub85d \uad8c\ud55c \ubd80\uc5ec<\/li>\n<li><code>mysql&gt; flush privileges;<\/code><\/li>\n<li><code>mysql&gt; commit;<\/code><\/li>\n<li><code>mysql&gt; quit<\/code><\/li>\n<li><code>sudo vi \/etc\/mysql\/mysql.cnf<\/code> \uc785\ub825\ud558\uc5ec <span style=\"color: #ff0000;\"><strong>[Before]<\/strong><\/span>\ub97c <span style=\"color: #0000ff;\"><strong>[After]<\/strong><\/span>\ub85c \uc218\uc815<br \/>\n<span style=\"color: #ff0000;\"><strong>[Before]<\/strong><\/span><\/p>\n<pre>#\r\n# The MySQL database server configuration file.\r\n#\r\n# You can copy this to one of:\r\n# - \"\/etc\/mysql\/my.cnf\" to set global options,\r\n# - \"~\/.my.cnf\" to set user-specific options.\r\n#\r\n# One can use all long options that the program supports.\r\n# Run program with --help to get a list of available options and with\r\n# --print-defaults to see which it would actually understand and use.\r\n#\r\n# For explanations see\r\n# http:\/\/dev.mysql.com\/doc\/mysql\/en\/server-system-variables.html\r\n\r\n#\r\n# * IMPORTANT: Additional settings that can override those from this file!\r\n#\u00a0\u00a0 The files must end with '.cnf', otherwise they'll be ignored.\r\n#\r\n\r\n!includedir \/etc\/mysql\/conf.d\/\r\n!includedir \/etc\/mysql\/mysql.conf.d\/<\/pre>\n<p><span style=\"color: #0000ff;\"><strong>[After]<\/strong><\/span><\/p>\n<pre>#\r\n# The MySQL database server configuration file.\r\n#\r\n# You can copy this to one of:\r\n# - \"\/etc\/mysql\/my.cnf\" to set global options,\r\n# - \"~\/.my.cnf\" to set user-specific options.\r\n#\r\n# One can use all long options that the program supports.\r\n# Run program with --help to get a list of available options and with\r\n# --print-defaults to see which it would actually understand and use.\r\n#\r\n# For explanations see\r\n# http:\/\/dev.mysql.com\/doc\/mysql\/en\/server-system-variables.html\r\n\r\n#\r\n# * IMPORTANT: Additional settings that can override those from this file!\r\n#\u00a0\u00a0 The files must end with '.cnf', otherwise they'll be ignored.\r\n#\r\n\r\n!includedir \/etc\/mysql\/conf.d\/\r\n!includedir \/etc\/mysql\/mysql.conf.d\/\r\n\r\n[mysqld]\t\t\t# \ucd94\uac00\r\nport=3306 # or any other port\t# \ucd94\uac00\r\nbind-address=0.0.0.0\t\t# \ucd94\uac00<\/pre>\n<\/li>\n<li><code>sudo systemctl restart mysql<\/code> \uc785\ub825\ud558\uc5ec <code>mysql<\/code> \uc7ac\uae30\ub3d9<\/li>\n<\/ol>\n<p>\uc544\ub798\ub294 \uc0c1\uae30 \uc801\uc6a9\ud55c \ub0b4\uc6a9\uacfc \uad00\ub828\ub41c \uc774\ubbf8\uc9c0\ub4e4\uc774\ub2e4.<\/p>\n<p><a href=\"https:\/\/i-kiin.net\/wp-content\/uploads\/2022\/08\/2022-08-30_111048.png\" rel=\"lightbox\"><img decoding=\"async\" class=\"aligncenter size-full\" src=\"https:\/\/i-kiin.net\/wp-content\/uploads\/2022\/08\/2022-08-30_111048.png\" alt=\"\" width=\"100%\" \/><\/a><br \/>\n<a href=\"https:\/\/i-kiin.net\/wp-content\/uploads\/2022\/08\/2022-08-30_114444.png\" rel=\"lightbox\"><img decoding=\"async\" class=\"aligncenter size-full\" src=\"https:\/\/i-kiin.net\/wp-content\/uploads\/2022\/08\/2022-08-30_114444.png\" alt=\"\" width=\"100%\" \/><\/a><br \/>\n<a href=\"https:\/\/i-kiin.net\/wp-content\/uploads\/2022\/08\/2022-08-30_115423.png\" rel=\"lightbox\"><img decoding=\"async\" class=\"aligncenter size-full\" src=\"https:\/\/i-kiin.net\/wp-content\/uploads\/2022\/08\/2022-08-30_115423.png\" alt=\"\" width=\"100%\" \/><\/a><br \/>\n<a href=\"https:\/\/i-kiin.net\/wp-content\/uploads\/2022\/08\/2022-08-30_131450.png\" rel=\"lightbox\"><img decoding=\"async\" class=\"aligncenter size-full\" src=\"https:\/\/i-kiin.net\/wp-content\/uploads\/2022\/08\/2022-08-30_131450.png\" alt=\"\" width=\"100%\" \/><\/a><\/p>\n<p>\uc870\ud68c\uc218: 14<\/p>","protected":false},"excerpt":{"rendered":"<p>\uc81c\ubaa9 \uadf8\ub300\ub85c \uc544\ub798\uc640 \uac19\uc740 \ud658\uacbd\uc5d0\uc11c \uc678\ubd80\uc5d0\uc11c MySQL DB\uc5d0 \uc811\uc18d\ud558\ub294 \ubc29\ubc95\uc774\ub2e4. OS : Ubuntu 22.04 Apache : 2.4.52 PHP : 8.1.2 MySQL : 8.0.30 ufw status : inactive (\ube44\ud65c\uc131) DBMS Client : DBeaver Community 22.1.5 \uc801\uc6a9 \uc804\uc5d0 \uc544\ub798 \uae00\ub4e4\uc744 \ucc38\uace0\ud588\ub2e4. \ub9c8\ub9ac\uc544DB(Maria DB) \uc678\ubd80\uc811\uc18d \ud5c8\uc6a9\ubc95 \uc6b0\ubd84\ud22c(ubuntu) 18.0 [Mysql] Public key retrieval is not allowed \uc5d0\ub7ec \ud574\uacb0 \uc6b0\ubd84\ud22c &#8230; <a title=\"\uc6b0\ubd84\ud22c\uc5d0\uc11c MySQL DB \uc678\ubd80 \uc811\uc18d \ud5c8\uc6a9 \ubc29\ubc95\" class=\"read-more\" href=\"https:\/\/i-kiin.net\/?p=4600\" aria-label=\"\uc6b0\ubd84\ud22c\uc5d0\uc11c MySQL DB \uc678\ubd80 \uc811\uc18d \ud5c8\uc6a9 \ubc29\ubc95\uc5d0 \ub300\ud574 \ub354 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\uc138\uc694\">\ub354 \uc77d\uae30<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[483],"tags":[1378,2349,2928],"class_list":["post-4600","post","type-post","status-publish","format-standard","hentry","category-pc-and-pc","tag-ubuntu","tag-2349","tag-mysql"],"_links":{"self":[{"href":"https:\/\/i-kiin.net\/index.php?rest_route=\/wp\/v2\/posts\/4600","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/i-kiin.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/i-kiin.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/i-kiin.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/i-kiin.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4600"}],"version-history":[{"count":0,"href":"https:\/\/i-kiin.net\/index.php?rest_route=\/wp\/v2\/posts\/4600\/revisions"}],"wp:attachment":[{"href":"https:\/\/i-kiin.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4600"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/i-kiin.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4600"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/i-kiin.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4600"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}