{"id":6368,"date":"2020-02-06T16:09:25","date_gmt":"2020-02-06T07:09:25","guid":{"rendered":"http:\/\/auctionpro.co.kr\/?p=6368"},"modified":"2026-10-26T14:44:05","modified_gmt":"2026-10-26T05:44:05","slug":"mysql-workbench-warning-when-connecting-to-mariadb","status":"publish","type":"post","link":"https:\/\/www.auctionpro.co.kr\/?p=6368","title":{"rendered":"MySQL Workbench warning when connecting to MariaDB"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">MariaDB \uc6d0\uaca9 \uc811\uc18d\uacfc MySQL Workbench \uc5f0\uacb0 \ubc29\ubc95 (2026\ub144 \uae30\uc900)<\/h2>\n\n\n<p class=\"wp-block-paragraph\">CentOS\uc5d0\uc11c MariaDB\ub97c \uc124\uce58\ud558\uace0 MySQL Workbench\ub85c \uc811\uc18d\ud560 \ub54c \ub098\ud0c0\ub098\ub294 \ud638\ud658\uc131 \uacbd\uace0\uc640 \uc6d0\uaca9 \uc811\uc18d \uc124\uc815\uc744 \uc815\ub9ac\ud569\ub2c8\ub2e4. \uae30\uc874 MariaDB 10.5\u00b710.11 \uc0ac\ub840\ub97c \ud3ec\ud568\ud558\ub418, <strong>MariaDB 10.11\u00b711.4\u00b711.8 LTS \ubc0f 12.x \uacc4\uc5f4\uc5d0\ub3c4 \uc801\uc6a9\ud560 \uc218 \uc788\ub294 \uacc4\uc815 \uad00\ub9ac \ubc29\uc2dd<\/strong>\uc744 \uc911\uc2ec\uc73c\ub85c \uc124\uba85\ud569\ub2c8\ub2e4. \uc11c\ubc84 \ubc30\ud3ec\ud310\uacfc MariaDB \ud328\ud0a4\uc9c0\uc5d0 \ub530\ub77c \uc124\uc815 \ud30c\uc77c \uc704\uce58\ub294 \ub2e4\ub985\ub2c8\ub2e4.<\/p>\n\n\n<h3 class=\"wp-block-heading\">1. \uc124\uce58\ub41c MariaDB \ubc84\uc804\uacfc \uc11c\ube44\uc2a4 \ud655\uc778<\/h3>\n\n\n<pre class=\"wp-block-preformatted\">mariadb --version\nsudo mariadb -e \"SELECT VERSION();\"\nsudo systemctl status mariadb\nsudo ss -lntp | grep 3306<\/pre>\n\n\n<p class=\"wp-block-paragraph\">MariaDB 10.4\ubd80\ud130 Linux \uc124\uce58\uc5d0\uc11c\ub294 <strong>root\uc758 unix_socket \uc778\uc99d<\/strong>\uc774 \ud754\ud558\ubbc0\ub85c <strong>sudo mariadb<\/strong>\ub85c \ub85c\uceec \uad00\ub9ac\uc790\uc5d0 \uc811\uc18d\ud569\ub2c8\ub2e4. root\uc758 \uc6d0\uaca9 \uc811\uc18d\uc744 \uc704\ud574 \uc778\uc99d \ubc29\uc2dd\uc744 \ubb34\ub9ac\ud558\uac8c \ubc14\uafb8\uc9c0 \ub9c8\uc138\uc694.<\/p>\n\n\n<h3 class=\"wp-block-heading\">2. MariaDB \uc124\uc815 \ud30c\uc77c \uc704\uce58 \ud655\uc778<\/h3>\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>\ubc30\ud3ec\ud310<\/th><th>\ub300\ud45c\uc801\uc778 \uc124\uc815 \ud30c\uc77c<\/th><\/tr><\/thead><tbody><tr><td>Ubuntu \/ Debian<\/td><td><strong>\/etc\/mysql\/mariadb.conf.d\/50-server.cnf<\/strong><\/td><\/tr><tr><td>CentOS \/ Rocky \/ AlmaLinux<\/td><td><strong>\/etc\/my.cnf.d\/server.cnf<\/strong> \ub610\ub294 <strong>\/etc\/my.cnf.d\/mariadb-server.cnf<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n<pre class=\"wp-block-preformatted\">mariadbd --help --verbose\nsudo grep -R \"bind-address\" \/etc\/mysql \/etc\/my.cnf \/etc\/my.cnf.d 2>\/dev\/null<\/pre>\n\n\n<p class=\"wp-block-paragraph\">\uc2e4\uc81c \uc124\uc815 \ud30c\uc77c\uacfc \uc801\uc6a9 \uc21c\uc11c\ub97c \ud655\uc778\ud55c \ub4a4 \uc218\uc815\ud569\ub2c8\ub2e4. \uc6b4\uc601 \uc11c\ubc84\ub77c\uba74 \uba3c\uc800 \uc124\uc815 \ud30c\uc77c\uc744 \ubc31\uc5c5\ud558\uc138\uc694.<\/p>\n\n\n<h3 class=\"wp-block-heading\">3. \uc6d0\uaca9 \uc811\uc18d\uc744 \uc704\ud55c bind-address \uc124\uc815<\/h3>\n\n\n<p class=\"wp-block-paragraph\">\uc6d0\uaca9 \uc811\uc18d\uc774 \ud544\uc694\ud55c \ub124\ud2b8\uc6cc\ud06c \uc778\ud130\ud398\uc774\uc2a4\uc5d0\ub9cc \ubc14\uc778\ub529\ud558\ub294 \uac83\uc744 \uad8c\uc7a5\ud569\ub2c8\ub2e4. \uc544\ub798 <strong>192.0.2.10<\/strong>\uc740 \uc124\uba85\uc6a9 \uc11c\ubc84 IP\uc774\uba70 \uc2e4\uc81c \uc11c\ubc84\uc5d0 \ud560\ub2f9\ub41c \uc8fc\uc18c\ub85c \uad50\uccb4\ud574\uc57c \ud569\ub2c8\ub2e4. MariaDB 10.11 \uc774\uc0c1\uc5d0\uc11c\ub294 \uc5ec\ub7ec \uc8fc\uc18c\ub97c \uc27c\ud45c\ub85c \uc9c0\uc815\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n<pre class=\"wp-block-preformatted\">[mysqld]\nbind-address = 192.0.2.10<\/pre>\n\n\n<p class=\"wp-block-paragraph\">\ubaa8\ub4e0 IPv4 \uc778\ud130\ud398\uc774\uc2a4\ub97c \uc218\uc2e0\ud574\uc57c \ud558\ub294 \ud2b9\ubcc4\ud55c \ud658\uacbd\uc5d0\uc11c\ub294 <strong>bind-address = 0.0.0.0<\/strong>\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc9c0\ub9cc, \uc774 \uacbd\uc6b0\uc5d0\ub3c4 \ubc29\ud654\ubcbd\uc5d0\uc11c \ud5c8\uc6a9 IP\ub97c \uc81c\ud55c\ud574\uc57c \ud569\ub2c8\ub2e4. <strong>skip-networking<\/strong>\uc774 \ud65c\uc131\ud654\ub418\uc5b4 \uc788\ub2e4\uba74 TCP \uc811\uc18d\uc774 \ucc28\ub2e8\ub429\ub2c8\ub2e4.<\/p>\n\n\n<pre class=\"wp-block-preformatted\">sudo systemctl restart mariadb\nsudo ss -lntp | grep 3306<\/pre>\n\n\n<h3 class=\"wp-block-heading\">4. root \ub300\uc2e0 \uc804\uc6a9 \uc6d0\uaca9 \uc811\uc18d \uacc4\uc815 \uc0dd\uc131<\/h3>\n\n\n<p class=\"wp-block-paragraph\">\uae30\uc874 \uae00\uc758 <strong>UPDATE mysql.user SET Host=&#8217;%&#8217; WHERE User=&#8217;root&#8217;<\/strong> \ubc0f <strong>RENAME USER &#8216;root&#8217;@&#8217;localhost&#8217; TO &#8216;root&#8217;@&#8217;%&#8217;<\/strong> \ubc29\uc2dd\uc740 \uad8c\uc7a5\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. MariaDB 10.4 \uc774\ud6c4 mysql.user\ub294 mysql.global_priv\ub97c \uae30\ubc18\uc73c\ub85c \ud558\ub294 \ud638\ud658\uc131 \ubdf0\uc774\uba70, root\ub97c \uc678\ubd80\uc5d0 \ub178\ucd9c\ud558\uba74 \ubcf4\uc548 \uc704\ud5d8\uc774 \ucee4\uc9d1\ub2c8\ub2e4.<\/p>\n\n\n<p class=\"wp-block-paragraph\">\uc544\ub798\ub294 \uad00\ub9ac \ub300\uc0c1 \ub370\uc774\ud130\ubca0\uc774\uc2a4 <strong>appdb<\/strong>\uc640 \uc811\uc18d\uc744 \ud5c8\uc6a9\ud560 \ud074\ub77c\uc774\uc5b8\ud2b8 IP <strong>198.51.100.25<\/strong>\ub97c \uc0ac\uc6a9\ud558\ub294 \uc608\uc2dc\uc785\ub2c8\ub2e4. \ub450 \uac12\uacfc \uc554\ud638\ub97c \uc2e4\uc81c \ud658\uacbd\uc5d0 \ub9de\uac8c \ubcc0\uacbd\ud558\uc138\uc694.<\/p>\n\n\n<pre class=\"wp-block-preformatted\">sudo mariadb\n\nCREATE USER 'workbench_user'@'198.51.100.25'\n  IDENTIFIED BY 'REPLACE_WITH_A_LONG_UNIQUE_PASSWORD'\n  REQUIRE SSL;\n\nGRANT SELECT, INSERT, UPDATE, DELETE\n  ON appdb.* TO 'workbench_user'@'198.51.100.25';\n\nSHOW GRANTS FOR 'workbench_user'@'198.51.100.25';\nSELECT User, Host FROM mysql.user;\nEXIT;<\/pre>\n\n\n<p class=\"wp-block-paragraph\">\uc704 SQL\uc740 <strong>\uc11c\ubc84\uc5d0 TLS \uc778\uc99d\uc11c\uac00 \uc62c\ubc14\ub974\uac8c \uc124\uc815\ub41c \uacbd\uc6b0<\/strong>\uc758 \uc608\uc2dc\uc785\ub2c8\ub2e4. TLS\uac00 \uad6c\uc131\ub418\uc9c0 \uc54a\uc558\ub2e4\uba74 \uba3c\uc800 \uc778\uc99d\uc11c\ub97c \uc124\uc815\ud558\uac70\ub098 SSH \ud130\ub110 \ubc29\uc2dd(\uc544\ub798 6\ub2e8\uacc4)\uc744 \uc0ac\uc6a9\ud558\uc138\uc694. \ub370\uc774\ud130\ubca0\uc774\uc2a4\u00b7\ud14c\uc774\ube14 \uc0dd\uc131 \uad8c\ud55c\uc774 \ud544\uc694\ud560 \ub54c\ub9cc CREATE, ALTER \ub4f1 \ud544\uc694\ud55c \uad8c\ud55c\uc744 \ucd94\uac00\ud569\ub2c8\ub2e4. \uacc4\uc815 \uc0dd\uc131\uc774\ub098 \uad8c\ud55c \ubd80\uc5ec \ud6c4\uc5d0\ub294 \uc77c\ubc18\uc801\uc73c\ub85c FLUSH PRIVILEGES\uac00 \ud544\uc694\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n<h3 class=\"wp-block-heading\">5. \ubc29\ud654\ubcbd\uc5d0\uc11c \uc2e0\ub8b0\ud560 \uc218 \uc788\ub294 IP\ub9cc \ud5c8\uc6a9<\/h3>\n\n\n<p class=\"wp-block-paragraph\">\uc608\uc2dc \ud074\ub77c\uc774\uc5b8\ud2b8 IP\ub294 <strong>198.51.100.25<\/strong>\uc785\ub2c8\ub2e4. \uc778\ud130\ub137 \uc804\uccb4\uc5d0 3306 \ud3ec\ud2b8\ub97c \uac1c\ubc29\ud558\ub294 \uba85\ub839\uc740 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n<h4 class=\"wp-block-heading\">Ubuntu UFW<\/h4>\n\n\n<pre class=\"wp-block-preformatted\">sudo ufw allow from 198.51.100.25 to any port 3306 proto tcp\nsudo ufw status numbered<\/pre>\n\n\n<h4 class=\"wp-block-heading\">Rocky \/ AlmaLinux \/ CentOS Stream (firewalld)<\/h4>\n\n\n<pre class=\"wp-block-preformatted\">sudo firewall-cmd --get-active-zones\nsudo firewall-cmd --zone=public --add-rich-rule='rule family=\"ipv4\" source address=\"198.51.100.25\/32\" port port=\"3306\" protocol=\"tcp\" accept' --permanent\nsudo firewall-cmd --reload\nsudo firewall-cmd --zone=public --list-all<\/pre>\n\n\n<p class=\"wp-block-paragraph\">\uc2e4\uc81c \ub124\ud2b8\uc6cc\ud06c\uc5d0 \uc801\uc6a9\ub41c firewalld zone\uc744 \ud655\uc778\ud55c \ub4a4 <strong>public<\/strong>\uc744 \uc801\uc808\ud55c zone \uc774\ub984\uc73c\ub85c \ubc14\uafb8\uc138\uc694. \ud074\ub77c\uc6b0\ub4dc \ubcf4\uc548 \uadf8\ub8f9\uacfc \uacf5\uc720\uae30 \ud3ec\ud2b8\ud3ec\uc6cc\ub529\ub3c4 \ubcc4\ub3c4\ub85c \uc810\uac80\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\n\n<h3 class=\"wp-block-heading\">6. MySQL Workbench \uc5f0\uacb0 \uc124\uc815<\/h3>\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>\uc124\uc815<\/th><th>\uc9c1\uc811 TCP\/IP \uc5f0\uacb0<\/th><th>SSH \ud130\ub110 \uc5f0\uacb0(\uad8c\uc7a5)<\/th><\/tr><\/thead><tbody><tr><td>Connection Method<\/td><td>Standard (TCP\/IP)<\/td><td>Standard TCP\/IP over SSH<\/td><\/tr><tr><td>Hostname<\/td><td>MariaDB \uc11c\ubc84 IP<\/td><td>SSH \uc11c\ubc84\ub97c \ud1b5\ud55c MariaDB \uc8fc\uc18c(\ubcf4\ud1b5 127.0.0.1)<\/td><\/tr><tr><td>Port<\/td><td>3306<\/td><td>3306<\/td><\/tr><tr><td>Username<\/td><td>workbench_user<\/td><td>\ud130\ub110\uc6a9 DB \uacc4\uc815<\/td><\/tr><tr><td>SSH \uc124\uc815<\/td><td>\ud574\ub2f9 \uc5c6\uc74c<\/td><td>SSH Hostname, SSH Username, \uc778\uc99d\ud0a4 \ub610\ub294 \uc778\uc99d \uc815\ubcf4<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n<p class=\"wp-block-paragraph\"><strong>SSH \ud130\ub110 \ubc29\uc2dd<\/strong>\uc740 DB \ud3ec\ud2b8 3306\uc744 \uc678\ubd80\uc5d0 \uacf5\uac1c\ud558\uc9c0 \uc54a\uace0 SSH\ub97c \ud1b5\ud574 \uc811\uadfc\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \ubc29\uc2dd\uc5d0\uc11c\ub294 <strong>bind-address = 127.0.0.1<\/strong>\uc744 \uc720\uc9c0\ud560 \uc218 \uc788\uc73c\uba70, DB \uacc4\uc815\uc740 \uc2e4\uc81c MariaDB\uac00 \uc778\uc2dd\ud558\ub294 \uc811\uc18d \ud638\uc2a4\ud2b8\uc5d0 \ub9de\uac8c \uc0dd\uc131\ud574\uc57c \ud569\ub2c8\ub2e4. Workbench\uc758 <strong>Test Connection<\/strong>\uc73c\ub85c \ud655\uc778\ud558\uc138\uc694.<\/p>\n\n\n<h3 class=\"wp-block-heading\">7. MySQL Workbench\uc758 MariaDB \ud638\ud658\uc131 \uacbd\uace0<\/h3>\n\n\n<p class=\"wp-block-paragraph\">MySQL Workbench\ub294 MySQL \uc911\uc2ec\uc73c\ub85c \uac1c\ubc1c\ub418\uc5b4 MariaDB \uc11c\ubc84 \uc5f0\uacb0 \uc2dc \ubc84\uc804 \ub610\ub294 \uae30\ub2a5 \ud638\ud658\uc131 \uacbd\uace0\uac00 \ub098\ud0c0\ub0a0 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <strong>\uacbd\uace0\uac00 \uc788\ub2e4\uace0 \ubc18\ub4dc\uc2dc \uc811\uc18d\uc5d0 \uc2e4\ud328\ud558\ub294 \uac83\uc740 \uc544\ub2c8\uc9c0\ub9cc, \ubb34\uc870\uac74 \ubb34\uc2dc\ud574\uc11c\ub3c4 \uc548 \ub429\ub2c8\ub2e4.<\/strong> \ub2e8\uc21c SQL \uc870\ud68c\u00b7\ud3b8\uc9d1\uc740 \uac00\ub2a5\ud558\ub354\ub77c\ub3c4 \uc11c\ubc84 \uad00\ub9ac, \ubaa8\ub378\ub9c1, \uc77c\ubd80 \uba54\ud0c0\ub370\uc774\ud130 \uae30\ub2a5\uc740 \ucc28\uc774\uac00 \uc788\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud544\uc694\ud55c \uae30\ub2a5\uc744 \uc2e4\uc81c\ub85c \ud14c\uc2a4\ud2b8\ud558\uac70\ub098 MariaDB \ud638\ud658 \ud074\ub77c\uc774\uc5b8\ud2b8\ub97c \uc0ac\uc6a9\ud558\uc138\uc694.<\/p>\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"450\" height=\"300\" src=\"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2020\/02\/mysqlbench_mariadb.jpg\" alt=\"MySQL Workbench\uc5d0\uc11c MariaDB \uc11c\ubc84 \uc811\uc18d \uc2dc \ud45c\uc2dc\ub418\ub294 \ud638\ud658\uc131 \uacbd\uace0\uc758 \uacfc\uac70 \ud654\uba74\" class=\"wp-image-6369\" srcset=\"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2020\/02\/mysqlbench_mariadb.jpg 450w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2020\/02\/mysqlbench_mariadb-300x200.jpg 300w\" sizes=\"auto, (max-width: 450px) 100vw, 450px\" \/><\/figure>\n\n\n<p class=\"wp-block-paragraph\"><em>\uc704 \uc774\ubbf8\uc9c0\ub294 \uacfc\uac70 Workbench \uacbd\uace0 \ud654\uba74\uc73c\ub85c, \ucd5c\uc2e0 \ubc84\uc804\uc758 \uc2e4\uc81c \uba54\uc2dc\uc9c0\uc640 \ub2e4\ub97c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/em><\/p>\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"552\" height=\"517\" src=\"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2020\/02\/mysqlbench_mariadb_00.jpg\" alt=\"\uacfc\uac70 MariaDB \uacc4\uc815 Host \uc124\uc815 \uc608\uc2dc \ud654\uba74. \ud604\uc7ac\ub294 root \uc6d0\uaca9 \uacf5\uac1c \ub300\uc2e0 \uc804\uc6a9 \uacc4\uc815 \uc0ac\uc6a9 \uad8c\uc7a5\" class=\"wp-image-6370\" srcset=\"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2020\/02\/mysqlbench_mariadb_00.jpg 552w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2020\/02\/mysqlbench_mariadb_00-300x281.jpg 300w\" sizes=\"auto, (max-width: 552px) 100vw, 552px\" \/><\/figure>\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"647\" src=\"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2020\/02\/mysqlbench_mariadb02-1024x647.jpg\" alt=\"MySQL Workbench\uc5d0\uc11c MariaDB \uc5f0\uacb0\uc774 \uc644\ub8cc\ub41c \uacfc\uac70 \ud654\uba74\" class=\"wp-image-6371\" srcset=\"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2020\/02\/mysqlbench_mariadb02-1024x647.jpg 1024w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2020\/02\/mysqlbench_mariadb02-300x190.jpg 300w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2020\/02\/mysqlbench_mariadb02-768x485.jpg 768w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2020\/02\/mysqlbench_mariadb02-660x417.jpg 660w, https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2020\/02\/mysqlbench_mariadb02.jpg 1130w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n<h3 class=\"wp-block-heading\">8. \uc811\uc18d \uc624\ub958\ubcc4 \uc810\uac80 \ubc29\ubc95<\/h3>\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>\uc624\ub958 \/ \uc99d\uc0c1<\/th><th>\ud655\uc778 \uc0ac\ud56d<\/th><\/tr><\/thead><tbody><tr><td>Can&#8217;t connect \/ Connection refused<\/td><td>MariaDB \uc11c\ube44\uc2a4, bind-address, 3306 \uc218\uc2e0 \uc0c1\ud0dc, \ubc29\ud654\ubcbd \ud655\uc778<\/td><\/tr><tr><td>Access denied for user<\/td><td>\uacc4\uc815\uc758 User@Host, \uc554\ud638, \uad8c\ud55c, \uc778\uc99d \ubc29\uc2dd \ud655\uc778<\/td><\/tr><tr><td>ERROR 1356 \/ mysql.user \ubdf0<\/td><td>mysql.user \uc9c1\uc811 UPDATE \uae08\uc9c0. CREATE USER, ALTER USER, GRANT\ub85c \uad00\ub9ac<\/td><\/tr><tr><td>SSL connection error<\/td><td>\uc11c\ubc84 TLS \uc124\uc815, \uc778\uc99d\uc11c \uc2e0\ub8b0, Workbench SSL \uc635\uc158 \ud655\uc778<\/td><\/tr><tr><td>Workbench \ud638\ud658\uc131 \uacbd\uace0<\/td><td>\ub2e8\uc21c \uc5f0\uacb0 \uc5ec\ubd80\uc640 \ud544\uc694\ud55c \uae30\ub2a5\uc744 \ubcc4\ub3c4\ub85c \ud14c\uc2a4\ud2b8<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n<pre class=\"wp-block-preformatted\">sudo systemctl status mariadb\nsudo journalctl -u mariadb -n 50 --no-pager\nsudo ss -lntp | grep 3306\nsudo mariadb -e \"SHOW VARIABLES LIKE 'bind_address';\"<\/pre>\n\n\n<h3 class=\"wp-block-heading\">9. \ubc84\uc804 \ubc0f \ubcf4\uc548 \ucc38\uace0<\/h3>\n\n\n<p class=\"wp-block-paragraph\">MariaDB\ub294 \uc7a5\uae30 \uc9c0\uc6d0(LTS)\uacfc \ub2e8\uae30 \ub9b4\ub9ac\uc2a4\uac00 \uad6c\ubd84\ub429\ub2c8\ub2e4. \uc6b4\uc601 \uc11c\ubc84\uc5d0\uc11c\ub294 \ucd5c\uc2e0 \ubc88\ud638\ub9cc \ubcf4\uace0 \uc5c5\uadf8\ub808\uc774\ub4dc\ud558\uae30\ubcf4\ub2e4 \ud604\uc7ac \ubc30\ud3ec\ud310 \uc9c0\uc6d0 \ubc94\uc704, \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ud638\ud658\uc131, \ubc31\uc5c5\u00b7\ubcf5\uad6c \uac80\uc99d\uc744 \uae30\uc900\uc73c\ub85c \ubc84\uc804\uc744 \uc120\ud0dd\ud558\uc138\uc694. MariaDB 10.5\ub294 \uc774\ubbf8 \ucee4\ubba4\ub2c8\ud2f0 \uc720\uc9c0\ubcf4\uc218\uac00 \uc885\ub8cc\ub418\uc5c8\uc73c\ubbc0\ub85c \uc9c0\uc6d0\ub418\ub294 \ub9b4\ub9ac\uc2a4\ub85c \uc774\uc804\uc744 \uacc4\ud68d\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n<p class=\"wp-block-paragraph\">\uacf5\uc2dd \ucc38\uace0 \ubb38\uc11c: <a href=\"https:\/\/mariadb.com\/docs\/server\/mariadb-quickstart-guides\/mariadb-remote-connection-guide\">MariaDB \uc6d0\uaca9 \uc5f0\uacb0 \uac00\uc774\ub4dc<\/a> \u00b7 <a href=\"https:\/\/mariadb.com\/docs\/server\/reference\/sql-statements\/account-management-sql-statements\/create-user\">CREATE USER<\/a> \u00b7 <a href=\"https:\/\/mariadb.com\/docs\/server\/reference\/sql-statements\/account-management-sql-statements\/grant\">GRANT<\/a> \u00b7 <a href=\"https:\/\/mariadb.org\/about\/\">MariaDB \ub9b4\ub9ac\uc2a4 \uc9c0\uc6d0 \uc815\ucc45<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>MariaDB \uc6d0\uaca9 \uc811\uc18d\uacfc MySQL Workbench \uc5f0\uacb0 \ubc29\ubc95 (2026\ub144 \uae30\uc900) CentOS\uc5d0\uc11c MariaDB\ub97c \uc124\uce58\ud558\uace0 MySQL Workbench\ub85c \uc811\uc18d\ud560 \ub54c \ub098\ud0c0\ub098\ub294 \ud638\ud658\uc131 \uacbd\uace0\uc640 \uc6d0\uaca9 \uc811\uc18d \uc124\uc815\uc744 \uc815\ub9ac\ud569\ub2c8\ub2e4. \uae30\uc874 MariaDB <a class=\"mh-excerpt-more\" href=\"https:\/\/www.auctionpro.co.kr\/?p=6368\" title=\"MySQL Workbench warning when connecting to MariaDB\">[&#8230;]<\/a><\/p>\n<\/div>","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[225],"tags":[],"class_list":["post-6368","post","type-post","status-publish","format-standard","hentry","category-mariadb"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>MySQL Workbench warning when connecting to MariaDB - AuctionPro<\/title>\n<meta name=\"description\" content=\"MariaDB \uc6d0\uaca9 \uc811\uc18d\uacfc MySQL Workbench \uc5f0\uacb0 \ubc29\ubc95 (2026\ub144 \uae30\uc900) CentOS\uc5d0\uc11c MariaDB\ub97c \uc124\uce58\ud558\uace0 MySQL Workbench\ub85c \uc811\uc18d\ud560 \ub54c \ub098\ud0c0\ub098\ub294 \ud638\ud658\uc131 \uacbd\uace0\uc640 \uc6d0\uaca9 \uc811\uc18d \uc124\uc815\uc744 \uc815\ub9ac\ud569\ub2c8\ub2e4. \uae30\uc874 MariaDB 10.5\u00b710.11 \uc0ac\ub840\ub97c\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.auctionpro.co.kr\/?p=6368\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL Workbench warning when connecting to MariaDB - AuctionPro\" \/>\n<meta property=\"og:description\" content=\"MariaDB \uc6d0\uaca9 \uc811\uc18d\uacfc MySQL Workbench \uc5f0\uacb0 \ubc29\ubc95 (2026\ub144 \uae30\uc900) CentOS\uc5d0\uc11c MariaDB\ub97c \uc124\uce58\ud558\uace0 MySQL Workbench\ub85c \uc811\uc18d\ud560 \ub54c \ub098\ud0c0\ub098\ub294 \ud638\ud658\uc131 \uacbd\uace0\uc640 \uc6d0\uaca9 \uc811\uc18d \uc124\uc815\uc744 \uc815\ub9ac\ud569\ub2c8\ub2e4. \uae30\uc874 MariaDB 10.5\u00b710.11 \uc0ac\ub840\ub97c\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.auctionpro.co.kr\/?p=6368\" \/>\n<meta property=\"og:site_name\" content=\"AuctionPro\" \/>\n<meta property=\"article:published_time\" content=\"2020-02-06T07:09:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-10-26T05:44:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2020\/02\/mysqlbench_mariadb_00.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"552\" \/>\n\t<meta property=\"og:image:height\" content=\"517\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"golgol\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\uae00\uc4f4\uc774\" \/>\n\t<meta name=\"twitter:data1\" content=\"golgol\" \/>\n\t<meta name=\"twitter:label2\" content=\"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04\" \/>\n\t<meta name=\"twitter:data2\" content=\"2\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=6368#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=6368\"},\"author\":{\"name\":\"golgol\",\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/#\\\/schema\\\/person\\\/d3dbae599b06cd55f5b14a3e2116f7a2\"},\"headline\":\"MySQL Workbench warning when connecting to MariaDB\",\"datePublished\":\"2020-02-06T07:09:25+00:00\",\"dateModified\":\"2026-10-26T05:44:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=6368\"},\"wordCount\":194,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=6368#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/auctionpro.co.kr\\\/wp-content\\\/uploads\\\/2020\\\/02\\\/mysqlbench_mariadb.jpg\",\"articleSection\":[\"MariaDB\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=6368#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=6368\",\"url\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=6368\",\"name\":\"MySQL Workbench warning when connecting to MariaDB - AuctionPro\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=6368#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=6368#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/auctionpro.co.kr\\\/wp-content\\\/uploads\\\/2020\\\/02\\\/mysqlbench_mariadb.jpg\",\"datePublished\":\"2020-02-06T07:09:25+00:00\",\"dateModified\":\"2026-10-26T05:44:05+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/#\\\/schema\\\/person\\\/d3dbae599b06cd55f5b14a3e2116f7a2\"},\"description\":\"MariaDB \uc6d0\uaca9 \uc811\uc18d\uacfc MySQL Workbench \uc5f0\uacb0 \ubc29\ubc95 (2026\ub144 \uae30\uc900) CentOS\uc5d0\uc11c MariaDB\ub97c \uc124\uce58\ud558\uace0 MySQL Workbench\ub85c \uc811\uc18d\ud560 \ub54c \ub098\ud0c0\ub098\ub294 \ud638\ud658\uc131 \uacbd\uace0\uc640 \uc6d0\uaca9 \uc811\uc18d \uc124\uc815\uc744 \uc815\ub9ac\ud569\ub2c8\ub2e4. \uae30\uc874 MariaDB 10.5\u00b710.11 \uc0ac\ub840\ub97c\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=6368#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=6368\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=6368#primaryimage\",\"url\":\"https:\\\/\\\/auctionpro.co.kr\\\/wp-content\\\/uploads\\\/2020\\\/02\\\/mysqlbench_mariadb.jpg\",\"contentUrl\":\"https:\\\/\\\/auctionpro.co.kr\\\/wp-content\\\/uploads\\\/2020\\\/02\\\/mysqlbench_mariadb.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?p=6368#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\ud648\",\"item\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL Workbench warning when connecting to MariaDB\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/#website\",\"url\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/\",\"name\":\"AuctionPro\",\"description\":\"\uc625\uc158\ud504\ub85c\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/#\\\/schema\\\/person\\\/d3dbae599b06cd55f5b14a3e2116f7a2\",\"name\":\"golgol\",\"url\":\"https:\\\/\\\/www.auctionpro.co.kr\\\/?author=6\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL Workbench warning when connecting to MariaDB - AuctionPro","description":"MariaDB \uc6d0\uaca9 \uc811\uc18d\uacfc MySQL Workbench \uc5f0\uacb0 \ubc29\ubc95 (2026\ub144 \uae30\uc900) CentOS\uc5d0\uc11c MariaDB\ub97c \uc124\uce58\ud558\uace0 MySQL Workbench\ub85c \uc811\uc18d\ud560 \ub54c \ub098\ud0c0\ub098\ub294 \ud638\ud658\uc131 \uacbd\uace0\uc640 \uc6d0\uaca9 \uc811\uc18d \uc124\uc815\uc744 \uc815\ub9ac\ud569\ub2c8\ub2e4. \uae30\uc874 MariaDB 10.5\u00b710.11 \uc0ac\ub840\ub97c","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.auctionpro.co.kr\/?p=6368","og_locale":"ko_KR","og_type":"article","og_title":"MySQL Workbench warning when connecting to MariaDB - AuctionPro","og_description":"MariaDB \uc6d0\uaca9 \uc811\uc18d\uacfc MySQL Workbench \uc5f0\uacb0 \ubc29\ubc95 (2026\ub144 \uae30\uc900) CentOS\uc5d0\uc11c MariaDB\ub97c \uc124\uce58\ud558\uace0 MySQL Workbench\ub85c \uc811\uc18d\ud560 \ub54c \ub098\ud0c0\ub098\ub294 \ud638\ud658\uc131 \uacbd\uace0\uc640 \uc6d0\uaca9 \uc811\uc18d \uc124\uc815\uc744 \uc815\ub9ac\ud569\ub2c8\ub2e4. \uae30\uc874 MariaDB 10.5\u00b710.11 \uc0ac\ub840\ub97c","og_url":"https:\/\/www.auctionpro.co.kr\/?p=6368","og_site_name":"AuctionPro","article_published_time":"2020-02-06T07:09:25+00:00","article_modified_time":"2026-10-26T05:44:05+00:00","og_image":[{"width":552,"height":517,"url":"https:\/\/www.auctionpro.co.kr\/wp-content\/uploads\/2020\/02\/mysqlbench_mariadb_00.jpg","type":"image\/jpeg"}],"author":"golgol","twitter_card":"summary_large_image","twitter_misc":{"\uae00\uc4f4\uc774":"golgol","\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04":"2\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.auctionpro.co.kr\/?p=6368#article","isPartOf":{"@id":"https:\/\/www.auctionpro.co.kr\/?p=6368"},"author":{"name":"golgol","@id":"https:\/\/www.auctionpro.co.kr\/#\/schema\/person\/d3dbae599b06cd55f5b14a3e2116f7a2"},"headline":"MySQL Workbench warning when connecting to MariaDB","datePublished":"2020-02-06T07:09:25+00:00","dateModified":"2026-10-26T05:44:05+00:00","mainEntityOfPage":{"@id":"https:\/\/www.auctionpro.co.kr\/?p=6368"},"wordCount":194,"commentCount":0,"image":{"@id":"https:\/\/www.auctionpro.co.kr\/?p=6368#primaryimage"},"thumbnailUrl":"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2020\/02\/mysqlbench_mariadb.jpg","articleSection":["MariaDB"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.auctionpro.co.kr\/?p=6368#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.auctionpro.co.kr\/?p=6368","url":"https:\/\/www.auctionpro.co.kr\/?p=6368","name":"MySQL Workbench warning when connecting to MariaDB - AuctionPro","isPartOf":{"@id":"https:\/\/www.auctionpro.co.kr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.auctionpro.co.kr\/?p=6368#primaryimage"},"image":{"@id":"https:\/\/www.auctionpro.co.kr\/?p=6368#primaryimage"},"thumbnailUrl":"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2020\/02\/mysqlbench_mariadb.jpg","datePublished":"2020-02-06T07:09:25+00:00","dateModified":"2026-10-26T05:44:05+00:00","author":{"@id":"https:\/\/www.auctionpro.co.kr\/#\/schema\/person\/d3dbae599b06cd55f5b14a3e2116f7a2"},"description":"MariaDB \uc6d0\uaca9 \uc811\uc18d\uacfc MySQL Workbench \uc5f0\uacb0 \ubc29\ubc95 (2026\ub144 \uae30\uc900) CentOS\uc5d0\uc11c MariaDB\ub97c \uc124\uce58\ud558\uace0 MySQL Workbench\ub85c \uc811\uc18d\ud560 \ub54c \ub098\ud0c0\ub098\ub294 \ud638\ud658\uc131 \uacbd\uace0\uc640 \uc6d0\uaca9 \uc811\uc18d \uc124\uc815\uc744 \uc815\ub9ac\ud569\ub2c8\ub2e4. \uae30\uc874 MariaDB 10.5\u00b710.11 \uc0ac\ub840\ub97c","breadcrumb":{"@id":"https:\/\/www.auctionpro.co.kr\/?p=6368#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.auctionpro.co.kr\/?p=6368"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.auctionpro.co.kr\/?p=6368#primaryimage","url":"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2020\/02\/mysqlbench_mariadb.jpg","contentUrl":"https:\/\/auctionpro.co.kr\/wp-content\/uploads\/2020\/02\/mysqlbench_mariadb.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.auctionpro.co.kr\/?p=6368#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\ud648","item":"https:\/\/www.auctionpro.co.kr\/"},{"@type":"ListItem","position":2,"name":"MySQL Workbench warning when connecting to MariaDB"}]},{"@type":"WebSite","@id":"https:\/\/www.auctionpro.co.kr\/#website","url":"https:\/\/www.auctionpro.co.kr\/","name":"AuctionPro","description":"\uc625\uc158\ud504\ub85c","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.auctionpro.co.kr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Person","@id":"https:\/\/www.auctionpro.co.kr\/#\/schema\/person\/d3dbae599b06cd55f5b14a3e2116f7a2","name":"golgol","url":"https:\/\/www.auctionpro.co.kr\/?author=6"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/6368","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6368"}],"version-history":[{"count":1,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/6368\/revisions"}],"predecessor-version":[{"id":10689,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/6368\/revisions\/10689"}],"wp:attachment":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6368"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6368"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6368"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}