{"id":1931,"date":"2024-02-11T12:02:32","date_gmt":"2024-02-11T03:02:32","guid":{"rendered":"https:\/\/dohokin.com\/?p=1931"},"modified":"2024-02-13T23:30:56","modified_gmt":"2024-02-13T14:30:56","slug":"%ec%9a%b0%eb%b6%84%ed%88%acubuntu%ec%97%90%ec%84%9c-mysql%ec%9d%84-%ec%82%ac%ec%9a%a9%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/dohokin.com\/?p=1931","title":{"rendered":"\uc6b0\ubd84\ud22c(Ubuntu)\uc5d0\uc11c MySQL\uc744 \uc0ac\uc6a9\ud558\uae30"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"522\" src=\"https:\/\/dohokin.com\/wp-content\/uploads\/2024\/02\/image-15-1024x522.png\" alt=\"\" class=\"wp-image-1933\" srcset=\"https:\/\/dohokin.com\/wp-content\/uploads\/2024\/02\/image-15-1024x522.png 1024w, https:\/\/dohokin.com\/wp-content\/uploads\/2024\/02\/image-15-300x153.png 300w, https:\/\/dohokin.com\/wp-content\/uploads\/2024\/02\/image-15-768x392.png 768w, https:\/\/dohokin.com\/wp-content\/uploads\/2024\/02\/image-15-1536x783.png 1536w, https:\/\/dohokin.com\/wp-content\/uploads\/2024\/02\/image-15.png 1620w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\uc6b0\ubd84\ud22c(Ubuntu)\uc5d0\uc11c MySQL\uc744 \uc0ac\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294 \uba3c\uc800 MySQL\uc744 \uc124\uce58\ud558\uace0 \uad6c\uc131\ud574\uc57c \ud569\ub2c8\ub2e4. \ub2e4\uc74c\uc740 MySQL\uc744 \uc6b0\ubd84\ud22c \uc2dc\uc2a4\ud15c\uc5d0 \uc124\uce58\ud558\uace0 \uc0ac\uc6a9\ud558\ub294 \uae30\ubcf8\uc801\uc778 \ub2e8\uacc4\uc785\ub2c8\ub2e4:<\/p>\n\n\n\n<p><strong>MySQL \uc11c\ubc84 \uc124\uce58<\/strong>: \uc6b0\ubd84\ud22c\uc5d0\uc11c MySQL \uc11c\ubc84\ub97c \uc124\uce58\ud558\uae30 \uc704\ud574 \ud130\ubbf8\ub110\uc744 \uc5f4\uace0 \ub2e4\uc74c \uba85\ub839\uc5b4\ub97c \uc785\ub825\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 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 style=\"color: #657B83\"> <\/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 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>\uc774 \uba85\ub839\uc5b4\ub294 \uc2dc\uc2a4\ud15c\uc744 \ucd5c\uc2e0 \uc0c1\ud0dc\ub85c \uc5c5\ub370\uc774\ud2b8\ud558\uace0 MySQL \uc11c\ubc84 \ud328\ud0a4\uc9c0\ub97c \uc124\uce58\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p><strong>MySQL \ubcf4\uc548 \uc124\uc815<\/strong>: \uc124\uce58 \ud6c4, <code>mysql_secure_installation<\/code> \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc2e4\ud589\ud558\uc5ec \ube44\ubc00\ubc88\ud638 \uc815\ucc45\uc744 \uc124\uc815\ud558\uace0, \uc775\uba85 \uc0ac\uc6a9\uc790\ub97c \uc81c\uac70\ud558\uba70, \uc6d0\uaca9 \ub8e8\ud2b8 \ub85c\uadf8\uc778\uc744 \ube44\ud65c\uc131\ud654\ud558\ub294 \ub4f1\uc758 \ubcf4\uc548 \uad00\ub828 \uc124\uc815\uc744 \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=\"sudo mysql_secure_installation\" 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_secure_installation<\/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 \uc2a4\ud06c\ub9bd\ud2b8\ub294 \uc5ec\ub7ec\ubd84\uc5d0\uac8c \uba87 \uac00\uc9c0 \ubcf4\uc548 \uad00\ub828 \uc9c8\ubb38\uc744 \ud560 \uac83\uc774\uba70, \uac01 \ub2e8\uacc4\ub9c8\ub2e4 \uad8c\uc7a5 \uc0ac\ud56d\uc744 \ub530\ub974\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p><strong>MySQL \uc11c\ube44\uc2a4 \uad00\ub9ac<\/strong>: MySQL \uc11c\ube44\uc2a4\uc758 \uc0c1\ud0dc\ub97c \ud655\uc778\ud558\uace0, \uc2dc\uc791\ud558\uac70\ub098 \uc911\uc9c0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<ul>\n<li>\uc0c1\ud0dc \ud655\uc778:<\/li>\n<\/ul>\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 status 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\">status<\/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<ul>\n<li>\uc2dc\uc791:<\/li>\n<\/ul>\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<ul>\n<li>\uc911\uc9c0:<\/li>\n<\/ul>\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><strong>MySQL \uc0ac\uc6a9\uc790 \ubc0f \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac<\/strong>: MySQL \uc258\uc5d0 \uc811\uc18d\ud558\uae30 \uc704\ud574 \ud130\ubbf8\ub110\uc5d0\uc11c \ub2e4\uc74c \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\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 mysql -u root -p\" 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 style=\"color: #657B83\"> <\/span><span style=\"color: #CB4B16\">-p<\/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> <\/code>\uc5ec\uae30\uc11c, <code>-u<\/code> \uc635\uc158\uc740 \uc0ac\uc6a9\uc790\uba85\uc744 \uc9c0\uc815\ud558\uba70, <code>-p<\/code> \uc635\uc158\uc740 \ube44\ubc00\ubc88\ud638 \uc785\ub825\uc744 \uc694\uccad\ud569\ub2c8\ub2e4. \ucc98\uc74c \uc124\uce58 \ud6c4\uc5d0\ub294 \ub8e8\ud2b8 \uc0ac\uc6a9\uc790\uc758 \ube44\ubc00\ubc88\ud638\ub97c \uc124\uc815\ud588\uc744 \uac83\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p><strong>\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0dd\uc131 \ubc0f \uc0ac\uc6a9<\/strong>: MySQL \ud504\ub86c\ud504\ud2b8\uc5d0\uc11c \ub2e4\uc74c\uacfc \uac19\uc740 SQL \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0dd\uc131\ud558\uace0 \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=\"CREATE DATABASE mydatabase; \nUSE mydatabase;\" 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\">CREATE<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">DATABASE<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">mydatabase<\/span><span style=\"color: #657B83\">; <\/span><\/span>\n<span class=\"line\"><span style=\"color: #268BD2\">USE<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">mydatabase<\/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> \uc774 \uba85\ub839\uc5b4\ub294 <code>mydatabase<\/code>\ub77c\ub294 \uc774\ub984\uc758 \uc0c8 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0dd\uc131\ud558\uace0, \uadf8 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0ac\uc6a9\ud558\ub3c4\ub85d \uc124\uc815\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p><strong>\uc0ac\uc6a9\uc790 \uc0dd\uc131 \ubc0f \uad8c\ud55c \ubd80\uc5ec<\/strong>: \uc0c8\ub85c\uc6b4 \uc0ac\uc6a9\uc790\ub97c \uc0dd\uc131\ud558\uace0, \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ub300\ud55c \uad8c\ud55c\uc744 \ubd80\uc5ec\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=\"CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password'; \nGRANT ALL PRIVILEGES ON mydatabase.* TO 'newuser'@'localhost'; \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\">CREATE<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">USER<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">&#39;newuser&#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;password&#39;<\/span><span style=\"color: #657B83\">; <\/span><\/span>\n<span class=\"line\"><span style=\"color: #268BD2\">GRANT<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">ALL<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">PRIVILEGES<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">ON<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">mydatabase.<\/span><span style=\"color: #268BD2\">*<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">TO<\/span><span style=\"color: #657B83\"> <\/span><span style=\"color: #2AA198\">&#39;newuser&#39;@&#39;localhost&#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\n\n\n<p>\uc774 \uba85\ub839\uc5b4\ub4e4\uc740 <code>newuser<\/code>\ub77c\ub294 \uc0c8 \uc0ac\uc6a9\uc790\ub97c \uc0dd\uc131\ud558\uace0, <code>mydatabase<\/code>\uc5d0 \ub300\ud55c \ubaa8\ub4e0 \uad8c\ud55c\uc744 \ubd80\uc5ec\ud55c \ud6c4, \uad8c\ud55c \ubcc0\uacbd \uc0ac\ud56d\uc744 \uc801\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc704 \ub2e8\uacc4\ub97c \ud1b5\ud574 \uc6b0\ubd84\ud22c \uc2dc\uc2a4\ud15c\uc5d0\uc11c MySQL\uc744 \uc124\uce58\ud558\uace0 \uae30\ubcf8\uc801\uc778 \uc0ac\uc6a9\uc790 \ubc0f \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac\ub97c \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ucd94\uac00\uc801\uc778 \uad6c\uc131\uc774\ub098 \uace0\uae09 \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud558\ub824\uba74 MySQL \ubb38\uc11c\ub97c \ucc38\uc870\ud558\uac70\ub098 \uad6c\uccb4\uc801\uc778 \uc694\uad6c \uc0ac\ud56d\uc5d0 \ub300\ud574 \ub354 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\uc544\uc57c \ud569\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc6b0\ubd84\ud22c(Ubuntu)\uc5d0\uc11c MySQL\uc744 \uc0ac\uc6a9\ud558\uae30<\/p>\n","protected":false},"author":1,"featured_media":1933,"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":[178,177],"_links":{"self":[{"href":"https:\/\/dohokin.com\/index.php?rest_route=\/wp\/v2\/posts\/1931"}],"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=1931"}],"version-history":[{"count":4,"href":"https:\/\/dohokin.com\/index.php?rest_route=\/wp\/v2\/posts\/1931\/revisions"}],"predecessor-version":[{"id":1963,"href":"https:\/\/dohokin.com\/index.php?rest_route=\/wp\/v2\/posts\/1931\/revisions\/1963"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dohokin.com\/index.php?rest_route=\/wp\/v2\/media\/1933"}],"wp:attachment":[{"href":"https:\/\/dohokin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1931"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dohokin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1931"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dohokin.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1931"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}