{"id":1986,"date":"2024-02-15T22:20:07","date_gmt":"2024-02-15T13:20:07","guid":{"rendered":"https:\/\/dohokin.com\/?p=1986"},"modified":"2024-02-16T00:51:44","modified_gmt":"2024-02-15T15:51:44","slug":"%ec%9a%b0%eb%b6%84%ed%88%ac-mysql","status":"publish","type":"post","link":"https:\/\/dohokin.com\/?p=1986","title":{"rendered":"\uc6b0\ubd84\ud22c mysql"},"content":{"rendered":"\n<p><strong>MySQL \uc124\uce58<\/strong><\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro padding-bottom-disabled cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#657B83;--cbp-line-number-width:calc(1 * 0.6 * .875rem);line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#fbeecb;color:#708891\">Bash<\/span><span role=\"button\" tabindex=\"0\" data-code=\"sudo apt update\nsudo apt install mysql-server\" style=\"color:#FDF6E3;display:none;background-color:#657B83\" aria-label=\"Copy\" data-copied-text=\"Copied!\" data-has-text-button=\"textSimple\" data-inside-header-type=\"simpleString\" aria-live=\"polite\" class=\"code-block-pro-copy-button\"><span class=\"cbp-btn-text\">Copy<\/span><\/span><pre class=\"shiki solarized-light\" style=\"background-color: #FDF6E3\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #268BD2\">sudo<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">apt<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">update<\/span><\/span>\n<span class=\"line\"><span style=\"color: #268BD2\">sudo<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">apt<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">install<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">mysql-server<\/span><\/span><\/code><\/pre><span style=\"display:flex;align-items:flex-end;padding:10px;width:100%;justify-content:flex-end;background-color:#FDF6E3;color:#708891;font-size:12px;line-height:1;position:relative\">Bash<\/span><\/div>\n\n\n\n<p>MySQL \ubc29\ud654\ubcbd \ud5c8\uc6a9<\/p>\n\n\n\n<p><code>sudo ufw allow mysql<\/code> \uba85\ub839\uc5b4\ub294 \ub9ac\ub205\uc2a4 \uc6b0\ubd84\ud22c\uc5d0\uc11c <code>ufw<\/code> (Uncomplicated Firewall) \ubc29\ud654\ubcbd\uc744 \uc0ac\uc6a9\ud558\uc5ec MySQL \uc11c\ube44\uc2a4\uc5d0 \ub300\ud55c \ub124\ud2b8\uc6cc\ud06c \uc811\uadfc\uc744 \ud5c8\uc6a9\ud558\ub294 \uc124\uc815\uc744 \ud569\ub2c8\ub2e4. \uc774 \uba85\ub839\uc5b4\ub97c \ubd84\uc11d\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \uc758\ubbf8\ub97c \uac00\uc9d1\ub2c8\ub2e4:<\/p>\n\n\n\n<ul>\n<li><code>sudo<\/code>: Superuser do\uc758 \uc57d\uc790\ub85c, \uc774 \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub8e8\ud2b8 \uc0ac\uc6a9\uc790(\uc288\ud37c\uc720\uc800) \uad8c\ud55c\uc73c\ub85c \uba85\ub839\uc744 \uc2e4\ud589\ud569\ub2c8\ub2e4. \ub9ac\ub205\uc2a4\uc5d0\uc11c\ub294 \ubcf4\uc548\uc0c1\uc758 \uc774\uc720\ub85c \uc77c\ubc18 \uc0ac\uc6a9\uc790\uac00 \ubbfc\uac10\ud55c \uc2dc\uc2a4\ud15c \uc124\uc815\uc744 \ubcc0\uacbd\ud560 \uc218 \uc5c6\uae30 \ub54c\ubb38\uc5d0, <code>sudo<\/code>\ub97c \ud1b5\ud574 \uc784\uc2dc\ub85c \ub192\uc740 \uad8c\ud55c\uc744 \uc5bb\uc5b4 \uc774\ub7f0 \uc791\uc5c5\uc744 \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>ufw<\/code>: Uncomplicated Firewall\uc758 \uc57d\uc790\ub85c, \uc6b0\ubd84\ud22c\uc5d0\uc11c \uae30\ubcf8\uc801\uc73c\ub85c \uc81c\uacf5\ud558\ub294 \uc0ac\uc6a9\ud558\uae30 \uc26c\uc6b4 \ubc29\ud654\ubcbd \uad00\ub9ac \ub3c4\uad6c\uc785\ub2c8\ub2e4. <code>ufw<\/code>\ub294 iptables\uc758 \ubcf5\uc7a1\uc131\uc744 \ucd94\uc0c1\ud654\ud558\uc5ec \uc0ac\uc6a9\uc790\uac00 \ub354 \uac04\ub2e8\ud558\uac8c \ubc29\ud654\ubcbd \uaddc\uce59\uc744 \uad00\ub9ac\ud560 \uc218 \uc788\uac8c \ud574\uc90d\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>allow<\/code>: \uc774 \uc635\uc158\uc740 \uc9c0\uc815\ub41c \uc11c\ube44\uc2a4, \ud3ec\ud2b8, \ub610\ub294 IP \ubc94\uc704\ub85c\uc758 \ub124\ud2b8\uc6cc\ud06c \uc811\uadfc\uc744 \ud5c8\uc6a9\ud558\ub3c4\ub85d <code>ufw<\/code>\uc5d0 \uc9c0\uc2dc\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>mysql<\/code>: \uc774 \ubd80\ubd84\uc740 \ud5c8\uc6a9\ud558\ub824\ub294 \uc11c\ube44\uc2a4\uc758 \uc774\ub984\uc785\ub2c8\ub2e4. \uc5ec\uae30\uc11c\ub294 MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\ub97c \uc758\ubbf8\ud569\ub2c8\ub2e4. <code>ufw<\/code>\ub294 <code>\/etc\/services<\/code> \ud30c\uc77c\uc744 \ucc38\uc870\ud558\uc5ec <code>mysql<\/code>\uc774\ub77c\ub294 \uc774\ub984\uc5d0 \ud574\ub2f9\ud558\ub294 \ud3ec\ud2b8 \ubc88\ud638(\uae30\ubcf8\uc801\uc73c\ub85c TCP 3306)\ub97c \ucc3e\uc544 \uadf8 \ud3ec\ud2b8\ub85c\uc758 \uc811\uadfc\uc744 \ud5c8\uc6a9\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n<p>\uacb0\ub860\uc801\uc73c\ub85c, <code>sudo ufw allow mysql<\/code> \uba85\ub839\uc5b4\ub294 \uc6b0\ubd84\ud22c \uc2dc\uc2a4\ud15c\uc5d0\uc11c MySQL \uc11c\ubc84\ub85c\uc758 \ub124\ud2b8\uc6cc\ud06c \uc811\uadfc\uc744 \ud5c8\uc6a9\ud558\ub3c4\ub85d \ubc29\ud654\ubcbd \uaddc\uce59\uc744 \uc124\uc815\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \uc774 \uc124\uc815\uc740 \uc6d0\uaca9 \uc704\uce58\uc5d0\uc11c MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc811\uadfc\ud558\ub824\ub294 \uacbd\uc6b0 \ud544\uc694\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro padding-bottom-disabled cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#657B83;--cbp-line-number-width:calc(1 * 0.6 * .875rem);line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#fbeecb;color:#708891\">Bash<\/span><span role=\"button\" tabindex=\"0\" data-code=\"sudo ufw allow mysql\" style=\"color:#FDF6E3;display:none;background-color:#657B83\" aria-label=\"Copy\" data-copied-text=\"Copied!\" data-has-text-button=\"textSimple\" data-inside-header-type=\"simpleString\" aria-live=\"polite\" class=\"code-block-pro-copy-button\"><span class=\"cbp-btn-text\">Copy<\/span><\/span><pre class=\"shiki solarized-light\" style=\"background-color: #FDF6E3\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #268BD2\">sudo<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">ufw<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">allow<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">mysql<\/span><\/span><\/code><\/pre><span style=\"display:flex;align-items:flex-end;padding:10px;width:100%;justify-content:flex-end;background-color:#FDF6E3;color:#708891;font-size:12px;line-height:1;position:relative\">Bash<\/span><\/div>\n\n\n\n<p><strong>MySQL \uc2e4\ud589<\/strong><\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro padding-bottom-disabled cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#657B83;--cbp-line-number-width:calc(1 * 0.6 * .875rem);line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#fbeecb;color:#708891\">Bash<\/span><span role=\"button\" tabindex=\"0\" data-code=\"sudo systemctl start mysql\" style=\"color:#FDF6E3;display:none;background-color:#657B83\" aria-label=\"Copy\" data-copied-text=\"Copied!\" data-has-text-button=\"textSimple\" data-inside-header-type=\"simpleString\" aria-live=\"polite\" class=\"code-block-pro-copy-button\"><span class=\"cbp-btn-text\">Copy<\/span><\/span><pre class=\"shiki solarized-light\" style=\"background-color: #FDF6E3\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #268BD2\">sudo<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">systemctl<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">start<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">mysql<\/span><\/span><\/code><\/pre><span style=\"display:flex;align-items:flex-end;padding:10px;width:100%;justify-content:flex-end;background-color:#FDF6E3;color:#708891;font-size:12px;line-height:1;position:relative\">Bash<\/span><\/div>\n\n\n\n<p><code>sudo systemctl enable mysql<\/code> \uba85\ub839\uc5b4\ub294 \uc2dc\uc2a4\ud15c \ubd80\ud305 \uc2dc \uc790\ub3d9\uc73c\ub85c MySQL \uc11c\ube44\uc2a4\ub97c \uc2dc\uc791\ud558\ub3c4\ub85d \uc124\uc815\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. \uc774 \uba85\ub839\uc5b4\uc758 \uac01 \ubd80\ubd84\uc740 \ub2e4\uc74c\uacfc \uac19\uc740 \uc758\ubbf8\ub97c \uac00\uc9d1\ub2c8\ub2e4:<\/p>\n\n\n\n<ul>\n<li><code>sudo<\/code>: \uc774 \uba85\ub839\uc5b4\ub294 \uc288\ud37c\uc720\uc800 \uad8c\ud55c\uc73c\ub85c \ub2e4\ub978 \uba85\ub839\uc744 \uc2e4\ud589\ud560 \uc218 \uc788\uac8c \ud574\uc90d\ub2c8\ub2e4. \uc2dc\uc2a4\ud15c \uc11c\ube44\uc2a4 \uc124\uc815\uc744 \ubcc0\uacbd\ud558\ub294 \uac83\uc740 \uc77c\ubc18\uc801\uc73c\ub85c \ub192\uc740 \uad8c\ud55c\uc744 \uc694\uad6c\ud558\uae30 \ub54c\ubb38\uc5d0 <code>sudo<\/code>\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>systemctl<\/code>: <code>systemctl<\/code>\uc740 systemd \uc2dc\uc2a4\ud15c\uacfc \uc11c\ube44\uc2a4 \ub9e4\ub2c8\uc800\uc758 \ucee4\ub9e8\ub4dc\ub77c\uc778 \uc778\ud130\ud398\uc774\uc2a4\uc785\ub2c8\ub2e4. Linux \uc2dc\uc2a4\ud15c\uc5d0\uc11c \uc11c\ube44\uc2a4(\ub370\ubaac)\ub97c \uad00\ub9ac\ud558\uace0 \uc2dc\uc2a4\ud15c \uc0c1\ud0dc\ub97c \uac80\uc0ac\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>enable<\/code>: \uc774 \uc635\uc158\uc740 \uc9c0\uc815\ub41c \uc11c\ube44\uc2a4\uac00 \uc2dc\uc2a4\ud15c \ubd80\ud305 \uc2dc \uc790\ub3d9\uc73c\ub85c \uc2dc\uc791\ub418\ub3c4\ub85d \uc124\uc815\ud569\ub2c8\ub2e4. \uc774\uac83\uc740 \uc11c\ube44\uc2a4\uc758 \uc2ec\ubcfc\ub9ad \ub9c1\ud06c\ub97c \uc0dd\uc131\ud558\uc5ec \ud574\ub2f9 \uc11c\ube44\uc2a4\uac00 \ubd80\ud305 \uc2dc\uc5d0 \uc2dc\uc791\ub418\ub3c4\ub85d systemd\uc758 \uad6c\uc131\uc5d0 \ucd94\uac00\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>mysql<\/code>: \uc774 \ubd80\ubd84\uc740 \uba85\ub839\uc5b4\uac00 \uc801\uc6a9\ub420 \uc11c\ube44\uc2a4\uc758 \uc774\ub984\uc785\ub2c8\ub2e4. \uc5ec\uae30\uc11c\ub294 MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\ub97c \uc758\ubbf8\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n<p><code>sudo systemctl enable mysql<\/code> \uba85\ub839\uc5b4\ub97c \uc2e4\ud589\ud558\uba74, \uc2dc\uc2a4\ud15c\uc774 \ubd80\ud305\ub420 \ub54c MySQL \uc11c\ube44\uc2a4\uac00 \uc790\ub3d9\uc73c\ub85c \uc2dc\uc791\ub418\ub3c4\ub85d systemd\uc5d0 \ub4f1\ub85d\ub429\ub2c8\ub2e4. \uc774\ub294 MySQL\uc744 \uc0ac\uc6a9\ud558\ub294 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc774 \uc2dc\uc2a4\ud15c \uc2dc\uc791 \uc2dc \ubc14\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc811\uadfc\ud560 \uc218 \uc788\ub3c4\ub85d \ud574\uc90d\ub2c8\ub2e4. MySQL \uc11c\ube44\uc2a4\uac00 \uc774 \uba85\ub839\uc5b4\ub85c \ud65c\uc131\ud654\ub418\uba74, \uc218\ub3d9\uc73c\ub85c \uc11c\ube44\uc2a4\ub97c \uc2dc\uc791\ud560 \ud544\uc694 \uc5c6\uc774 \uc2dc\uc2a4\ud15c\uc774 \uc790\ub3d9\uc73c\ub85c MySQL \uc11c\ubc84\ub97c \uc2e4\ud589\uc2dc\ud0b5\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro padding-bottom-disabled cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#657B83;--cbp-line-number-width:calc(1 * 0.6 * .875rem);line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#fbeecb;color:#708891\">Bash<\/span><span role=\"button\" tabindex=\"0\" data-code=\"sudo systemctl enable mysql\" style=\"color:#FDF6E3;display:none;background-color:#657B83\" aria-label=\"Copy\" data-copied-text=\"Copied!\" data-has-text-button=\"textSimple\" data-inside-header-type=\"simpleString\" aria-live=\"polite\" class=\"code-block-pro-copy-button\"><span class=\"cbp-btn-text\">Copy<\/span><\/span><pre class=\"shiki solarized-light\" style=\"background-color: #FDF6E3\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #268BD2\">sudo<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">systemctl<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">enable<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">mysql<\/span><\/span><\/code><\/pre><span style=\"display:flex;align-items:flex-end;padding:10px;width:100%;justify-content:flex-end;background-color:#FDF6E3;color:#708891;font-size:12px;line-height:1;position:relative\">Bash<\/span><\/div>\n\n\n\n<p><code>sudo systemctl stop mysql<\/code> \uba85\ub839\uc5b4\ub294 \ud604\uc7ac \uc2e4\ud589 \uc911\uc778 MySQL \uc11c\ube44\uc2a4\ub97c \uc911\uc9c0\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. \uc774 \uba85\ub839\uc5b4\uc758 \uac01 \ubd80\ubd84\uc740 \ub2e4\uc74c\uacfc \uac19\uc740 \uc758\ubbf8\ub97c \uac00\uc9d1\ub2c8\ub2e4:<\/p>\n\n\n\n<ul>\n<li><code>sudo<\/code>: \uc774 \uba85\ub839\uc5b4\ub294 \ub192\uc740 \uad8c\ud55c(\uc288\ud37c\uc720\uc800 \uad8c\ud55c)\uc73c\ub85c \ub2e4\ub978 \uba85\ub839\uc744 \uc2e4\ud589\ud560 \uc218 \uc788\uac8c \ud574\uc8fc\uba70, \uc2dc\uc2a4\ud15c \uc11c\ube44\uc2a4\ub97c \uc911\uc9c0\uc2dc\ud0a4\ub294 \uc791\uc5c5\uc740 \uc77c\ubc18\uc801\uc73c\ub85c \ub192\uc740 \uad8c\ud55c\uc744 \uc694\uad6c\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>systemctl<\/code>: <code>systemctl<\/code>\uc740 systemd, \uc2dc\uc2a4\ud15c \ubc0f \uc11c\ube44\uc2a4 \ub9e4\ub2c8\uc800\uc758 \ucee4\ub9e8\ub4dc\ub77c\uc778 \uc778\ud130\ud398\uc774\uc2a4\ub85c, Linux \uc2dc\uc2a4\ud15c\uc5d0\uc11c \uc11c\ube44\uc2a4(\ub610\ub294 \ub370\ubaac)\ub97c \uad00\ub9ac\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>stop<\/code>: \uc774 \uc635\uc158\uc740 \uc9c0\uc815\ub41c \uc11c\ube44\uc2a4\ub97c \uc911\uc9c0\ud569\ub2c8\ub2e4. \uc11c\ube44\uc2a4\uac00 \ud604\uc7ac \uc2e4\ud589 \uc911\uc778 \uacbd\uc6b0, \uc774 \uba85\ub839\uc5b4\ub294 \uadf8 \uc11c\ube44\uc2a4\uc758 \uc2e4\ud589\uc744 \uba48\ucd94\uac8c \ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>mysql<\/code>: \uc774 \ubd80\ubd84\uc740 \uba85\ub839\uc5b4\uc758 \ub300\uc0c1\uc774 \ub418\ub294 \uc11c\ube44\uc2a4\uc758 \uc774\ub984\uc785\ub2c8\ub2e4. \uc5ec\uae30\uc11c\ub294 MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\ub97c \uc758\ubbf8\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n<p>\ub530\ub77c\uc11c, <code>sudo systemctl stop mysql<\/code> \uba85\ub839\uc5b4\ub97c \uc2e4\ud589\ud558\uba74, \uc2dc\uc2a4\ud15c\uc740 MySQL \uc11c\ube44\uc2a4\ub97c \uc548\uc804\ud558\uac8c \uc911\uc9c0\uc2dc\ud0b5\ub2c8\ub2e4. \uc774 \uc791\uc5c5\uc740 \uc720\uc9c0\ubcf4\uc218\ub97c \uc704\ud574 MySQL \uc11c\ubc84\ub97c \uc784\uc2dc\ub85c \uc911\uc9c0\uc2dc\ud0a4\uac70\ub098, \uc2dc\uc2a4\ud15c \ub9ac\uc18c\uc2a4\ub97c \ud655\ubcf4\ud558\uae30 \uc704\ud574, \ub610\ub294 \uc11c\ubc84 \uad6c\uc131\uc744 \ubcc0\uacbd\ud558\uae30 \uc804\uc5d0 \uc2e4\ud589\ub418\ub294 \uc11c\ube44\uc2a4\ub97c \uba48\ucd94\uace0\uc790 \ud560 \ub54c \uc720\uc6a9\ud569\ub2c8\ub2e4. MySQL \uc11c\ube44\uc2a4\ub97c \ub2e4\uc2dc \uc2dc\uc791\ud558\ub824\uba74, <code>sudo systemctl start mysql<\/code> \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uba74 \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro padding-bottom-disabled cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#657B83;--cbp-line-number-width:calc(1 * 0.6 * .875rem);line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#fbeecb;color:#708891\">Bash<\/span><span role=\"button\" tabindex=\"0\" data-code=\"sudo systemctl stop mysql\" style=\"color:#FDF6E3;display:none;background-color:#657B83\" aria-label=\"Copy\" data-copied-text=\"Copied!\" data-has-text-button=\"textSimple\" data-inside-header-type=\"simpleString\" aria-live=\"polite\" class=\"code-block-pro-copy-button\"><span class=\"cbp-btn-text\">Copy<\/span><\/span><pre class=\"shiki solarized-light\" style=\"background-color: #FDF6E3\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #268BD2\">sudo<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">systemctl<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">stop<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">mysql<\/span><\/span><\/code><\/pre><span style=\"display:flex;align-items:flex-end;padding:10px;width:100%;justify-content:flex-end;background-color:#FDF6E3;color:#708891;font-size:12px;line-height:1;position:relative\">Bash<\/span><\/div>\n\n\n\n<p><code>sudo mysql -u root<\/code> \uba85\ub839\uc5b4\ub294 Linux \uc2dc\uc2a4\ud15c\uc5d0\uc11c \uc288\ud37c\uc720\uc800 \uad8c\ud55c\uc73c\ub85c MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uc5d0 root \uc0ac\uc6a9\uc790\ub85c \ub85c\uadf8\uc778\ud558\uae30 \uc704\ud574 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. \uac01 \ubd80\ubd84\uc758 \uc758\ubbf8\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:<\/p>\n\n\n\n<ul>\n<li><code>sudo<\/code>: \uc774 \uba85\ub839\uc5b4\ub294 \ub192\uc740 \uad8c\ud55c(\uc288\ud37c\uc720\uc800 \ub610\ub294 \ub8e8\ud2b8 \uad8c\ud55c)\uc73c\ub85c \ub2e4\ub978 \uba85\ub839\uc744 \uc2e4\ud589\ud560 \uc218 \uc788\uac8c \ud574\uc90d\ub2c8\ub2e4. MySQL \uc11c\ubc84\uc5d0 root \uc0ac\uc6a9\uc790\ub85c \uc811\uc18d\ud558\ub294 \uac83\uc740 \uc2dc\uc2a4\ud15c \ub610\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc911\uc694\ud55c \uc124\uc815\uc744 \ubcc0\uacbd\ud560 \uc218 \uc788\ub294 \ubbfc\uac10\ud55c \uc791\uc5c5\uc774\uae30 \ub54c\ubb38\uc5d0, \ub192\uc740 \uad8c\ud55c\uc744 \uc694\uad6c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>mysql<\/code>: \uc774 \ubd80\ubd84\uc740 MySQL \ud074\ub77c\uc774\uc5b8\ud2b8 \ud504\ub85c\uadf8\ub7a8\uc744 \uc2e4\ud589\ud558\ub294 \uba85\ub839\uc5b4\uc785\ub2c8\ub2e4. MySQL \ud074\ub77c\uc774\uc5b8\ud2b8\ub294 \uc0ac\uc6a9\uc790\uac00 MySQL \uc11c\ubc84\uc5d0 \uba85\ub839\uc5b4\ub97c \ubcf4\ub0b4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uad00\ub9ac\ud560 \uc218 \uc788\uac8c \ud574\uc8fc\ub294 \ud130\ubbf8\ub110 \uae30\ubc18\uc758 \uc778\ud130\ud398\uc774\uc2a4\uc785\ub2c8\ub2e4.<\/li>\n\n\n\n<li><code>-u root<\/code>: \uc774 \uc635\uc158\uc740 MySQL \uc11c\ubc84\uc5d0 \ub85c\uadf8\uc778\ud560 \ub54c \uc0ac\uc6a9\ud560 \uc0ac\uc6a9\uc790 \uc774\ub984\uc744 \uc9c0\uc815\ud569\ub2c8\ub2e4. <code>-u<\/code>\ub294 &#8220;user&#8221;\uc758 \uc57d\uc790\uc774\uba70, <code>root<\/code>\ub294 MySQL\uc5d0\uc11c \uac00\uc7a5 \ub192\uc740 \uad8c\ud55c\uc744 \uac00\uc9c4 \uc0ac\uc6a9\uc790 \uacc4\uc815\uc785\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n<p>\uc774 \uba85\ub839\uc5b4\ub97c \uc2e4\ud589\ud558\uba74, \uc2dc\uc2a4\ud15c\uc740 \uc0ac\uc6a9\uc790\ub97c MySQL \uc11c\ubc84\uc758 <code>root<\/code> \uacc4\uc815\uc73c\ub85c \ub85c\uadf8\uc778\ud558\uac8c \ud574\uc90d\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \uc0ac\uc6a9\uc790\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0dd\uc131, \uc0ac\uc6a9\uc790 \uad8c\ud55c \ubcc0\uacbd, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uc815 \ubcc0\uacbd \ub4f1 MySQL \uc11c\ubc84 \uad00\ub9ac\uc640 \uad00\ub828\ub41c \uac70\uc758 \ubaa8\ub4e0 \uc791\uc5c5\uc744 \uc218\ud589\ud560 \uc218 \uc788\uac8c \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ubcf4\uc548\uc0c1\uc758 \uc774\uc720\ub85c, <code>root<\/code> \uacc4\uc815\uc73c\ub85c MySQL\uc5d0 \uc811\uc18d\ud560 \ub54c \ube44\ubc00\ubc88\ud638 \uc785\ub825\uc744 \uc694\uad6c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. MySQL 5.7 \uc774\uc0c1\uc5d0\uc11c\ub294 \ucd08\uae30 \uc124\uce58 \uc2dc <code>root<\/code> \uc0ac\uc6a9\uc790\uc758 \uc778\uc99d \ubc29\uc2dd\uc774 <code>auth_socket<\/code> \ub610\ub294 \ube44\uc2b7\ud55c \uba54\ucee4\ub2c8\uc998\uc73c\ub85c \uc124\uc815\ub420 \uc218 \uc788\uc5b4, <code>sudo<\/code>\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub85c\uadf8\uc778\ud558\ub294 \uacbd\uc6b0 \ube44\ubc00\ubc88\ud638 \uc5c6\uc774 \uc811\uc18d\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \uc774\ub294 \uc124\uc815\uc5d0 \ub530\ub77c \ub2e4\ub97c \uc218 \uc788\uc73c\uba70, \uc77c\ubd80 \ud658\uacbd\uc5d0\uc11c\ub294 <code>root<\/code> \uacc4\uc815\uc758 \ube44\ubc00\ubc88\ud638\ub97c \uc124\uc815\ud558\uace0 \uc0ac\uc6a9\ud574\uc57c \ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro padding-bottom-disabled cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#657B83;--cbp-line-number-width:calc(1 * 0.6 * .875rem);line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#fbeecb;color:#708891\">Bash<\/span><span role=\"button\" tabindex=\"0\" data-code=\"sudo mysql -u root\" style=\"color:#FDF6E3;display:none;background-color:#657B83\" aria-label=\"Copy\" data-copied-text=\"Copied!\" data-has-text-button=\"textSimple\" data-inside-header-type=\"simpleString\" aria-live=\"polite\" class=\"code-block-pro-copy-button\"><span class=\"cbp-btn-text\">Copy<\/span><\/span><pre class=\"shiki solarized-light\" style=\"background-color: #FDF6E3\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #268BD2\">sudo<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">mysql<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #CB4B16\">-u<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">root<\/span><\/span><\/code><\/pre><span style=\"display:flex;align-items:flex-end;padding:10px;width:100%;justify-content:flex-end;background-color:#FDF6E3;color:#708891;font-size:12px;line-height:1;position:relative\">Bash<\/span><\/div>\n\n\n\n<p><code>ALTER USER 'root'@'localhost' IDENTIFIED BY '\ube44\ubc00\ubc88\ud638';<\/code> \uba85\ub839\uc5b4\ub294 MySQL\uc5d0\uc11c <code>root<\/code> \uc0ac\uc6a9\uc790\uc758 \ube44\ubc00\ubc88\ud638\ub97c \ubcc0\uacbd\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. \uc774 \uba85\ub839\uc5b4\uc758 \uad6c\uc870\ub97c \ubd84\uc11d\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:<\/p>\n\n\n\n<ul>\n<li><strong>ALTER USER<\/strong>: \uc774 \uba85\ub839\uc740 MySQL\uc5d0\uc11c \uc0ac\uc6a9\uc790 \uacc4\uc815\uc758 \uc18d\uc131\uc744 \ubcc0\uacbd\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. \uc5ec\uae30\uc11c\ub294 \ud2b9\ud788 \uc0ac\uc6a9\uc790\uc758 \ube44\ubc00\ubc88\ud638\ub97c \ubcc0\uacbd\ud558\ub294 \uc791\uc5c5\uc5d0 \uc801\uc6a9\ub429\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>&#8216;root&#8217;@&#8217;localhost&#8217;<\/strong>: \uc774 \ubd80\ubd84\uc740 \ubcc0\uacbd\ud558\ub824\ub294 \uc0ac\uc6a9\uc790 \uacc4\uc815\uc744 \uc9c0\uc815\ud569\ub2c8\ub2e4. <code>'root'@'localhost'<\/code>\ub294 <code>localhost<\/code>\uc5d0\uc11c \uc5f0\uacb0\ud558\ub294 <code>root<\/code> \uc0ac\uc6a9\uc790\ub97c \uc758\ubbf8\ud569\ub2c8\ub2e4. MySQL\uc5d0\uc11c\ub294 \uc0ac\uc6a9\uc790 \uc774\ub984\uacfc \uadf8 \uc0ac\uc6a9\uc790\uac00 \uc5f0\uacb0\ub418\ub294 \ud638\uc2a4\ud2b8\ub97c \uc870\ud569\ud558\uc5ec \uacc4\uc815\uc744 \uc2dd\ubcc4\ud569\ub2c8\ub2e4. \ub530\ub77c\uc11c, \uac19\uc740 \uc0ac\uc6a9\uc790 \uc774\ub984\uc774\ub77c\ub3c4 \ub2e4\ub978 \ud638\uc2a4\ud2b8\uc5d0\uc11c \uc5f0\uacb0\ud558\ub294 \uacbd\uc6b0 \ub2e4\ub978 \uacc4\uc815\uc73c\ub85c \ucde8\uae09\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>IDENTIFIED BY &#8216;\ube44\ubc00\ubc88\ud638&#8217;<\/strong>: \uc774 \uad6c\ubb38\uc740 \ud574\ub2f9 \uc0ac\uc6a9\uc790 \uacc4\uc815\uc758 \uc0c8 \ube44\ubc00\ubc88\ud638\ub97c \uc124\uc815\ud569\ub2c8\ub2e4. <code>'\ube44\ubc00\ubc88\ud638'<\/code> \uc790\ub9ac\uc5d0\ub294 \uc0ac\uc6a9\uc790\uac00 \uc6d0\ud558\ub294 \uc2e4\uc81c \ube44\ubc00\ubc88\ud638\ub97c \uc785\ub825\ud569\ub2c8\ub2e4. \ube44\ubc00\ubc88\ud638\ub294 \uc548\uc804\uc131\uc744 \uace0\ub824\ud558\uc5ec \ucda9\ubd84\ud788 \ubcf5\uc7a1\ud558\uac8c \uc124\uc815\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n<p>\uc774 \uba85\ub839\uc5b4\ub97c \uc2e4\ud589\ud558\uae30 \uc804\uc5d0\ub294 MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uc5d0 <code>root<\/code> \uc0ac\uc6a9\uc790\ub85c \ub85c\uadf8\uc778\ud574 \uc788\uc5b4\uc57c \ud558\uba70, \uc774\ub97c \uc704\ud574\uc11c\ub294 \uc55e\uc11c \uc5b8\uae09\ud55c <code>sudo mysql -u root<\/code> \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ube44\ubc00\ubc88\ud638 \ubcc0\uacbd \ud6c4\uc5d0\ub294 \uc0c8 \ube44\ubc00\ubc88\ud638\ub97c \uc0ac\uc6a9\ud558\uc5ec <code>root<\/code> \uc0ac\uc6a9\uc790\ub85c MySQL\uc5d0 \ub85c\uadf8\uc778\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ube44\ubc00\ubc88\ud638\ub97c \ubcc0\uacbd\ud558\ub294 \uc791\uc5c5\uc740 \uc911\uc694\ud55c \ubcf4\uc548 \uad00\ub828 \uc791\uc5c5\uc774\ubbc0\ub85c, \ubcc0\uacbd \ud6c4\uc5d0\ub294 \uc0c8 \ube44\ubc00\ubc88\ud638\ub97c \uc548\uc804\ud558\uac8c \ubcf4\uad00\ud558\uace0 \ud544\uc694\ud55c \uacbd\uc6b0\ub9cc \uacf5\uc720\ud574\uc57c \ud569\ub2c8\ub2e4. \ub610\ud55c, \ube44\ubc00\ubc88\ud638\ub97c \uc8fc\uae30\uc801\uc73c\ub85c \ubcc0\uacbd\ud558\uc5ec \uacc4\uc815 \ubcf4\uc548\uc744 \uc720\uc9c0\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro padding-bottom-disabled cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#657B83;--cbp-line-number-width:calc(1 * 0.6 * .875rem);line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#fbeecb;color:#708891\">Bash<\/span><span role=\"button\" tabindex=\"0\" data-code=\"ALTER USER 'root'@'localhost' IDENTIFIED BY '\ube44\ubc00\ubc88\ud638';\" style=\"color:#FDF6E3;display:none;background-color:#657B83\" aria-label=\"Copy\" data-copied-text=\"Copied!\" data-has-text-button=\"textSimple\" data-inside-header-type=\"simpleString\" aria-live=\"polite\" class=\"code-block-pro-copy-button\"><span class=\"cbp-btn-text\">Copy<\/span><\/span><pre class=\"shiki solarized-light\" style=\"background-color: #FDF6E3\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #268BD2\">ALTER<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">USER<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">&#39;root&#39;@&#39;localhost&#39;<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">IDENTIFIED<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">BY<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">&#39;\ube44\ubc00\ubc88\ud638&#39;<\/span><span style=\"color: #657B83\">;<\/span><\/span><\/code><\/pre><span style=\"display:flex;align-items:flex-end;padding:10px;width:100%;justify-content:flex-end;background-color:#FDF6E3;color:#708891;font-size:12px;line-height:1;position:relative\">Bash<\/span><\/div>\n\n\n\n<p>\ube44\ubc00\ubc88\ud638 \ubcc0\uacbd \uc801\uc6a9<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro padding-bottom-disabled cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#657B83;--cbp-line-number-width:calc(1 * 0.6 * .875rem);line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#fbeecb;color:#708891\">Bash<\/span><span role=\"button\" tabindex=\"0\" data-code=\"FLUSH PRIVILEGES;\" style=\"color:#FDF6E3;display:none;background-color:#657B83\" aria-label=\"Copy\" data-copied-text=\"Copied!\" data-has-text-button=\"textSimple\" data-inside-header-type=\"simpleString\" aria-live=\"polite\" class=\"code-block-pro-copy-button\"><span class=\"cbp-btn-text\">Copy<\/span><\/span><pre class=\"shiki solarized-light\" style=\"background-color: #FDF6E3\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #268BD2\">FLUSH<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">PRIVILEGES<\/span><span style=\"color: #657B83\">;<\/span><\/span><\/code><\/pre><span style=\"display:flex;align-items:flex-end;padding:10px;width:100%;justify-content:flex-end;background-color:#FDF6E3;color:#708891;font-size:12px;line-height:1;position:relative\">Bash<\/span><\/div>\n\n\n\n<p><code>UPDATE user SET host='%' WHERE user='root' and host='localhost';<\/code> \uba85\ub839\uc5b4\ub294 MySQL\uc758 <code>user<\/code> \ud14c\uc774\ube14\uc5d0\uc11c <code>root<\/code> \uc0ac\uc6a9\uc790 \uacc4\uc815\uc758 <code>host<\/code> \uac12\uc744 <code>localhost<\/code>\uc5d0\uc11c <code>%<\/code>\ub85c \ubcc0\uacbd\ud558\ub294 SQL \ubb38\uc785\ub2c8\ub2e4. \uc774 \uba85\ub839\uc5b4\ub97c \ud1b5\ud574 \ubcc0\uacbd\ub418\ub294 \uc124\uc815\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:<\/p>\n\n\n\n<ul>\n<li><strong>UPDATE user<\/strong>: <code>user<\/code> \ud14c\uc774\ube14\uc758 \ub808\ucf54\ub4dc\ub97c \uc5c5\ub370\uc774\ud2b8\ud569\ub2c8\ub2e4. MySQL\uc5d0\uc11c <code>user<\/code> \ud14c\uc774\ube14\uc740 \uc2dc\uc2a4\ud15c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc778 <code>mysql<\/code> \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc874\uc7ac\ud558\uba70, MySQL \uc11c\ubc84\uc5d0 \uc811\uc18d\ud560 \uc218 \uc788\ub294 \uc0ac\uc6a9\uc790 \uacc4\uc815\uacfc \uadf8 \uad8c\ud55c\uc744 \uc800\uc7a5\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>SET host=&#8217;%<\/strong>&#8216;: \uc774 \uad6c\ubb38\uc740 <code>host<\/code> \uc5f4\uc758 \uac12\uc744 <code>'%'<\/code>\ub85c \ubcc0\uacbd\ud569\ub2c8\ub2e4. \uc5ec\uae30\uc11c <code>'%'<\/code>\ub294 \ubaa8\ub4e0 \ud638\uc2a4\ud2b8\ub97c \uc758\ubbf8\ud558\ub294 \uc640\uc77c\ub4dc\uce74\ub4dc\uc785\ub2c8\ub2e4. \uc989, \uc774 \ubcc0\uacbd\uc744 \ud1b5\ud574 <code>root<\/code> \uc0ac\uc6a9\uc790 \uacc4\uc815\uc740 \uc5b4\ub5a4 \ud638\uc2a4\ud2b8\uc5d0\uc11c\ub4e0 MySQL \uc11c\ubc84\uc5d0 \uc811\uc18d\ud560 \uc218 \uc788\uac8c \ub429\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>WHERE user=&#8217;root&#8217; and host=&#8217;localhost&#8217;<\/strong>: \uc774 \uc870\uac74\uc740 \ubcc0\uacbd\ud560 \ub808\ucf54\ub4dc\ub97c \ud2b9\uc815\ud569\ub2c8\ub2e4. \uc5ec\uae30\uc11c\ub294 \uc0ac\uc6a9\uc790 \uc774\ub984\uc774 <code>root<\/code>\uc774\uace0 \ud638\uc2a4\ud2b8\uac00 <code>localhost<\/code>\uc778 \uacc4\uc815\uc744 \ucc3e\uc544 \uadf8 <code>host<\/code> \uac12\uc744 \ubcc0\uacbd\ud558\ub77c\ub294 \uc758\ubbf8\uc785\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n<p>\uc774 \uba85\ub839\uc5b4\ub97c \uc2e4\ud589\ud558\uae30 \uc804\uc5d0 \uba87 \uac00\uc9c0 \uc911\uc694\ud55c \uc810\uc744 \uace0\ub824\ud574\uc57c \ud569\ub2c8\ub2e4:<\/p>\n\n\n\n<ol>\n<li><strong>\ubcf4\uc548 \uc704\ud5d8<\/strong>: <code>root<\/code> \uacc4\uc815\uc5d0 \ub300\ud574 \ubaa8\ub4e0 \ud638\uc2a4\ud2b8\uc5d0\uc11c\uc758 \uc811\uc18d\uc744 \ud5c8\uc6a9\ud558\ub294 \uac83\uc740 \ub9e4\uc6b0 \uc704\ud5d8\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <code>root<\/code> \uacc4\uc815\uc740 MySQL \uc11c\ubc84\uc758 \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \ud14c\uc774\ube14\uc5d0 \ub300\ud55c \uad8c\ud55c\uc744 \uac00\uc9c0\uace0 \uc788\uc73c\ubbc0\ub85c, \uc774 \uacc4\uc815\uc758 \uc811\uc18d\uc744 \uc81c\ud55c\ud558\uc9c0 \uc54a\uc73c\uba74 \ubb34\ub2e8 \uc811\uadfc\uc774\ub098 \ud574\ud0b9\uc758 \uc704\ud5d8\uc774 \ucee4\uc9d1\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>\uc801\uc808\ud55c \uc0ac\uc6a9<\/strong>: \ud2b9\uc815 \uc0c1\ud669\uc5d0\uc11c, \uc608\ub97c \ub4e4\uc5b4 \uac1c\ubc1c \ud658\uacbd\uc5d0\uc11c \uc5ec\ub7ec \ud638\uc2a4\ud2b8\uc5d0\uc11c\uc758 \uc811\uc18d\uc774 \ud544\uc694\ud558\uac70\ub098, \uc6d0\uaca9 \uad00\ub9ac\uac00 \ud544\uc694\ud55c \uacbd\uc6b0\uc5d0 \ud55c\ud574 \uc774\ub7f0 \uc124\uc815\uc744 \uc801\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uc774 \uacbd\uc6b0\uc5d0\ub3c4 VPN \uac19\uc740 \uc548\uc804\ud55c \uc811\uc18d \ubc29\ubc95\uc744 \uc0ac\uc6a9\ud558\uac70\ub098, \uac00\ub2a5\ud558\ub2e4\uba74 IP \uc8fc\uc18c\ub97c \uc81c\ud55c\ud558\ub294 \ubc29\ubc95\uc73c\ub85c \uc811\uadfc\uc744 \uc81c\uc5b4\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>\uc2e4\ud589 \uc804 \uc8fc\uc758\uc0ac\ud56d<\/strong>: \uc774 \uba85\ub839\uc5b4\ub294 MySQL\uc758 \uc2dc\uc2a4\ud15c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc9c1\uc811 \ubcc0\uacbd\uc744 \uac00\ud558\ubbc0\ub85c, \uc2e4\ud589 \uc804\uc5d0\ub294 \ud574\ub2f9 \ubcc0\uacbd\uc774 \uc2dc\uc2a4\ud15c\uc5d0 \ubbf8\uce60 \uc601\ud5a5\uc744 \ucda9\ubd84\ud788 \uc774\ud574\ud558\uace0 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4. \ub610\ud55c, \ubcc0\uacbd \uc0ac\ud56d\uc744 \uc801\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294 MySQL \uc11c\ubc84\ub97c \uc7ac\uc2dc\uc791\ud558\uac70\ub098, <code>FLUSH PRIVILEGES;<\/code> \uba85\ub839\uc5b4\ub97c \uc2e4\ud589\ud558\uc5ec \uad8c\ud55c \ubcc0\uacbd \uc0ac\ud56d\uc744 \uc801\uc6a9\ud574\uc57c \ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n\n\n<p>\uc704 \uba85\ub839\uc5b4\ub294 \uc2e4\uc81c \uc791\uc5c5 \ud658\uacbd\uc5d0\uc11c\ub294 \ub9e4\uc6b0 \uc2e0\uc911\ud558\uac8c \uc0ac\uc6a9\ud574\uc57c \ud558\ub294 \uba85\ub839\uc5b4\uc785\ub2c8\ub2e4. \uac00\ub2a5\ud558\uba74, \ubcf4\ub2e4 \uc548\uc804\ud55c \ubc29\ubc95\uc73c\ub85c \ud544\uc694\ud55c \uc811\uc18d \uc81c\uc5b4\ub97c \uc124\uc815\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro padding-bottom-disabled cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#657B83;--cbp-line-number-width:calc(1 * 0.6 * .875rem);line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#fbeecb;color:#708891\">Bash<\/span><span role=\"button\" tabindex=\"0\" data-code=\"UPDATE user SET host='%' WHERE user='root' and host='localhost';\" style=\"color:#FDF6E3;display:none;background-color:#657B83\" aria-label=\"Copy\" data-copied-text=\"Copied!\" data-has-text-button=\"textSimple\" data-inside-header-type=\"simpleString\" aria-live=\"polite\" class=\"code-block-pro-copy-button\"><span class=\"cbp-btn-text\">Copy<\/span><\/span><pre class=\"shiki solarized-light\" style=\"background-color: #FDF6E3\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #268BD2\">UPDATE<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">user<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">SET<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">host=&#39;%&#39;<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">WHERE<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">user=&#39;root&#39;<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">and<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">host=&#39;localhost&#39;<\/span><span style=\"color: #657B83\">;<\/span><\/span><\/code><\/pre><span style=\"display:flex;align-items:flex-end;padding:10px;width:100%;justify-content:flex-end;background-color:#FDF6E3;color:#708891;font-size:12px;line-height:1;position:relative\">Bash<\/span><\/div>\n\n\n\n<p>\uc6b0\ubd84\ud22c(Ubuntu)\uc5d0\uc11c SQL \ud30c\uc77c\uc744 \uc2e4\ud589\ud558\ub294 \ubc29\ubc95\uc740 \uc8fc\ub85c MySQL\uc774\ub098 MariaDB\uc640 \uac19\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4. SQL \ud30c\uc77c\uc5d0\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad6c\uc870\ub97c \uc0dd\uc131\ud558\uac70\ub098, \ub370\uc774\ud130\ub97c \uc0bd\uc785\ud558\uac70\ub098, \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc5c5\ub370\uc774\ud2b8\ud558\ub294 \ub4f1\uc758 SQL \uba85\ub839\ubb38\uc774 \ud3ec\ud568\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \ud30c\uc77c\uc744 \uc2e4\ud589\ud558\ub294 \uac00\uc7a5 \uc77c\ubc18\uc801\uc778 \ubc29\ubc95\uc740 \uba85\ub839\uc904 \uc778\ud130\ud398\uc774\uc2a4\ub97c \uc0ac\uc6a9\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \ub2e4\uc74c\uc740 MySQL\uc744 \uc608\ub85c \ub4e4\uc5b4 SQL \ud30c\uc77c\uc744 \uc2e4\ud589\ud558\ub294 \ubc29\ubc95\uc744 \uc124\uba85\ud569\ub2c8\ub2e4:<\/p>\n\n\n\n<ol>\n<li><strong>\ud130\ubbf8\ub110 \uc5f4\uae30<\/strong>: \uc6b0\ubd84\ud22c\uc5d0\uc11c\ub294 Ctrl+Alt+T\ub97c \ub20c\ub7ec \ud130\ubbf8\ub110\uc744 \uc5f4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uc5d0 \ub85c\uadf8\uc778\ud558\uae30<\/strong>: \ub2e4\uc74c \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uc5d0 \ub85c\uadf8\uc778\ud569\ub2c8\ub2e4. \uc5ec\uae30\uc11c <code>root<\/code>\ub294 \uc0ac\uc6a9\uc790 \uc774\ub984\uc774\uba70, \ud574\ub2f9 \uc0ac\uc6a9\uc790\uc758 \ube44\ubc00\ubc88\ud638\uac00 \ud544\uc694\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <code>mysql -u root -p<\/code><\/li>\n\n\n\n<li><strong>SQL \ud30c\uc77c \uc2e4\ud589\ud558\uae30<\/strong>: \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ub85c\uadf8\uc778\ud55c \ud6c4, SQL \ud30c\uc77c\uc744 \uc2e4\ud589\ud558\ub824\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc120\ud0dd\ud558\uace0 SQL \ud30c\uc77c\uc744 \uc2e4\ud589\ud569\ub2c8\ub2e4. SQL \ud30c\uc77c\uc744 \uc2e4\ud589\ud558\ub294 \uba85\ub839\uc5b4\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. \uc5ec\uae30\uc11c <code>database_name<\/code>\uc740 SQL \ud30c\uc77c\uc744 \uc2e4\ud589\ud558\ub824\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc774\ub984\uc774\uba70, <code>\/path\/to\/your\/file.sql<\/code>\uc740 \uc2e4\ud589\ud558\ub824\ub294 SQL \ud30c\uc77c\uc758 \uacbd\ub85c\uc785\ub2c8\ub2e4. <\/li>\n\n\n\n<li><\/li>\n<\/ol>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro padding-bottom-disabled cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#657B83;--cbp-line-number-width:calc(1 * 0.6 * .875rem);line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#fbeecb;color:#708891\">Bash<\/span><span role=\"button\" tabindex=\"0\" data-code=\"USE database_name; \" style=\"color:#FDF6E3;display:none;background-color:#657B83\" aria-label=\"Copy\" data-copied-text=\"Copied!\" data-has-text-button=\"textSimple\" data-inside-header-type=\"simpleString\" aria-live=\"polite\" class=\"code-block-pro-copy-button\"><span class=\"cbp-btn-text\">Copy<\/span><\/span><pre class=\"shiki solarized-light\" style=\"background-color: #FDF6E3\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #268BD2\">USE<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">database_name<\/span><span style=\"color: #657B83\">; <\/span><\/span><\/code><\/pre><span style=\"display:flex;align-items:flex-end;padding:10px;width:100%;justify-content:flex-end;background-color:#FDF6E3;color:#708891;font-size:12px;line-height:1;position:relative\">Bash<\/span><\/div>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro padding-bottom-disabled cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#657B83;--cbp-line-number-width:calc(1 * 0.6 * .875rem);line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#fbeecb;color:#708891\">Bash<\/span><span role=\"button\" tabindex=\"0\" data-code=\"SOURCE \/path\/to\/your\/file.sql; \" style=\"color:#FDF6E3;display:none;background-color:#657B83\" aria-label=\"Copy\" data-copied-text=\"Copied!\" data-has-text-button=\"textSimple\" data-inside-header-type=\"simpleString\" aria-live=\"polite\" class=\"code-block-pro-copy-button\"><span class=\"cbp-btn-text\">Copy<\/span><\/span><pre class=\"shiki solarized-light\" style=\"background-color: #FDF6E3\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #268BD2\">SOURCE<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">\/path\/to\/your\/file.sql<\/span><span style=\"color: #657B83\">; <\/span><\/span><\/code><\/pre><span style=\"display:flex;align-items:flex-end;padding:10px;width:100%;justify-content:flex-end;background-color:#FDF6E3;color:#708891;font-size:12px;line-height:1;position:relative\">Bash<\/span><\/div>\n\n\n\n<p>\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ub85c\uadf8\uc778\ud558\uc9c0 \uc54a\uace0 \uc9c1\uc811 SQL \ud30c\uc77c\uc744 \uc2e4\ud589\ud558\ub294 \ub2e4\ub978 \ubc29\ubc95\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \ud130\ubbf8\ub110\uc5d0\uc11c \ub2e4\uc74c\uacfc \uac19\uc740 \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro padding-bottom-disabled cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#657B83;--cbp-line-number-width:calc(1 * 0.6 * .875rem);line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#fbeecb;color:#708891\">Bash<\/span><span role=\"button\" tabindex=\"0\" data-code=\"mysql -u username -p database_name &lt; \/path\/to\/your\/file.sql\" style=\"color:#FDF6E3;display:none;background-color:#657B83\" aria-label=\"Copy\" data-copied-text=\"Copied!\" data-has-text-button=\"textSimple\" data-inside-header-type=\"simpleString\" aria-live=\"polite\" class=\"code-block-pro-copy-button\"><span class=\"cbp-btn-text\">Copy<\/span><\/span><pre class=\"shiki solarized-light\" style=\"background-color: #FDF6E3\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #268BD2\">mysql<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #CB4B16\">-u<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">username<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #CB4B16\">-p<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">database_name<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #859900\">&lt;<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">\/path\/to\/your\/file.sql<\/span><\/span><\/code><\/pre><span style=\"display:flex;align-items:flex-end;padding:10px;width:100%;justify-content:flex-end;background-color:#FDF6E3;color:#708891;font-size:12px;line-height:1;position:relative\">Bash<\/span><\/div>\n\n\n\n<p>\uc774 \uba85\ub839\uc5b4\ub294 <code>username<\/code>\uc774\ub77c\ub294 \uc0ac\uc6a9\uc790\ub85c <code>database_name<\/code> \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ub85c\uadf8\uc778\ud558\uc5ec <code>\/path\/to\/your\/file.sql<\/code> \uacbd\ub85c\uc758 SQL \ud30c\uc77c\uc744 \uc2e4\ud589\ud569\ub2c8\ub2e4. <code>-p<\/code> \uc635\uc158\uc744 \uc0ac\uc6a9\ud558\uba74 \uba85\ub839\uc5b4 \uc2e4\ud589 \ud6c4 \ube44\ubc00\ubc88\ud638\ub97c \uc785\ub825\ud558\ub77c\ub294 \uba54\uc2dc\uc9c0\uac00 \ub098\ud0c0\ub0a9\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc774\ub7ec\ud55c \ubc29\ubc95\uc744 \ud1b5\ud574 \uc6b0\ubd84\ud22c\uc5d0\uc11c SQL \ud30c\uc77c\uc744 MySQL \ub610\ub294 MariaDB \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc801\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. SQL \ud30c\uc77c\uc744 \uc2e4\ud589\ud558\uae30 \uc804\uc5d0 \ud574\ub2f9 \ud30c\uc77c\uc774 \uc62c\ubc14\ub978 SQL \ubb38\ubc95\uc744 \ud3ec\ud568\ud558\uace0 \uc788\ub294\uc9c0, \uadf8\ub9ac\uace0 \uc2e4\ud589\ud558\ub824\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc801\ud569\ud55c\uc9c0 \ud655\uc778\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro padding-bottom-disabled cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#657B83;--cbp-line-number-width:calc(1 * 0.6 * .875rem);line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#fbeecb;color:#708891\">Bash<\/span><span role=\"button\" tabindex=\"0\" data-code=\"ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_new_password';\nFLUSH PRIVILEGES;\" style=\"color:#FDF6E3;display:none;background-color:#657B83\" aria-label=\"Copy\" data-copied-text=\"Copied!\" data-has-text-button=\"textSimple\" data-inside-header-type=\"simpleString\" aria-live=\"polite\" class=\"code-block-pro-copy-button\"><span class=\"cbp-btn-text\">Copy<\/span><\/span><pre class=\"shiki solarized-light\" style=\"background-color: #FDF6E3\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #268BD2\">ALTER<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">USER<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">&#39;root&#39;@&#39;localhost&#39;<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">IDENTIFIED<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">WITH<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">mysql_native_password<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">BY<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">&#39;your_new_password&#39;<\/span><span style=\"color: #657B83\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #268BD2\">FLUSH<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">PRIVILEGES<\/span><span style=\"color: #657B83\">;<\/span><\/span><\/code><\/pre><span style=\"display:flex;align-items:flex-end;padding:10px;width:100%;justify-content:flex-end;background-color:#FDF6E3;color:#708891;font-size:12px;line-height:1;position:relative\">Bash<\/span><\/div>\n","protected":false},"excerpt":{"rendered":"<p>MySQL \uc124\uce58 MySQL \ubc29\ud654\ubcbd \ud5c8\uc6a9 sudo ufw allow mysql \uba85\ub839\uc5b4\ub294 \ub9ac\ub205\uc2a4 \uc6b0\ubd84\ud22c\uc5d0\uc11c ufw (Uncomplicated Firewall) \ubc29\ud654\ubcbd\uc744 \uc0ac\uc6a9\ud558\uc5ec MySQL \uc11c\ube44\uc2a4\uc5d0 \ub300\ud55c \ub124\ud2b8\uc6cc\ud06c \uc811\uadfc\uc744 \ud5c8\uc6a9\ud558\ub294 \uc124\uc815\uc744 \ud569\ub2c8\ub2e4. \uc774 \uba85\ub839\uc5b4\ub97c \ubd84\uc11d\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \uc758\ubbf8\ub97c \uac00\uc9d1\ub2c8\ub2e4: \uacb0\ub860\uc801\uc73c\ub85c, sudo ufw allow mysql \uba85\ub839\uc5b4\ub294 \uc6b0\ubd84\ud22c \uc2dc\uc2a4\ud15c\uc5d0\uc11c MySQL \uc11c\ubc84\ub85c\uc758 \ub124\ud2b8\uc6cc\ud06c \uc811\uadfc\uc744 \ud5c8\uc6a9\ud558\ub3c4\ub85d \ubc29\ud654\ubcbd \uaddc\uce59\uc744 \uc124\uc815\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \uc774 \uc124\uc815\uc740 \uc6d0\uaca9 \uc704\uce58\uc5d0\uc11c MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/dohokin.com\/index.php?rest_route=\/wp\/v2\/posts\/1986"}],"collection":[{"href":"https:\/\/dohokin.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dohokin.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dohokin.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dohokin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1986"}],"version-history":[{"count":6,"href":"https:\/\/dohokin.com\/index.php?rest_route=\/wp\/v2\/posts\/1986\/revisions"}],"predecessor-version":[{"id":2027,"href":"https:\/\/dohokin.com\/index.php?rest_route=\/wp\/v2\/posts\/1986\/revisions\/2027"}],"wp:attachment":[{"href":"https:\/\/dohokin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1986"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dohokin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1986"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dohokin.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1986"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}