{"id":12135,"date":"2026-10-28T13:31:05","date_gmt":"2026-10-28T04:31:05","guid":{"rendered":"https:\/\/www.skyer9.pe.kr\/wordpress\/?p=12135"},"modified":"2026-10-28T13:31:05","modified_gmt":"2026-10-28T04:31:05","slug":"mariadb-root-%eb%b9%84%eb%b0%80%eb%b2%88%ed%98%b8-%eb%b6%84%ec%8b%a4-%ec%8b%9c-%ec%9e%ac%ec%84%a4%ec%a0%95-%eb%b0%a9%eb%b2%95-linux-windows","status":"publish","type":"post","link":"https:\/\/www.skyer9.pe.kr\/wordpress\/?p=12135","title":{"rendered":"MariaDB root \ube44\ubc00\ubc88\ud638 \ubd84\uc2e4 \uc2dc \uc7ac\uc124\uc815 \ubc29\ubc95 (Linux \/ Windows)"},"content":{"rendered":"<h1>MariaDB root \ube44\ubc00\ubc88\ud638 \ubd84\uc2e4 \uc2dc \uc7ac\uc124\uc815 \ubc29\ubc95 (Linux \/ Windows)<\/h1>\n<p>MariaDB root \ube44\ubc00\ubc88\ud638\ub97c \uc78a\uc5b4\ubc84\ub838\ub2e4\uba74 \ub2f9\ud669\ud560 \ud544\uc694 \uc5c6\uc2b5\ub2c8\ub2e4. \uc11c\ubc84\ub97c <strong>\uad8c\ud55c \uac80\uc0ac \uc5c6\uc774(<code>--skip-grant-tables<\/code>)<\/strong> \uc7a0\uc2dc \uc2e4\ud589\ud55c \ub4a4 \ube44\ubc00\ubc88\ud638\ub97c \uc0c8\ub85c \uc9c0\uc815\ud558\uace0, \ub2e4\uc2dc \uc815\uc0c1 \ubaa8\ub4dc\ub85c \uc7ac\uc2dc\uc791\ud558\uba74 \ub429\ub2c8\ub2e4.<\/p>\n<p>\uc774 \uae00\uc5d0\uc11c\ub294 Linux\uc640 Windows \ub450 \ud658\uacbd \ubaa8\ub450\uc5d0\uc11c\uc758 \ubc29\ubc95\uc744 \uc815\ub9ac\ud569\ub2c8\ub2e4.<\/p>\n<blockquote>\n<p>\u26a0\ufe0f <strong>\uc8fc\uc758<\/strong><br \/>\n<code>--skip-grant-tables<\/code> \uc0c1\ud0dc\uc5d0\uc11c\ub294 <strong>\ub204\uad6c\ub098 \ube44\ubc00\ubc88\ud638 \uc5c6\uc774 \ubaa8\ub4e0 \uad8c\ud55c\uc73c\ub85c \uc811\uc18d<\/strong>\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc791\uc5c5\uc740 \ube60\ub974\uac8c \ub05d\ub0b4\uace0, \uc678\ubd80 \uc811\uc18d\uc740 \ubc18\ub4dc\uc2dc \ucc28\ub2e8\ud55c \uc0c1\ud0dc\uc5d0\uc11c \uc9c4\ud589\ud558\uc138\uc694. \uc6b4\uc601 \uc11c\ubc84\ub77c\uba74 \uc11c\ube44\uc2a4 \uc810\uac80 \uc2dc\uac04\uc5d0 \uc791\uc5c5\ud558\ub294 \uac83\uc744 \uad8c\uc7a5\ud569\ub2c8\ub2e4.<\/p>\n<\/blockquote>\n<hr \/>\n<h2>\ubaa9\ucc28<\/h2>\n<ol>\n<li><a href=\"#1-\uba3c\uc800-\ud655\uc778\ud560-\uac83-\ube44\ubc00\ubc88\ud638-\uc5c6\uc774-\uc811\uc18d\ub418\ub294\uc9c0\">\uba3c\uc800 \ud655\uc778\ud560 \uac83: \ube44\ubc00\ubc88\ud638 \uc5c6\uc774 \uc811\uc18d\ub418\ub294\uc9c0<\/a><\/li>\n<li><a href=\"#2-linux\uc5d0\uc11c-\uc7ac\uc124\uc815\ud558\uae30\">Linux\uc5d0\uc11c \uc7ac\uc124\uc815\ud558\uae30<\/a><\/li>\n<li><a href=\"#3-windows\uc5d0\uc11c-\uc7ac\uc124\uc815\ud558\uae30\">Windows\uc5d0\uc11c \uc7ac\uc124\uc815\ud558\uae30<\/a><\/li>\n<li><a href=\"#4-\ubc84\uc804\ubcc4-\ube44\ubc00\ubc88\ud638-\ubcc0\uacbd-sql-\uc815\ub9ac\">\ubc84\uc804\ubcc4 \ube44\ubc00\ubc88\ud638 \ubcc0\uacbd SQL \uc815\ub9ac<\/a><\/li>\n<li><a href=\"#5-\uc790\uc8fc-\uacaa\ub294-\ubb38\uc81c\">\uc790\uc8fc \uacaa\ub294 \ubb38\uc81c<\/a><\/li>\n<\/ol>\n<hr \/>\n<h2>1. \uba3c\uc800 \ud655\uc778\ud560 \uac83: \ube44\ubc00\ubc88\ud638 \uc5c6\uc774 \uc811\uc18d\ub418\ub294\uc9c0<\/h2>\n<p>Debian, Ubuntu \ub4f1 \uc77c\ubd80 \ubc30\ud3ec\ud310\uc5d0 \uc124\uce58\ub41c <strong>MariaDB 10.4 \uc774\uc0c1<\/strong>\uc740 root \uacc4\uc815\uc774 \uae30\ubcf8\uc801\uc73c\ub85c <code>unix_socket<\/code> \uc778\uc99d\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uc774 \uacbd\uc6b0 OS\uc758 root(sudo) \uad8c\ud55c\ub9cc \uc788\uc73c\uba74 \ube44\ubc00\ubc88\ud638 \uc5c6\uc774 \uc811\uc18d\ub429\ub2c8\ub2e4.<\/p>\n<pre><code class=\"language-bash\">sudo mariadb\n# \ub610\ub294\nsudo mysql<\/code><\/pre>\n<p>\uc811\uc18d\uc774 \ub41c\ub2e4\uba74 \uc11c\ubc84\ub97c \uc7ac\uc2dc\uc791\ud560 \ud544\uc694 \uc5c6\uc774 \ubc14\ub85c \ube44\ubc00\ubc88\ud638\ub9cc \ubc14\uafb8\uba74 \ub429\ub2c8\ub2e4.<\/p>\n<pre><code class=\"language-sql\">ALTER USER &#039;root&#039;@&#039;localhost&#039; IDENTIFIED BY &#039;\uc0c8\ube44\ubc00\ubc88\ud638&#039;;\nFLUSH PRIVILEGES;<\/code><\/pre>\n<p>\uc811\uc18d\uc774 \uc548 \ub41c\ub2e4\uba74 \uc544\ub798 \uc808\ucc28\ub97c \ub530\ub77c \uc8fc\uc138\uc694.<\/p>\n<hr \/>\n<h2>2. Linux\uc5d0\uc11c \uc7ac\uc124\uc815\ud558\uae30<\/h2>\n<blockquote>\n<p>\uc608\uc2dc\ub294 systemd\ub97c \uc0ac\uc6a9\ud558\ub294 \ubc30\ud3ec\ud310(Ubuntu, Debian, Rocky Linux, CentOS 7+ \ub4f1) \uae30\uc900\uc785\ub2c8\ub2e4. \uc11c\ube44\uc2a4 \uc774\ub984\uc774 <code>mariadb<\/code>\uac00 \uc544\ub2c8\ub77c <code>mysql<\/code>\uc778 \uacbd\uc6b0\ub3c4 \uc788\uc73c\ub2c8 \ud658\uacbd\uc5d0 \ub9de\uac8c \ubc14\uafd4 \uc8fc\uc138\uc694.<\/p>\n<\/blockquote>\n<h3>2-1. MariaDB \uc11c\ube44\uc2a4 \uc911\uc9c0<\/h3>\n<pre><code class=\"language-bash\">sudo systemctl stop mariadb<\/code><\/pre>\n<p>\uc911\uc9c0\ub418\uc5c8\ub294\uc9c0 \ud655\uc778\ud569\ub2c8\ub2e4.<\/p>\n<pre><code class=\"language-bash\">sudo systemctl status mariadb<\/code><\/pre>\n<h3>2-2. \uad8c\ud55c \uac80\uc0ac \uc5c6\uc774 \uc11c\ubc84 \uc2e4\ud589<\/h3>\n<p>\ub450 \uac00\uc9c0 \ubc29\ubc95 \uc911 \ud558\ub098\ub97c \uc120\ud0dd\ud569\ub2c8\ub2e4.<\/p>\n<p><strong>\ubc29\ubc95 A. <code>mysqld_safe<\/code> \uc0ac\uc6a9<\/strong><\/p>\n<pre><code class=\"language-bash\">sudo mysqld_safe --skip-grant-tables --skip-networking &amp;<\/code><\/pre>\n<p><strong>\ubc29\ubc95 B. systemd \ud658\uacbd\ubcc0\uc218 \uc0ac\uc6a9<\/strong> (<code>mysqld_safe<\/code>\uac00 \uc5c6\ub294 \uacbd\uc6b0)<\/p>\n<pre><code class=\"language-bash\">sudo systemctl set-environment MYSQLD_OPTS=&quot;--skip-grant-tables --skip-networking&quot;\nsudo systemctl start mariadb<\/code><\/pre>\n<ul>\n<li><code>--skip-grant-tables<\/code>: \uad8c\ud55c \ud14c\uc774\ube14\uc744 \uc77d\uc9c0 \uc54a\uc544 \ube44\ubc00\ubc88\ud638 \uc5c6\uc774 \uc811\uc18d \uac00\ub2a5<\/li>\n<li><code>--skip-networking<\/code>: TCP \uc811\uc18d\uc744 \ub9c9\uc544 \uc678\ubd80\uc5d0\uc11c \uc811\uc18d\ud558\uc9c0 \ubabb\ud558\uac8c \ud568 (\ub85c\uceec \uc18c\ucf13\uc73c\ub85c\ub9cc \uc811\uc18d)<\/li>\n<\/ul>\n<h3>2-3. \ube44\ubc00\ubc88\ud638 \uc5c6\uc774 \uc811\uc18d<\/h3>\n<pre><code class=\"language-bash\">mysql -u root<\/code><\/pre>\n<h3>2-4. \ube44\ubc00\ubc88\ud638 \ubcc0\uacbd<\/h3>\n<p><code>--skip-grant-tables<\/code> \uc0c1\ud0dc\uc5d0\uc11c\ub294 \uad8c\ud55c \ud14c\uc774\ube14\uc774 \ub85c\ub4dc\ub418\uc9c0 \uc54a\uc558\uae30 \ub54c\ubb38\uc5d0, <strong>\uba3c\uc800 <code>FLUSH PRIVILEGES<\/code>\ub97c \uc2e4\ud589<\/strong>\ud574\uc57c <code>ALTER USER<\/code>\uac00 \ub3d9\uc791\ud569\ub2c8\ub2e4.<\/p>\n<pre><code class=\"language-sql\">FLUSH PRIVILEGES;\nALTER USER &#039;root&#039;@&#039;localhost&#039; IDENTIFIED BY &#039;\uc0c8\ube44\ubc00\ubc88\ud638&#039;;\nFLUSH PRIVILEGES;\nEXIT;<\/code><\/pre>\n<blockquote>\n<p>MariaDB 10.3 \uc774\ud558\uc774\uac70\ub098 \uc704 \uba85\ub839\uc774 \uc2e4\ud328\ud55c\ub2e4\uba74 <a href=\"#4-\ubc84\uc804\ubcc4-\ube44\ubc00\ubc88\ud638-\ubcc0\uacbd-sql-\uc815\ub9ac\">4. \ubc84\uc804\ubcc4 \ube44\ubc00\ubc88\ud638 \ubcc0\uacbd SQL \uc815\ub9ac<\/a>\ub97c \ucc38\uace0\ud558\uc138\uc694.<\/p>\n<\/blockquote>\n<h3>2-5. \uc815\uc0c1 \ubaa8\ub4dc\ub85c \uc7ac\uc2dc\uc791<\/h3>\n<p><strong>\ubc29\ubc95 A(<code>mysqld_safe<\/code>)\ub85c \uc2e4\ud589\ud55c \uacbd\uc6b0<\/strong><\/p>\n<pre><code class=\"language-bash\">sudo mysqladmin -u root -p shutdown\n# \ub610\ub294 \uc704 \uba85\ub839\uc774 \uc548 \ub418\uba74\nsudo pkill mysqld\n\nsudo systemctl start mariadb<\/code><\/pre>\n<p><strong>\ubc29\ubc95 B(systemd \ud658\uacbd\ubcc0\uc218)\ub85c \uc2e4\ud589\ud55c \uacbd\uc6b0<\/strong><\/p>\n<pre><code class=\"language-bash\">sudo systemctl stop mariadb\nsudo systemctl unset-environment MYSQLD_OPTS\nsudo systemctl start mariadb<\/code><\/pre>\n<blockquote>\n<p>\u26a0\ufe0f <code>unset-environment<\/code>\ub97c \ube7c\uba39\uc73c\uba74 \ub2e4\uc74c \uc7ac\uc2dc\uc791 \ub54c\ub3c4 <strong>\uc778\uc99d \uc5c6\uc774 \uc5f4\ub9b0 \uc0c1\ud0dc<\/strong>\ub85c \uc2e4\ud589\ub429\ub2c8\ub2e4. \ubc18\ub4dc\uc2dc \ud574\uc81c\ud558\uc138\uc694.<\/p>\n<\/blockquote>\n<h3>2-6. \uc0c8 \ube44\ubc00\ubc88\ud638\ub85c \uc811\uc18d \ud655\uc778<\/h3>\n<pre><code class=\"language-bash\">mysql -u root -p<\/code><\/pre>\n<hr \/>\n<h2>3. Windows\uc5d0\uc11c \uc7ac\uc124\uc815\ud558\uae30<\/h2>\n<blockquote>\n<p>\uc608\uc2dc \uacbd\ub85c\ub294 <code>C:\\Program Files\\MariaDB 11.4\\<\/code> \uc785\ub2c8\ub2e4. \uc124\uce58\ud55c \ubc84\uc804\uc5d0 \ub9de\uac8c \uacbd\ub85c\ub97c \ubc14\uafd4 \uc8fc\uc138\uc694. \ubaa8\ub4e0 \uba85\ub839\uc740 <strong>\uad00\ub9ac\uc790 \uad8c\ud55c \uba85\ub839 \ud504\ub86c\ud504\ud2b8(cmd)<\/strong> \uc5d0\uc11c \uc2e4\ud589\ud569\ub2c8\ub2e4.<\/p>\n<\/blockquote>\n<h3>3-1. MariaDB \uc11c\ube44\uc2a4 \uc911\uc9c0<\/h3>\n<pre><code class=\"language-cmd\">net stop MariaDB<\/code><\/pre>\n<p>\uc11c\ube44\uc2a4 \uc774\ub984\uc774 \ub2e4\ub97c \uc218 \uc788\uc2b5\ub2c8\ub2e4(<code>MySQL<\/code>, <code>MariaDB114<\/code> \ub4f1). \uc774\ub984\uc744 \ubaa8\ub974\uba74 \ub2e4\uc74c \uba85\ub839\uc73c\ub85c \ud655\uc778\ud558\uc138\uc694.<\/p>\n<pre><code class=\"language-cmd\">sc query state= all | findstr \/i &quot;maria mysql&quot;<\/code><\/pre>\n<p>\ub610\ub294 <code>Win + R<\/code> \u2192 <code>services.msc<\/code>\uc5d0\uc11c MariaDB \uc11c\ube44\uc2a4\ub97c \ucc3e\uc544 <strong>\uc911\uc9c0<\/strong>\ud574\ub3c4 \ub429\ub2c8\ub2e4.<\/p>\n<h3>3-2. \uad8c\ud55c \uac80\uc0ac \uc5c6\uc774 \uc11c\ubc84 \uc2e4\ud589<\/h3>\n<p>MariaDB\uc758 <code>bin<\/code> \ud3f4\ub354\ub85c \uc774\ub3d9\ud55c \ub4a4, \uc124\uc815 \ud30c\uc77c(<code>my.ini<\/code>)\uc744 \uc9c0\uc815\ud574\uc11c \uc2e4\ud589\ud569\ub2c8\ub2e4. Windows \uc124\uce58\ubcf8\uc740 \ubcf4\ud1b5 <code>data<\/code> \ud3f4\ub354 \uc548\uc5d0 <code>my.ini<\/code>\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<pre><code class=\"language-cmd\">cd &quot;C:\\Program Files\\MariaDB 11.4\\bin&quot;\n\nmysqld --defaults-file=&quot;C:\\Program Files\\MariaDB 11.4\\data\\my.ini&quot; --skip-grant-tables --bind-address=127.0.0.1 --console<\/code><\/pre>\n<ul>\n<li><code>--defaults-file<\/code>: \ub370\uc774\ud130 \ub514\ub809\ud130\ub9ac \uacbd\ub85c \ub4f1 \uae30\uc874 \uc124\uc815\uc744 \uadf8\ub300\ub85c \uc4f0\uae30 \uc704\ud574 \uc9c0\uc815\ud569\ub2c8\ub2e4. <strong>\ubc18\ub4dc\uc2dc \uccab \ubc88\uc9f8 \uc635\uc158<\/strong>\uc73c\ub85c \uc368\uc57c \ud569\ub2c8\ub2e4.<\/li>\n<li><code>--bind-address=127.0.0.1<\/code>: \ub85c\uceec\uc5d0\uc11c\ub9cc \uc811\uc18d \uac00\ub2a5\ud558\ub3c4\ub85d \uc81c\ud55c\ud569\ub2c8\ub2e4.<\/li>\n<li><code>--console<\/code>: \ub85c\uadf8\ub97c \ucc3d\uc5d0 \ucd9c\ub825\ud569\ub2c8\ub2e4. \uc774 \ucc3d\uc740 <strong>\ub2eb\uc9c0 \ub9d0\uace0 \uadf8\ub300\ub85c \ub450\uc138\uc694.<\/strong><\/li>\n<\/ul>\n<blockquote>\n<p>\ud83d\udca1 Linux\ucc98\ub7fc <code>--skip-networking<\/code>\uc744 \uc4f0\uba74 Windows\uc5d0\uc11c\ub294 TCP \uc811\uc18d\uc774 \ub9c9\ud600 \ud074\ub77c\uc774\uc5b8\ud2b8\uac00 \uc811\uc18d\ud558\uc9c0 \ubabb\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub798\uc11c \ub300\uc2e0 <code>--bind-address=127.0.0.1<\/code>\ub85c \ub85c\uceec \uc811\uc18d\ub9cc \ud5c8\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n<\/blockquote>\n<h3>3-3. \ube44\ubc00\ubc88\ud638 \uc5c6\uc774 \uc811\uc18d<\/h3>\n<p><strong>\uc0c8 \uad00\ub9ac\uc790 \uba85\ub839 \ud504\ub86c\ud504\ud2b8<\/strong>\ub97c \ud558\ub098 \ub354 \uc5f4\uace0 \uc811\uc18d\ud569\ub2c8\ub2e4.<\/p>\n<pre><code class=\"language-cmd\">cd &quot;C:\\Program Files\\MariaDB 11.4\\bin&quot;\nmysql -u root -h 127.0.0.1<\/code><\/pre>\n<h3>3-4. \ube44\ubc00\ubc88\ud638 \ubcc0\uacbd<\/h3>\n<pre><code class=\"language-sql\">FLUSH PRIVILEGES;\nALTER USER &#039;root&#039;@&#039;localhost&#039; IDENTIFIED BY &#039;\uc0c8\ube44\ubc00\ubc88\ud638&#039;;\nFLUSH PRIVILEGES;\nEXIT;<\/code><\/pre>\n<h3>3-5. \uc815\uc0c1 \ubaa8\ub4dc\ub85c \uc7ac\uc2dc\uc791<\/h3>\n<p><code>--console<\/code>\ub85c \ub744\uc6b4 \uc11c\ubc84\ub97c \uc885\ub8cc\ud569\ub2c8\ub2e4.<\/p>\n<pre><code class=\"language-cmd\">mysqladmin -u root -p -h 127.0.0.1 shutdown<\/code><\/pre>\n<p>(\ub610\ub294 \uc11c\ubc84\ub97c \ub744\uc6b4 \uccab \ubc88\uc9f8 \ucc3d\uc5d0\uc11c <code>Ctrl + C<\/code>)<\/p>\n<p>\uadf8\ub2e4\uc74c \uc11c\ube44\uc2a4\ub97c \ub2e4\uc2dc \uc2dc\uc791\ud569\ub2c8\ub2e4.<\/p>\n<pre><code class=\"language-cmd\">net start MariaDB<\/code><\/pre>\n<h3>3-6. \uc0c8 \ube44\ubc00\ubc88\ud638\ub85c \uc811\uc18d \ud655\uc778<\/h3>\n<pre><code class=\"language-cmd\">mysql -u root -p<\/code><\/pre>\n<h3>(\ub300\uc548) <code>--init-file<\/code>\ub85c \ud55c \ubc88\uc5d0 \ucc98\ub9ac\ud558\uae30<\/h3>\n<p>\uba85\ub839 \ud504\ub86c\ud504\ud2b8 \ub450 \uac1c\ub97c \uc624\uac00\uae30 \ubc88\uac70\ub86d\ub2e4\uba74, \ube44\ubc00\ubc88\ud638 \ubcc0\uacbd SQL\uc744 \ud30c\uc77c\ub85c \ub9cc\ub4e4\uc5b4 \uc11c\ubc84 \uc2dc\uc791 \uc2dc \uc2e4\ud589\uc2dc\ud0a4\ub294 \ubc29\ubc95\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<ol>\n<li>\n<p><code>C:\\reset.sql<\/code> \ud30c\uc77c\uc744 \ub9cc\ub4e4\uace0 \ub2e4\uc74c \ub0b4\uc6a9\uc744 \uc800\uc7a5\ud569\ub2c8\ub2e4.<\/p>\n<pre><code class=\"language-sql\">ALTER USER &#039;root&#039;@&#039;localhost&#039; IDENTIFIED BY &#039;\uc0c8\ube44\ubc00\ubc88\ud638&#039;;<\/code><\/pre>\n<\/li>\n<li>\n<p>\uc11c\ube44\uc2a4\ub97c \uc911\uc9c0\ud55c \uc0c1\ud0dc\uc5d0\uc11c \uc2e4\ud589\ud569\ub2c8\ub2e4.<\/p>\n<pre><code class=\"language-cmd\">cd &quot;C:\\Program Files\\MariaDB 11.4\\bin&quot;\nmysqld --defaults-file=&quot;C:\\Program Files\\MariaDB 11.4\\data\\my.ini&quot; --init-file=C:\\\\reset.sql --console<\/code><\/pre>\n<\/li>\n<li>\n<p>\uc11c\ubc84\uac00 \uc815\uc0c1\uc801\uc73c\ub85c \ub728\uba74 <code>Ctrl + C<\/code>\ub85c \uc885\ub8cc\ud558\uace0 <code>net start MariaDB<\/code>\ub85c \uc11c\ube44\uc2a4\ub97c \uc2dc\uc791\ud569\ub2c8\ub2e4.<\/p>\n<\/li>\n<li>\n<p><strong><code>C:\\reset.sql<\/code> \ud30c\uc77c\uc740 \ubc18\ub4dc\uc2dc \uc0ad\uc81c<\/strong>\ud569\ub2c8\ub2e4. (\ube44\ubc00\ubc88\ud638\uac00 \ud3c9\ubb38\uc73c\ub85c \ub4e4\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.)<\/p>\n<\/li>\n<\/ol>\n<blockquote>\n<p>\uc774 \ubc29\ubc95\uc740 <code>--skip-grant-tables<\/code>\ub97c \uc4f0\uc9c0 \uc54a\uc73c\ubbc0\ub85c \uc778\uc99d \uc5c6\uc774 \uc5f4\ub9ac\ub294 \uc2dc\uac04\uc774 \uc5c6\ub2e4\ub294 \uc7a5\uc810\uc774 \uc788\uc2b5\ub2c8\ub2e4. Linux\uc5d0\uc11c\ub3c4 \uac19\uc740 \ubc29\uc2dd\uc73c\ub85c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<\/blockquote>\n<hr \/>\n<h2>4. \ubc84\uc804\ubcc4 \ube44\ubc00\ubc88\ud638 \ubcc0\uacbd SQL \uc815\ub9ac<\/h2>\n<table>\n<thead>\n<tr>\n<th>MariaDB \ubc84\uc804<\/th>\n<th>\uad8c\uc7a5 \uba85\ub839<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>10.4 \uc774\uc0c1<\/td>\n<td><code>ALTER USER &#039;root&#039;@&#039;localhost&#039; IDENTIFIED BY &#039;\uc0c8\ube44\ubc00\ubc88\ud638&#039;;<\/code><\/td>\n<\/tr>\n<tr>\n<td>10.2 ~ 10.3<\/td>\n<td><code>ALTER USER<\/code> \ub610\ub294 <code>SET PASSWORD<\/code><\/td>\n<\/tr>\n<tr>\n<td>10.1 \uc774\ud558<\/td>\n<td><code>SET PASSWORD<\/code> \ub610\ub294 <code>UPDATE mysql.user<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong><code>SET PASSWORD<\/code> \ubc29\uc2dd<\/strong><\/p>\n<pre><code class=\"language-sql\">FLUSH PRIVILEGES;\nSET PASSWORD FOR &#039;root&#039;@&#039;localhost&#039; = PASSWORD(&#039;\uc0c8\ube44\ubc00\ubc88\ud638&#039;);\nFLUSH PRIVILEGES;<\/code><\/pre>\n<p><strong><code>UPDATE<\/code> \ubc29\uc2dd (\uad6c\ubc84\uc804)<\/strong><\/p>\n<pre><code class=\"language-sql\">UPDATE mysql.user SET password = PASSWORD(&#039;\uc0c8\ube44\ubc00\ubc88\ud638&#039;) WHERE User = &#039;root&#039;;\nFLUSH PRIVILEGES;<\/code><\/pre>\n<blockquote>\n<p>MariaDB 10.4\ubd80\ud130 <code>mysql.user<\/code>\ub294 \ubdf0(view)\ub85c \ubc14\ub00c\uc5b4 <code>UPDATE<\/code>\ub85c \uc9c1\uc811 \uc218\uc815\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. 10.4 \uc774\uc0c1\uc5d0\uc11c\ub294 <code>ALTER USER<\/code>\ub97c \uc0ac\uc6a9\ud558\uc138\uc694.<\/p>\n<\/blockquote>\n<p><strong>\uc18c\ucf13 \uc778\uc99d\uacfc \ube44\ubc00\ubc88\ud638 \uc778\uc99d\uc744 \ubaa8\ub450 \ud5c8\uc6a9\ud558\uae30 (10.4 \uc774\uc0c1, Linux)<\/strong><\/p>\n<p><code>sudo mariadb<\/code>\ub85c \ube44\ubc00\ubc88\ud638 \uc5c6\uc774 \uc811\uc18d\ud558\ub294 \ubc29\uc2dd\ub3c4 \uc720\uc9c0\ud558\uace0 \uc2f6\ub2e4\uba74 \ub2e4\uc74c\ucc98\ub7fc \uc124\uc815\ud569\ub2c8\ub2e4.<\/p>\n<pre><code class=\"language-sql\">ALTER USER &#039;root&#039;@&#039;localhost&#039;\n  IDENTIFIED VIA mysql_native_password USING PASSWORD(&#039;\uc0c8\ube44\ubc00\ubc88\ud638&#039;)\n  OR unix_socket;<\/code><\/pre>\n<p>\ud604\uc7ac \ubc84\uc804\uc740 \ub2e4\uc74c \uba85\ub839\uc73c\ub85c \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<pre><code class=\"language-bash\">mysql --version<\/code><\/pre>\n<hr \/>\n<h2>5. \uc790\uc8fc \uacaa\ub294 \ubb38\uc81c<\/h2>\n<p><strong><code>ERROR 1290: The MariaDB server is running with the --skip-grant-tables option so it cannot execute this statement<\/code><\/strong><br \/>\n\u2192 <code>ALTER USER<\/code> \uc804\uc5d0 <code>FLUSH PRIVILEGES;<\/code>\ub97c \uba3c\uc800 \uc2e4\ud589\ud558\uc138\uc694.<\/p>\n<p><strong><code>Can&#039;t connect to local MySQL server through socket<\/code><\/strong> (Linux)<br \/>\n\u2192 \uc11c\ubc84\uac00 \uc544\uc9c1 \uc644\uc804\ud788 \uc62c\ub77c\uc624\uc9c0 \uc54a\uc558\uac70\ub098, \uc18c\ucf13 \ub514\ub809\ud130\ub9ac(<code>\/run\/mysqld<\/code>)\uac00 \uc5c6\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<pre><code class=\"language-bash\">sudo mkdir -p \/run\/mysqld\nsudo chown mysql:mysql \/run\/mysqld<\/code><\/pre>\n<p><strong><code>Can&#039;t connect to MySQL server on &#039;localhost&#039;<\/code><\/strong> (Windows)<br \/>\n\u2192 <code>-h 127.0.0.1<\/code> \uc635\uc158\uc744 \ubd99\uc5ec \uc811\uc18d\ud558\uace0, <code>--skip-networking<\/code>\uc744 \uc4f0\uc9c0 \uc54a\uc558\ub294\uc9c0 \ud655\uc778\ud558\uc138\uc694.<\/p>\n<p><strong>\uc11c\ube44\uc2a4\uac00 \uc2dc\uc791\ub418\uc9c0 \uc54a\uc74c<\/strong> (Windows)<br \/>\n\u2192 <code>--console<\/code>\ub85c \ub744\uc6b4 <code>mysqld<\/code>\uac00 \uc544\uc9c1 \uc2e4\ud589 \uc911\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc791\uc5c5 \uad00\ub9ac\uc790\uc5d0\uc11c <code>mysqld.exe<\/code>\uac00 \ub0a8\uc544 \uc788\ub294\uc9c0 \ud655\uc778\ud558\uace0 \uc885\ub8cc\ud55c \ub4a4 \ub2e4\uc2dc \uc2dc\uc791\ud558\uc138\uc694.<\/p>\n<p><strong><code>root@&#039;localhost&#039;<\/code> \uacc4\uc815\uc774 \uc5c6\ub2e4\uace0 \ub098\uc634<\/strong><br \/>\n\u2192 \ud638\uc2a4\ud2b8 \uac12\uc774 \ub2e4\ub97c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc2e4\uc81c \uacc4\uc815\uc744 \ud655\uc778\ud55c \ub4a4 \ud574\ub2f9 \ud638\uc2a4\ud2b8\ub85c \ubcc0\uacbd\ud558\uc138\uc694.<\/p>\n<pre><code class=\"language-sql\">SELECT User, Host FROM mysql.user WHERE User = &#039;root&#039;;<\/code><\/pre>\n<hr \/>\n<h2>\ub9c8\ubb34\ub9ac<\/h2>\n<p>\uc815\ub9ac\ud558\uba74 \uc21c\uc11c\ub294 \ud56d\uc0c1 \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<ol>\n<li>\uc11c\ube44\uc2a4 \uc911\uc9c0<\/li>\n<li><code>--skip-grant-tables<\/code>(\ub610\ub294 <code>--init-file<\/code>)\ub85c \uc11c\ubc84 \uc2e4\ud589<\/li>\n<li><code>FLUSH PRIVILEGES<\/code> \u2192 <code>ALTER USER<\/code>\ub85c \ube44\ubc00\ubc88\ud638 \ubcc0\uacbd<\/li>\n<li>\uc815\uc0c1 \ubaa8\ub4dc\ub85c \uc7ac\uc2dc\uc791<\/li>\n<li>\uc0c8 \ube44\ubc00\ubc88\ud638\ub85c \uc811\uc18d \ud655\uc778<\/li>\n<\/ol>\n<p>\uc791\uc5c5\uc774 \ub05d\ub098\uba74 <strong>\uc778\uc99d \uc5c6\uc774 \uc5f4\ub9b0 \uc0c1\ud0dc\uac00 \ub0a8\uc544 \uc788\uc9c0 \uc54a\uc740\uc9c0<\/strong> \uaf2d \ud55c \ubc88 \ub354 \ud655\uc778\ud558\uc138\uc694.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MariaDB root \ube44\ubc00\ubc88\ud638 \ubd84\uc2e4 \uc2dc \uc7ac\uc124\uc815 \ubc29\ubc95 (Linux \/ Windows) MariaDB root \ube44\ubc00\ubc88\ud638\ub97c \uc78a\uc5b4\ubc84\ub838\ub2e4\uba74 \ub2f9\ud669\ud560 \ud544\uc694 \uc5c6\uc2b5\ub2c8\ub2e4. \uc11c\ubc84\ub97c \uad8c\ud55c \uac80\uc0ac \uc5c6\uc774(&#8211;skip-grant-tables) \uc7a0\uc2dc \uc2e4\ud589\ud55c \ub4a4 \ube44\ubc00\ubc88\ud638\ub97c \uc0c8\ub85c \uc9c0\uc815\ud558\uace0, \ub2e4\uc2dc \uc815\uc0c1 \ubaa8\ub4dc\ub85c \uc7ac\uc2dc\uc791\ud558\uba74 \ub429\ub2c8\ub2e4. \uc774 \uae00\uc5d0\uc11c\ub294 Linux\uc640 Windows \ub450 \ud658\uacbd \ubaa8\ub450\uc5d0\uc11c\uc758 \ubc29\ubc95\uc744 \uc815\ub9ac\ud569\ub2c8\ub2e4. \u26a0\ufe0f \uc8fc\uc758 &#8211;skip-grant-tables \uc0c1\ud0dc\uc5d0\uc11c\ub294 \ub204\uad6c\ub098 \ube44\ubc00\ubc88\ud638 \uc5c6\uc774 \ubaa8\ub4e0 \uad8c\ud55c\uc73c\ub85c \uc811\uc18d\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc791\uc5c5\uc740 \ube60\ub974\uac8c\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.skyer9.pe.kr\/wordpress\/?p=12135\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-12135","post","type-post","status-publish","format-standard","hentry","category-devops"],"_links":{"self":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/12135","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12135"}],"version-history":[{"count":1,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/12135\/revisions"}],"predecessor-version":[{"id":12136,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/12135\/revisions\/12136"}],"wp:attachment":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12135"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=12135"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12135"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}