{"id":622,"date":"2026-03-30T10:19:04","date_gmt":"2026-03-30T01:19:04","guid":{"rendered":"https:\/\/ubuntu.auctionpro.co.kr\/?page_id=622"},"modified":"2026-10-25T18:26:03","modified_gmt":"2026-10-25T09:26:03","slug":"mysql-8-0-45-%ec%84%a4%ec%b9%98","status":"publish","type":"page","link":"https:\/\/ubuntu.auctionpro.co.kr\/?page_id=622","title":{"rendered":"Ubuntu MySQL \uc124\uce58 \uac00\uc774\ub4dc \u2014 \ubc84\uc804 \ud655\uc778\u00b7\uacc4\uc815\u00b7\uc6d0\uaca9 \uc811\uc18d\u00b7\ubc31\uc5c5"},"content":{"rendered":"\n\n

Ubuntu\uc5d0\uc11c MySQL \uc124\uce58\ubd80\ud130 \uacc4\uc815 \uc0dd\uc131, \uc811\uc18d \ud655\uc778, \ubc31\uc5c5\uae4c\uc9c0 \uc9c4\ud589\ud558\ub294 \uc2e4\uc2b5 \uac00\uc774\ub4dc\uc785\ub2c8\ub2e4.<\/strong> \uae30\uc874 \ubb38\uc11c\uc758 MySQL 8.0.45\ub77c\ub294 \ubc84\uc804\uc740 apt \uc124\uce58\ub9cc\uc73c\ub85c \ubcf4\uc7a5\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uba3c\uc800 \uc800\uc7a5\uc18c\uc758 \uc124\uce58 \ud6c4\ubcf4\ub97c \ud655\uc778\ud558\uc138\uc694. \uc544\ub798 IP\u00b7DB \uc774\ub984\u00b7\ube44\ubc00\ubc88\ud638\ub294 \uc608\uc2dc\uc774\uba70 \uc2e4\uc81c \ud658\uacbd\uc5d0 \ub9de\uac8c \ubc14\uafd4\uc57c \ud569\ub2c8\ub2e4.<\/p>\n

\"\ub370\uc774\ud130\ubca0\uc774\uc2a4
\uc11c\ubc84 \uc6b4\uc601 \ud658\uacbd\uc758 \uc608\uc2dc \uc0ac\uc9c4\uc774\uba70 \uc2e4\uc81c MySQL \uc124\uce58 \ud654\uba74\uc740 \uc544\ub2d9\ub2c8\ub2e4. \uc0ac\uc9c4: Taylor Vick<\/a> \/ Unsplash.<\/figcaption><\/figure>\n

\ubaa9\ucc28<\/h2>
  1. \uc124\uce58 \uc804 \ud658\uacbd\u00b7\ubc84\uc804 \ud655\uc778<\/a><\/li>
  2. \uc124\uce58\uc640 \uc11c\ube44\uc2a4 \ud655\uc778<\/a><\/li>
  3. \ucd08\uae30 \ubcf4\uc548 \uc124\uc815<\/a><\/li>
  4. \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uacc4\uc815 \uc0dd\uc131<\/a><\/li>
  5. \uc6d0\uaca9 \uc811\uc18d \uc124\uc815<\/a><\/li>
  6. \uc811\uc18d\uacfc SQL \uc2e4\uc2b5<\/a><\/li>
  7. \ubc31\uc5c5\u00b7\ubcf5\uc6d0<\/a><\/li>
  8. \uc624\ub958 \ud574\uacb0\uacfc \uc6b4\uc601 \uc810\uac80<\/a><\/li><\/ol>\n

    1. \uc124\uce58 \uc804 Ubuntu\uc640 \ud328\ud0a4\uc9c0 \ubc84\uc804 \ud655\uc778<\/h2>\n

    Ubuntu \uae30\ubcf8 \uc800\uc7a5\uc18c\uc640 Oracle MySQL APT \uc800\uc7a5\uc18c\ub294 \ud328\ud0a4\uc9c0 \ucd9c\ucc98\uac00 \ub2e4\ub985\ub2c8\ub2e4. \uae30\uc874 DB\uac00 \uc788\ub2e4\uba74 \uba3c\uc800 \ubc84\uc804\u00b7\uc800\uc7a5\uc18c\u00b7\ubc31\uc5c5 \uc0c1\ud0dc\ub97c \ud655\uc778\ud558\uace0, \uc2e0\uaddc \uc124\uce58 \uc808\ucc28\ub85c \ub36e\uc5b4\uc4f0\uc9c0 \ub9c8\uc138\uc694.<\/p>\n

    cat \/etc\/os-release\nsudo apt update\napt-cache policy mysql-server\napt-cache madison mysql-server\ndpkg -l 'mysql*' 'mariadb*'<\/code><\/pre>\n
    policy \ucd9c\ub825\uc758 Candidate\uac00 \uc124\uce58 \ud6c4\ubcf4\uc785\ub2c8\ub2e4. Ubuntu \ubc84\uc804\uacfc \ubcf4\uc548 \uc5c5\ub370\uc774\ud2b8 \uc0c1\ud0dc\uc5d0 \ub530\ub77c 8.0.45 \uc774\uc678\uc758 \ubc84\uc804\uc774\ub098 \ub2e4\ub978 \uacc4\uc5f4\uc774 \uc120\ud0dd\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc815\ud655\ud55c 8.0.45 \uc7ac\ud604\uc774 \ubaa9\uc801\uc774\uba74 \ud574\ub2f9 OS\uc5d0 \ub9de\ub294 \uc11c\ubc84\u00b7\ud074\ub77c\uc774\uc5b8\ud2b8\u00b7\uc758\uc874 \ud328\ud0a4\uc9c0\uc758 \uc81c\uacf5 \uc5ec\ubd80\ub97c \ud568\uaed8 \ud655\uc778\ud574\uc57c \ud569\ub2c8\ub2e4. \uc800\uc7a5\uc18c\uc5d0 \uc5c6\ub294 \ubc84\uc804\uc744 \uc124\uce58\ud560 \uc218 \uc788\ub294 \uac83\ucc98\ub7fc \ud2b9\uc815 \ubc84\uc804 \uba85\ub839\uc744 \ubcf5\uc0ac\ud558\uc9c0 \ub9c8\uc138\uc694.<\/p>\n
    Oracle \uc800\uc7a5\uc18c\ub97c \uc0ac\uc6a9\ud560 \uacbd\uc6b0 \uacf5\uc2dd APT \uc548\ub0b4<\/a>\uc5d0\uc11c \uc9c0\uc6d0 Ubuntu \ub9b4\ub9ac\uc2a4\uc640 \uc120\ud0dd \uac00\ub2a5\ud55c MySQL \uacc4\uc5f4\uc744 \uba3c\uc800 \ud655\uc778\ud569\ub2c8\ub2e4. \uc800\uc7a5\uc18c \ubcc0\uacbd\uacfc \uae30\uc874 \uc11c\ubc84 \uc5c5\uadf8\ub808\uc774\ub4dc\ub294 \ubcc4\ub3c4 \uc791\uc5c5\uc73c\ub85c \uacc4\ud68d\ud569\ub2c8\ub2e4.<\/p>\n
    2. MySQL \uc124\uce58\uc640 \uc11c\ube44\uc2a4 \ud655\uc778<\/h2>\n
    \ub2e4\uc74c\uc740 Ubuntu \uc800\uc7a5\uc18c\uc5d0 \uc124\uce58 \ud6c4\ubcf4\uac00 \ud655\uc778\ub41c \uc2e0\uaddc \uc11c\ubc84\uc758 \uc608\uc2dc\uc785\ub2c8\ub2e4. apt\uac00 \uc81c\uc2dc\ud558\ub294 \uc124\uce58\u00b7\uc81c\uac70 \ubaa9\ub85d\uc744 \ud655\uc778\ud55c \ub4a4 \uc9c4\ud589\ud569\ub2c8\ub2e4.<\/p>\n
    sudo apt install mysql-server\nsudo systemctl status mysql --no-pager\nmysql --version\nsudo mysql<\/code><\/pre>\n
    \ub9c8\uc9c0\ub9c9 \uba85\ub839\uc73c\ub85c MySQL \ud504\ub86c\ud504\ud2b8\uc5d0 \uc811\uc18d\ub418\uba74 \ub2e4\uc74c SQL\uc744 \uc2e4\ud589\ud569\ub2c8\ub2e4. mysql –version\uc740 \ud074\ub77c\uc774\uc5b8\ud2b8 \ubc84\uc804\uc774\uace0 SELECT VERSION()\uc740 \uc811\uc18d\ud55c \uc11c\ubc84 \ubc84\uc804\uc785\ub2c8\ub2e4.<\/p>\n
    SELECT VERSION();\nSELECT @@hostname, @@port;\nSHOW VARIABLES LIKE 'character_set_server';\nSHOW VARIABLES LIKE 'collation_server';\nEXIT;<\/code><\/pre>\n
    Ubuntu \ud328\ud0a4\uc9c0\uc758 root \uacc4\uc815\uc774 \uc18c\ucf13 \uc778\uc99d\uc744 \uc0ac\uc6a9\ud558\uba74 sudo mysql\ub85c \uc811\uc18d\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ube44\ubc00\ubc88\ud638 \uc778\uc99d\uc73c\ub85c \uc124\uce58\ud55c \ud658\uacbd\uc740 mysql -u root -p\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uad00\ub9ac\uc790 \uc811\uc18d \ubc29\uc2dd\uc744 \ubc14\uafb8\uae30 \uc804\uc5d0 \ud604\uc7ac \uc778\uc99d \ubc29\uc2dd\uc744 \ud655\uc778\ud558\uc138\uc694.<\/p>\n
    3. \ucd08\uae30 \ubcf4\uc548 \uc124\uc815<\/h2>\n
    sudo mysql_secure_installation<\/code><\/pre>\n
    \uc9c8\ubb38\uc740 \uc124\uce58 \ubc84\uc804\uacfc \uae30\uc874 \uc124\uc815\uc5d0 \ub530\ub77c \ub2ec\ub77c\uc9d1\ub2c8\ub2e4. \ub2e4\uc74c \uae30\uc900\uc73c\ub85c \uc120\ud0dd\ud569\ub2c8\ub2e4.<\/p>\n
    \uc9c8\ubb38<\/th>\uc124\uc815 \uae30\uc900<\/th><\/tr><\/thead>
    VALIDATE PASSWORD<\/td>\ube44\ubc00\ubc88\ud638 \uc815\ucc45\uc744 \uc0ac\uc6a9\ud560\uc9c0 \uc120\ud0dd. \uc6b4\uc601 \ud658\uacbd\uc5d0\uc11c\ub294 \uac15\ud55c \ube44\ubc00\ubc88\ud638 \uc815\ucc45 \uc801\uc6a9 \uad8c\uc7a5<\/td><\/tr>
    Remove anonymous users<\/td>Y \u2014 \uc775\uba85 \uc0ac\uc6a9\uc790 \uc81c\uac70<\/td><\/tr>
    Disallow root login remotely<\/td>Y \u2014 root \uc6d0\uaca9 \ub85c\uadf8\uc778 \uc81c\ud55c<\/td><\/tr>
    Remove test database<\/td>Y \u2014 \ubd88\ud544\uc694\ud55c \ud14c\uc2a4\ud2b8 DB \uc81c\uac70<\/td><\/tr>
    Reload privilege tables<\/td>Y \u2014 \ub3c4\uad6c\uac00 \uc218\ud589\ud55c \ubcc0\uacbd \ubc18\uc601<\/td><\/tr><\/tbody><\/table>\n
    root \uc18c\ucf13 \uc778\uc99d \ud658\uacbd\uc5d0\uc11c\ub294 \uc77c\ubc18\uc801\uc778 \ube44\ubc00\ubc88\ud638 \ub85c\uadf8\uc778\uacfc \ub3d9\uc791\uc774 \ub2e4\ub97c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc624\ub958\uac00 \ub098\uba74 \ucd9c\ub825 \ub0b4\uc6a9\uc744 \ud655\uc778\ud558\uace0 \uc778\uc99d \ud50c\ub7ec\uadf8\uc778\uc744 \ubb34\uc870\uac74 \ubcc0\uacbd\ud558\uc9c0 \ub9c8\uc138\uc694.<\/p>\n
    4. \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uc804\uc6a9 \uacc4\uc815 \uc0dd\uc131<\/h2>\n
    \uc178\uc5d0\uc11c sudo mysql\ub85c \uc811\uc18d\ud55c \ud6c4 \uc2e4\ud589\ud569\ub2c8\ub2e4. \uc608\uc2dc \ube44\ubc00\ubc88\ud638\ub294 \uadf8\ub300\ub85c \uc0ac\uc6a9\ud558\uc9c0 \ub9d0\uace0 \uace0\uc720\ud55c \uae34 \ube44\ubc00\ubc88\ud638\ub85c \ubc14\uafc9\ub2c8\ub2e4.<\/p>\n
    CREATE DATABASE appdb\n  CHARACTER SET utf8mb4\n  COLLATE utf8mb4_0900_ai_ci;\n\nCREATE USER 'appuser'@'localhost'\n  IDENTIFIED BY 'CHANGE_TO_A_UNIQUE_LONG_PASSWORD!';\n\nGRANT SELECT, INSERT, UPDATE, DELETE\n  ON appdb.* TO 'appuser'@'localhost';\n\nSHOW GRANTS FOR 'appuser'@'localhost';<\/code><\/pre>\n
    \uc704 \uad8c\ud55c\uc740 \uc77c\ubc18\uc801\uc778 \ub370\uc774\ud130 \uc870\ud68c\u00b7\uc785\ub825\u00b7\uc218\uc815\u00b7\uc0ad\uc81c\uc6a9\uc785\ub2c8\ub2e4. \ud14c\uc774\ube14 \uc0dd\uc131\u00b7\uc2a4\ud0a4\ub9c8 \ubcc0\uacbd\uc740 \ud3ec\ud568\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ubc30\ud3ec\ub098 \ub9c8\uc774\uadf8\ub808\uc774\uc158\uc5d0 \ud544\uc694\ud55c CREATE\u00b7ALTER\u00b7INDEX \ub4f1\uc758 \uad8c\ud55c\uc740 \ubcc4\ub3c4 \uacc4\uc815\uc73c\ub85c \uad00\ub9ac\ud558\uac70\ub098 \ud544\uc694\ud55c \uc2dc\uc810\uc5d0 \ubd80\uc5ec\ud569\ub2c8\ub2e4.<\/p>\n
    CREATE USER\uc640 GRANT\ub294 \uc989\uc2dc \ubc18\uc601\ub418\ubbc0\ub85c \ubcc4\ub3c4 FLUSH PRIVILEGES\uac00 \ud544\uc694\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uae30\uc874 \ubb38\uc11c\uc758 \uc798\ub9b0 FLUSH PRIVILEG \uba85\ub839\ub3c4 \uc0ac\uc6a9\ud560 \ud544\uc694\uac00 \uc5c6\uc2b5\ub2c8\ub2e4.<\/p>\n
    \uacc4\uc815 \ud45c\ud604<\/th>\uc758\ubbf8<\/th><\/tr><\/thead>
    ‘appuser’@’localhost’<\/td>DB \uc11c\ubc84 \ub0b4\ubd80 \uc811\uc18d\uc6a9 \uacc4\uc815<\/td><\/tr>
    ‘appuser’@’10.0.0.21’<\/td>\uc9c0\uc815\ub41c \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uc11c\ubc84\uc5d0\uc11c \uc811\uc18d\ud558\ub294 \ubcc4\ub3c4 \uacc4\uc815<\/td><\/tr>
    ‘appuser’@’%’<\/td>\uc811\uc18d \ud638\uc2a4\ud2b8\ub97c \uad11\ubc94\uc704\ud558\uac8c \ud5c8\uc6a9\ud558\ubbc0\ub85c \uae30\ubcf8 \uc608\uc81c\ub85c \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc74c<\/td><\/tr><\/tbody><\/table>\n
    \uac19\uc740 \uc0ac\uc6a9\uc790 \uc774\ub984\uc774\uc5b4\ub3c4 host\uac00 \ub2e4\ub974\uba74 \ubcc4\ub3c4 \uacc4\uc815\uc785\ub2c8\ub2e4. appdb.* \uad8c\ud55c\uacfc *.* \uc804\uccb4 DB \uad8c\ud55c\ub3c4 \uad6c\ubd84\ud574\uc57c \ud569\ub2c8\ub2e4. WordPress \uc124\uce58\u00b7\ud50c\ub7ec\uadf8\uc778 \uc5c5\ub370\uc774\ud2b8\ub294 \uc2a4\ud0a4\ub9c8 \ubcc0\uacbd \uad8c\ud55c\uc774 \ud544\uc694\ud560 \uc218 \uc788\uc73c\ubbc0\ub85c \uc704 CRUD \uacc4\uc815\uc744 \uadf8\ub300\ub85c \uc801\uc6a9\ud558\uba74 \uc548 \ub429\ub2c8\ub2e4.<\/p>\n
    5. \uc6d0\uaca9 \uc811\uc18d\uc774 \ud544\uc694\ud55c \uacbd\uc6b0\uc5d0\ub9cc \uc124\uc815<\/h2>\n
    \uc6f9 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uacfc DB\uac00 \uac19\uc740 \uc11c\ubc84\ub77c\uba74 \ub85c\uceec \uc811\uc18d\uc744 \uc720\uc9c0\ud558\uace0 3306 \ud3ec\ud2b8\ub97c \uc678\ubd80\uc5d0 \uc5f4\uc9c0 \uc54a\uc544\ub3c4 \ub429\ub2c8\ub2e4. \uc544\ub798\ub294 DB \uc11c\ubc84 10.0.0.10, \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uc11c\ubc84 10.0.0.21\uc774\ub77c\ub294 \uc0ac\uc124\ub9dd \uc608\uc2dc\uc785\ub2c8\ub2e4.<\/p>\n
    5-1. MySQL \uc218\uc2e0 \uc8fc\uc18c \uc9c0\uc815<\/h3>\n
    sudo cp -a \/etc\/mysql\/mysql.conf.d\/mysqld.conf \/etc\/mysql\/mysql.conf.d\/mysqld.conf.bak\nsudo vi \/etc\/mysql\/mysql.conf.d\/mysqld.conf<\/code><\/pre>\n
    \ubc31\uc5c5 \ud30c\uc77c\uc774 \uc774\ubbf8 \uc788\uc73c\uba74 \ub36e\uc5b4\uc4f0\uc9c0 \uc54a\ub3c4\ub85d \ub2e4\ub978 \uc774\ub984\uc73c\ub85c \uc800\uc7a5\ud569\ub2c8\ub2e4. \ud574\ub2f9 \ud30c\uc77c\uc758 [mysqld] \ud56d\ubaa9 \uc544\ub798 \uae30\uc874 \uc124\uc815\uc744 \uc218\uc815\ud569\ub2c8\ub2e4. \uac19\uc740 \ud56d\ubaa9\uc744 \uc5ec\ub7ec \uacf3\uc5d0 \uc911\ubcf5 \ucd94\uac00\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n
    [mysqld]\nbind-address = 10.0.0.10\nmysqlx-bind-address = 127.0.0.1<\/code><\/pre>\n
    10.0.0.10\uc740 DB \uc11c\ubc84\uac00 \uc2e4\uc81c \ubcf4\uc720\ud55c \uc8fc\uc18c\uc5ec\uc57c \ud569\ub2c8\ub2e4. bind-address\ub97c \uc8fc\uc11d \ucc98\ub9ac\ud574 \ubaa8\ub4e0 \uc778\ud130\ud398\uc774\uc2a4\ub85c \ub178\ucd9c\uc2dc\ud0a4\uae30\ubcf4\ub2e4 \ud544\uc694\ud55c \uc8fc\uc18c\ub97c \uc9c0\uc815\ud569\ub2c8\ub2e4. \uc77c\ubc18 MySQL \uc5f0\uacb0\uc740 3306\uc744 \uc0ac\uc6a9\ud558\uba70 X Protocol\uc758 33060 \ud3ec\ud2b8\ub294 \ubcc4\ub3c4 \uae30\ub2a5\uc785\ub2c8\ub2e4.<\/p>\n
    5-2. \uc6d0\uaca9 \uacc4\uc815\uacfc \ubc29\ud654\ubcbd<\/h3>\n
    DB \uad00\ub9ac\uc790 \uc138\uc158\uc5d0\uc11c \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uc11c\ubc84 IP\uc5d0 \ud55c\uc815\ub41c \uacc4\uc815\uc744 \ub9cc\ub4ed\ub2c8\ub2e4.<\/p>\n
    CREATE USER 'appuser'@'10.0.0.21'\n  IDENTIFIED BY 'CHANGE_TO_ANOTHER_UNIQUE_PASSWORD!';\nGRANT SELECT, INSERT, UPDATE, DELETE\n  ON appdb.* TO 'appuser'@'10.0.0.21';<\/code><\/pre>\n
    DB \uc11c\ubc84\uc758 \uc178\uc5d0\uc11c \ubc29\ud654\ubcbd \uc0c1\ud0dc\ub97c \ud655\uc778\ud569\ub2c8\ub2e4. UFW\uac00 \uc0ac\uc6a9 \uc911\uc778 \uacbd\uc6b0 \uc544\ub798 \uaddc\uce59\uc73c\ub85c \uc811\uc18d \uc6d0\ubcf8\uc744 \uc81c\ud55c\ud569\ub2c8\ub2e4. \uae30\uc874\uc758 \uad11\ubc94\uc704\ud55c \ud5c8\uc6a9 \uaddc\uce59\uc774 \uc788\uc73c\uba74 \uc774 \uaddc\uce59\uc744 \ucd94\uac00\ud574\ub3c4 \uadf8 \uaddc\uce59\uc740 \uacc4\uc18d \uc801\uc6a9\ub429\ub2c8\ub2e4.<\/p>\n
    sudo ufw status numbered\nsudo ufw allow from 10.0.0.21 to any port 3306 proto tcp\nsudo mysqld --validate-config\nsudo systemctl restart mysql\nsudo systemctl status mysql --no-pager\nsudo ss -ltnp | grep ':3306'<\/code><\/pre>\n
    \uc124\uc815 \uac80\uc99d\uc774 \uc2e4\ud328\ud558\uba74 \uc7ac\uc2dc\uc791\ud558\uc9c0 \ub9d0\uace0 \uc624\ub958\ub97c \uc218\uc815\ud569\ub2c8\ub2e4. restart\ub294 \uc5f0\uacb0\uc744 \ub04a\uc744 \uc218 \uc788\uc73c\ubbc0\ub85c \uc6b4\uc601 \uc11c\ubc84\uc5d0\uc11c\ub294 \uc791\uc5c5 \uc2dc\uac04\uc744 \uc815\ud569\ub2c8\ub2e4. \ud074\ub77c\uc6b0\ub4dc \ubcf4\uc548 \uadf8\ub8f9\u00b7\uc678\ubd80 \ubc29\ud654\ubcbd\ub3c4 \uac19\uc740 IP \uae30\uc900\uc73c\ub85c \ud655\uc778\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n
    \uc2e0\ub8b0\ud560 \uc218 \uc5c6\ub294 \ub124\ud2b8\uc6cc\ud06c\ub97c \ud1b5\uacfc\ud55c\ub2e4\uba74 VPN \ub610\ub294 TLS\ub97c \uad6c\uc131\ud569\ub2c8\ub2e4. TLS\ub294 \ud074\ub77c\uc774\uc5b8\ud2b8\uc5d0\uc11c CA\uc640 \uc11c\ubc84 \uc774\ub984\uae4c\uc9c0 \uac80\uc99d\ud558\ub294 VERIFY_IDENTITY \ubc29\uc2dd\uc73c\ub85c \uad6c\uc131\ud558\uace0, \uc11c\ubc84 \uc778\uc99d\uc11c\uc758 \uc774\ub984\uacfc \uc811\uc18d \ud638\uc2a4\ud2b8\ub97c \uc77c\uce58\uc2dc\ucf1c\uc57c \ud569\ub2c8\ub2e4. \ub2e8\uc21c \ud3ec\ud2b8 \uac1c\ubc29\uc740 \uc554\ud638\ud654\ub97c \uc124\uc815\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n
    6. \uc811\uc18d \ud655\uc778\uacfc SQL \uc2e4\uc2b5<\/h2>\n
    \ub85c\uceec \uacc4\uc815\uc740 DB \uc11c\ubc84\uc5d0\uc11c, \uc6d0\uaca9 \uacc4\uc815\uc740 \ud5c8\uc6a9\ud55c \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uc11c\ubc84\uc5d0\uc11c \ud14c\uc2a4\ud2b8\ud569\ub2c8\ub2e4. -p \ub4a4\uc5d0 \ube44\ubc00\ubc88\ud638\ub97c \ubd99\uc774\uc9c0 \uc54a\uace0 \uc785\ub825 \ud504\ub86c\ud504\ud2b8\uc5d0\uc11c \uc785\ub825\ud558\uc138\uc694.<\/p>\n
    # DB \uc11c\ubc84 \ub0b4\ubd80\nmysql -u appuser -p appdb\n\n# \ud5c8\uc6a9\ub41c \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uc11c\ubc84\uc5d0\uc11c\nmysql -h 10.0.0.10 -P 3306 -u appuser -p appdb<\/code><\/pre>\n
    \uad00\ub9ac\uc790\uac00 appdb\uc5d0 \uc2e4\uc2b5\uc6a9 \ud14c\uc774\ube14\uc744 \uba3c\uc800 \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/p>\n
    USE appdb;\nCREATE TABLE connection_test (\n  id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,\n  message VARCHAR(100) NOT NULL,\n  created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP\n);<\/code><\/pre>\n
    \uadf8\ub2e4\uc74c appuser \uc138\uc158\uc5d0\uc11c \ub370\uc774\ud130 \uc791\uc5c5\uacfc \uc2e4\uc81c \uad8c\ud55c \uacc4\uc815\uc744 \ud655\uc778\ud569\ub2c8\ub2e4.<\/p>\n
    SELECT USER(), CURRENT_USER(), DATABASE();\nINSERT INTO connection_test (message) VALUES ('MySQL \uc5f0\uacb0 \uc131\uacf5');\nSELECT * FROM connection_test;\nUPDATE connection_test SET message = '\uc218\uc815 \uc131\uacf5' WHERE id = 1;\nDELETE FROM connection_test WHERE id = 1;\nEXIT;<\/code><\/pre>\n
    7. \ubc31\uc5c5\uacfc \ubcf5\uc6d0<\/h2>\n
    \ub2e4\uc74c\uc740 \ub85c\uceec root \uc18c\ucf13 \uc778\uc99d\uc774 \uac00\ub2a5\ud55c \uc11c\ubc84\uc5d0\uc11c appdb\uc758 \ub17c\ub9ac \ubc31\uc5c5\uc744 \ub9cc\ub4dc\ub294 \uc608\uc2dc\uc785\ub2c8\ub2e4. InnoDB \ud14c\uc774\ube14\uc744 \uc804\uc81c\ub85c \ud558\uba70 \ubc31\uc5c5 \uc911 DDL \ubcc0\uacbd\uc744 \ud53c\ud569\ub2c8\ub2e4. MyISAM \ub4f1 \ube44\ud2b8\ub79c\uc7ad\uc158 \ud14c\uc774\ube14\uc5d0\ub294 \ub3d9\uc77c\ud55c \uc77c\uad00\uc131\uc774 \ubcf4\uc7a5\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n
    umask 077\nsudo mysqldump --single-transaction --routines --triggers --events \\\n  --no-tablespaces --set-gtid-purged=OFF appdb > appdb_backup.sql\necho $?\nls -lh appdb_backup.sql<\/code><\/pre>\n
    \uc885\ub8cc \ucf54\ub4dc 0\uacfc \uc624\ub958 \ucd9c\ub825\uc744 \ud655\uc778\ud569\ub2c8\ub2e4. \ud30c\uc77c\uc774 \uc788\ub2e4\ub294 \uac83\ub9cc\uc73c\ub85c \uc131\uacf5\uc740 \uc544\ub2d9\ub2c8\ub2e4. \uc704 \ub364\ud504\ub294 appdb \ub370\uc774\ud130\uc640 \uac1d\uccb4\uc758 \ubc31\uc5c5\uc774\uba70 \uc0ac\uc6a9\uc790\u00b7\uad8c\ud55c\uc744 \ud568\uaed8 \ubc31\uc5c5\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. GTID \uae30\ubc18 \ubcf5\uc81c \uad6c\ucd95\uc6a9 \ubc31\uc5c5\uc740 \ubcc4\ub3c4 \uc815\ucc45\uc774 \ud544\uc694\ud569\ub2c8\ub2e4.<\/p>\n
    \uba3c\uc800 \ubcc4\ub3c4\uc758 \ud14c\uc2a4\ud2b8 DB\ub85c \ubcf5\uc6d0\ud569\ub2c8\ub2e4. \uae30\uc874 appdb\uc5d0 \ub36e\uc5b4\uc4f0\ub294 \ubcf5\uc6d0\uc740 \ub370\uc774\ud130\uac00 \uad50\uccb4\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
    sudo mysql -e \"CREATE DATABASE appdb_restore CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;\"\nsudo mysql appdb_restore < appdb_backup.sql\nsudo mysql -e \"SHOW TABLES FROM appdb_restore;\"<\/code><\/pre>\n
    \ub8e8\ud2f4\u00b7\uc774\ubca4\ud2b8\u00b7\ubdf0\uc5d0 \uc6d0\ubcf8 DB \uc774\ub984\uc774\ub098 DEFINER\uac00 \ud3ec\ud568\ub418\uc5b4 \uc788\uc73c\uba74 \ubcc4\ub3c4 DB \ubcf5\uc6d0 \uc2dc \ucd94\uac00 \uc870\uc815\uc774 \ud544\uc694\ud569\ub2c8\ub2e4. \uc6b4\uc601 \ubcf5\uad6c \uacc4\ud68d\uc5d0\ub294 \ubcf5\uc6d0 \uc2dc\ud5d8, \uc11c\ubc84 \uc678\ubd80 \uc0ac\ubcf8, \uc554\ud638\ud654\uc640 \ubcf4\uad00 \uae30\uac04\uc744 \ud3ec\ud568\ud569\ub2c8\ub2e4.<\/p>\n
    8. \uc790\uc8fc \ubc1c\uc0dd\ud558\ub294 \uc624\ub958<\/h2>\n\n
    \uc99d\uc0c1<\/th>\ud655\uc778 \ubc29\ubc95<\/th><\/tr><\/thead>
    ERROR 1045 Access denied<\/td>\ube44\ubc00\ubc88\ud638, \uc0ac\uc6a9\uc790@\ud638\uc2a4\ud2b8 \uc870\ud569, \uc778\uc99d \ubc29\uc2dd \ud655\uc778. \ub85c\uceec\uacfc \uc6d0\uaca9 \uacc4\uc815 \uad6c\ubd84<\/td><\/tr>\n
    ERROR 2002 \/ 2003<\/td>MySQL \uc11c\ube44\uc2a4, \uc18c\ucf13 \ub610\ub294 TCP \uc8fc\uc18c, bind-address, \ubc29\ud654\ubcbd \ud655\uc778<\/td><\/tr>\n
    ERROR 1819<\/td>\ube44\ubc00\ubc88\ud638 \uc815\ucc45\uc5d0 \ub9de\ub294 \uae38\uc774\u00b7\ubb38\uc790 \uc870\ud569\uc73c\ub85c \ubcc0\uacbd<\/td><\/tr>\n
    \uc778\uc99d \ud50c\ub7ec\uadf8\uc778 \uad00\ub828 \uc624\ub958<\/td>\ud074\ub77c\uc774\uc5b8\ud2b8 \ub4dc\ub77c\uc774\ubc84\uc758 MySQL \ubc84\uc804 \ud638\ud658\uc131\uacfc TLS \uc124\uc815 \ud655\uc778. \uad6c\ud615 \uc778\uc99d\uc73c\ub85c \ub0ae\ucd94\uae30 \uc804\uc5d0 \ub4dc\ub77c\uc774\ubc84 \uac31\uc2e0 \uac80\ud1a0<\/td><\/tr>\n
    Illegal mix of collations<\/td>\ube44\uad50 \ub300\uc0c1 \uceec\ub7fc\u00b7\ubb38\uc790\uc5f4\uc758 \ubb38\uc790\uc14b\uacfc collation \ud655\uc778. \ud14c\uc774\ube14 \uc804\uccb4 \ubcc0\uacbd \uc804\uc5d0 \uc601\ud5a5\uacfc \uc778\ub371\uc2a4 \uac80\ud1a0<\/td><\/tr>\n
    \uc7ac\uc2dc\uc791 \uc2e4\ud328<\/td>\uc124\uc815 \uc624\ud0c0, \uc798\ubabb\ub41c \uc218\uc2e0 IP, \uc800\uc7a5 \uacf5\uac04, \ud30c\uc77c \uad8c\ud55c, \uc11c\ube44\uc2a4 \ub85c\uadf8 \ud655\uc778<\/td><\/tr><\/tbody><\/table>\n
    sudo journalctl -u mysql -n 100 --no-pager\nsudo tail -n 100 \/var\/log\/mysql\/error.log\ndf -h<\/code><\/pre>\n
    \ub85c\uadf8 \ud30c\uc77c \uc704\uce58\ub294 \uc124\uce58 \uad6c\uc131\uc5d0 \ub530\ub77c \ub2e4\ub97c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc11c\ube44\uc2a4\uac00 \uc815\uc0c1\uc778 \uacbd\uc6b0 \uad00\ub9ac\uc790 \uc138\uc158\uc5d0\uc11c \ub2e4\uc74c \uc815\ubcf4\ub97c \ud655\uc778\ud569\ub2c8\ub2e4.<\/p>\n
    SELECT user, host, plugin FROM mysql.user;\nSHOW VARIABLES LIKE 'bind_address';\nSHOW VARIABLES LIKE 'port';\nSHOW VARIABLES LIKE 'log_error';\nSHOW GRANTS FOR 'appuser'@'localhost';<\/code><\/pre>\n
    \uc644\ub8cc \ud655\uc778<\/h2>\n