{"id":176,"date":"2025-03-17T02:05:58","date_gmt":"2025-03-17T02:05:58","guid":{"rendered":"http:\/\/www.soon7shop.kr\/wordpress\/?p=176"},"modified":"2025-03-17T02:05:58","modified_gmt":"2025-03-17T02:05:58","slug":"mysql-%ec%9a%b0%eb%b6%84%ed%88%ac-%eb%8d%b0%ec%9d%b4%ed%84%b0-%eb%b2%a0%ec%9d%b4%ec%8a%a4%ec%97%90%ec%84%9c-%ec%82%ac%ec%9a%a9%ec%9e%90-%eb%b3%b4%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/www.soon7shop.kr\/wordpress\/?p=176","title":{"rendered":"mysql, \uc6b0\ubd84\ud22c, \ub370\uc774\ud130 \ubca0\uc774\uc2a4\uc5d0\uc11c \uc0ac\uc6a9\uc790 \ubcf4\uae30"},"content":{"rendered":"

\uc6b0\ubd84\ud22c\uc5d0\uc11c MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc5f0\uacb0\ud558\uc5ec \uc0ac\uc6a9\uc790 \ubaa9\ub85d\uc744 \ud655\uc778\ud558\ub824\uba74, \ub2e4\uc74c \ub2e8\uacc4\ub97c \ub530\ub974\uc138\uc694:<\/p>\n

    \n
  1. \n

    MySQL\uc5d0 \ub85c\uadf8\uc778<\/strong>: MySQL \uc11c\ubc84\uc5d0 \uc811\uc18d\ud558\ub824\uba74 \ud130\ubbf8\ub110\uc5d0\uc11c \ub2e4\uc74c \uba85\ub839\uc5b4\ub97c \uc785\ub825\ud569\ub2c8\ub2e4. mysql<\/code> \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub85c\uadf8\uc778\ud569\ub2c8\ub2e4:<\/p>\n

    \n
    bash<\/div>\n
    \n
    \n
    <\/div>\n<\/div>\n<\/div>\n
    sudo mysql -u root -p
    \n<\/code><\/div>\n<\/div>\n

    \uc5ec\uae30\uc11c root<\/code>\ub294 MySQL\uc758 \uad00\ub9ac\uc790 \uacc4\uc815\uc785\ub2c8\ub2e4. \ube44\ubc00\ubc88\ud638\ub97c \uc785\ub825\ud558\ub77c\ub294 \uba54\uc2dc\uc9c0\uac00 \ub098\ud0c0\ub098\uba74, MySQL root \uacc4\uc815\uc758 \ube44\ubc00\ubc88\ud638\ub97c \uc785\ub825\ud569\ub2c8\ub2e4.<\/p>\n<\/li>\n

  2. \n

    \uc0ac\uc6a9\uc790 \ubaa9\ub85d \uc870\ud68c<\/strong>: MySQL\uc5d0 \uc811\uc18d\ud55c \ud6c4, \ub2e4\uc74c SQL \ucffc\ub9ac\ub97c \uc785\ub825\ud558\uc5ec \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uc0ac\uc6a9\uc790\uc758 \ubaa9\ub85d\uc744 \uc870\ud68c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n

    \n
    sql<\/div>\n
    \n
    \n
    <\/div>\n<\/div>\n<\/div>\n
    SELECT<\/span> user<\/span>, host FROM<\/span> mysql.user;
    \n<\/code><\/div>\n<\/div>\n

    \uc774 \uba85\ub839\uc5b4\ub294 mysql<\/code> \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 user<\/code> \ud14c\uc774\ube14\uc5d0\uc11c \ubaa8\ub4e0 \uc0ac\uc6a9\uc790\uc640 \ud574\ub2f9 \ud638\uc2a4\ud2b8 \uc815\ubcf4\ub97c \ud45c\uc2dc\ud569\ub2c8\ub2e4.<\/p>\n<\/li>\n

  3. \n

    MySQL\uc5d0\uc11c \ub098\uac00\uae30<\/strong>: \uc0ac\uc6a9\uc790\ub97c \ud655\uc778\ud55c \ud6c4 MySQL\uc5d0\uc11c \ub098\uac00\ub824\uba74 \ub2e4\uc74c \uba85\ub839\uc5b4\ub97c \uc785\ub825\ud569\ub2c8\ub2e4:<\/p>\n

    \n
    sql<\/div>\n
    \n
    \n