{"id":21,"date":"2024-12-01T07:49:30","date_gmt":"2024-12-01T07:49:30","guid":{"rendered":"http:\/\/211.230.203.47\/wordpress\/?p=21"},"modified":"2024-12-01T07:49:30","modified_gmt":"2024-12-01T07:49:30","slug":"%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-%eb%a6%ac%ec%8a%a4%ed%8a%b8-%eb%b3%b4%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/www.soon7shop.kr\/wordpress\/?p=21","title":{"rendered":"\ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub9ac\uc2a4\ud2b8 \ubcf4\uae30"},"content":{"rendered":"

MySQL\uc5d0\uc11c \ud604\uc7ac \uc11c\ubc84\uc5d0 \uc874\uc7ac\ud558\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubaa9\ub85d\uc744 \ubcf4\ub824\uba74 \ub2e4\uc74c \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc138\uc694:<\/p>\n

\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub9ac\uc2a4\ud2b8 \ubcf4\uae30<\/h2>\n

MySQL\uc5d0 \uc811\uc18d\ud55c \ud6c4 \uc544\ub798 \uba85\ub839\uc5b4\ub97c \uc785\ub825\ud569\ub2c8\ub2e4:<\/p>\n

\n
sql<\/div>\n
\n
\n
<\/div>\n<\/div>\n<\/div>\n
SHOW<\/span> DATABASES;
\n<\/code><\/div>\n<\/div>\n
\n

\uc608\uc2dc<\/h3>\n
    \n
  1. MySQL\uc5d0 \uc811\uc18d:\n
    \n
    bash<\/div>\n
    \n
    \n
    <\/div>\n<\/div>\n<\/div>\n
    sudo mysql -u root -p
    \n<\/code><\/div>\n<\/div>\n

    \ub610\ub294:<\/p>\n

    \n
    bash<\/div>\n
    \n
    \n
    <\/div>\n<\/div>\n<\/div>\n
    mysql -u \uc0ac\uc6a9\uc790\uba85 -p
    \n<\/code><\/div>\n<\/div>\n<\/li>\n
  2. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubaa9\ub85d \ud655\uc778:\n
    \n
    sql<\/div>\n
    \n
    \n
    <\/div>\n<\/div>\n<\/div>\n
    SHOW<\/span> DATABASES;
    \n<\/code><\/div>\n<\/div>\n<\/li>\n<\/ol>\n

    \ucd9c\ub825 \uc608\uc2dc<\/h3>\n
    \n
    diff<\/div>\n
    \n
    \n
    <\/div>\n<\/div>\n<\/div>\n
    +--------------------+<\/span>
    \n<\/code><\/div>\n
    | Database |
    \n<\/code><\/div>\n
    +--------------------+<\/span>
    \n<\/code><\/div>\n
    | information_schema |<\/code><\/div>\n
    | mysql |<\/code><\/div>\n
    | performance_schema |
    \n<\/code><\/div>\n
    | sys |
    \n<\/code><\/div>\n
    | wordpress |<\/code><\/div>\n
    +--------------------+<\/span>
    \n<\/code><\/div>\n<\/div>\n
    \n

    \uc8fc\uc694 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uba85<\/h3>\n