{"id":19898,"date":"2018-02-26T11:49:00","date_gmt":"2018-02-26T02:49:00","guid":{"rendered":"http:\/\/w3devlabs.net\/wp\/?p=19898"},"modified":"2018-02-25T23:49:47","modified_gmt":"2018-02-25T14:49:47","slug":"%ec%9c%88%eb%8f%84%ec%9a%b010-%ed%99%98%ea%b2%bd%ec%97%90%ec%84%9c-mariadb-%ec%ba%90%eb%a6%ad%ed%84%b0%ec%85%8b-%eb%b3%80%ea%b2%bd%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/w3devlabs.net\/wp\/?p=19898","title":{"rendered":"\uc708\ub3c4\uc6b010 \ud658\uacbd\uc5d0\uc11c mariadb \uce90\ub9ad\ud130\uc14b \ubcc0\uacbd\ud558\uae30"},"content":{"rendered":"

<\/p>\n

\uc708\ub3c4\uc6b010 \ud658\uacbd\uc5d0\uc11c mariadb \uce90\ub9ad\ud130\uc14b \ubcc0\uacbd\ud558\uae30<\/font><\/span><\/p>\n



<\/p>\n

mariadb\ub97c \uc124\uce58\ud558\uace0 \ud504\ub85c\uadf8\ub7a8\uc744 \uc0ac\uc6a9\ud558\ub294\uc911\uc5d0 \ud55c\uae00\uc774 \uae68\uc9c0\uac70\ub098 \ud55c\uae00\ub85c \uac80\uc0c9\ub418\uc9c0 \uc54a\ub294 \uacbd\uc6b0\uac00 \ubc1c\uc0dd\ud558\uc5ec \ud655\uc778\ud574 \ubcf4\uc558\ub354\ub2c8 \uc544\ub798\uc640 \uac19\uc774 latin1\uc73c\ub85c \ub418\uc5b4\uc788\uc2b5\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

$ mysql -u user_id -p<\/font><\/span><\/p>\n


<\/p>\n

<\/span><\/p>\n


<\/p>\n

\uae30\ubcf8 \uce90\ub9ad\ud130\uc14b\uc744 UTF8\ub85c \ubcc0\uacbd\ud574\uc11c \uc0ac\uc6a9\ud574 \ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

\uc124\uce58\ub41c \ud3f4\ub354\uc5d0 my.ini \ud30c\uc77c\uc744 \ucc3e\uc544\uc11c \uc544\ub798\uc640 \uac19\uc774 \ubcc0\uacbd\ud569\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

<\/span><\/p>\n


<\/p>\n

\uae30\ubcf8\ub0b4\uc6a9\uc5d0 \uc544\ub798\uc758 \ub0b4\uc6a9\uc744 \ucd94\uac00\ud558\uc600\uc2b5\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

#################################################<\/font><\/span><\/p>\n

# Chatset Setting<\/font><\/span><\/p>\n

#################################################<\/font><\/span><\/p>\n

[client]<\/font><\/span><\/p>\n

default-character-set=utf8<\/font><\/span><\/p>\n

<\/p>\n

[mysqld]<\/font><\/span><\/p>\n

character-set-server=utf8<\/font><\/span><\/p>\n

collation-server=utf8_general_ci<\/font><\/span><\/p>\n

init_connect=SET collation_connection=utf8_general_ci<\/font><\/span><\/p>\n

init_connect=SET NAMES utf8<\/font><\/span><\/p>\n

<\/p>\n

[mysql]<\/font><\/span><\/p>\n

default-character-set=utf8<\/font><\/span><\/p>\n

#################################################<\/font><\/span><\/p>\n



<\/p>\n

\uc704\uc758 \ub0b4\uc6a9\uc744 \uc800\uc7a5\ud55c\ud6c4\uc5d0 \uc11c\ube44\uc2a4\ub97c \uc7ac\uc2dc\uc791\ud558\ub3c4\ub85d \ud569\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

\uc11c\ube44\uc2a4 \uc81c\uc5b4\ud310\uc5d0\uc11c \uc11c\ube44\uc2a4\ub97c \uc911\ub2e8\ud558\uace0 \uc2dc\uc791\ud558\uba74 \uc7ac\uc2dc\uc791 \ub429\ub2c8\ub2e4. <\/font><\/span><\/p>\n



<\/p>\n

<\/span><\/p>\n


<\/p>\n

\uba85\ub839\uc5b4\ub85c\ub294 \uc544\ub798\uc640 \uac19\uc774 \ud558\uba74 \ub429\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

<\/span><\/p>\n


<\/p>\n

$ net stop mariadb<\/font><\/span><\/p>\n


<\/p>\n

$ net start mariadb<\/font><\/span><\/p>\n


<\/p>\n

\uc704\uc758 \uba85\ub839\uc5b4\ub294 \uba85\ub839\ud504\ub86c\ud504\ud2b8\ub97c \uad00\ub9ac\uc790 \uad8c\ud55c\uc73c\ub85c \uc2e4\ud589\ud574\uc57c \uc815\uc0c1\uc801\uc73c\ub85c \uc791\ub3d9\ud569\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

\ubaa8\ub4e0 \uc124\uc815\uc744 \ub9c8\uce58\uace0 \ub2e4\uc2dc \uc811\uc18d\ud558\uc5ec \ud655\uc778\ud55c \uacb0\uacfc \uc544\ub798\uc640 \uac19\uc774 Server characterset : utf8, client characterset : utf8\ub85c \ubcc0\uacbd\ub41c\uac83\uc744 \ud655\uc778\ud560\uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

<\/span><\/p>\n


<\/p>\n

\uc774\uc81c \ud1a0\ub4dc\uc5d0\uc11c\ub3c4 \ud55c\uae00 \uc870\uac74\uc73c\ub85c \uac80\uc0c9\ud558\ub294\uacbd\uc6b0 \uc815\uc0c1\uc801\uc73c\ub85c \ub0b4\uc6a9\uc774 \ucd9c\ub825\ub429\ub2c8\ub2e4. <\/font><\/span><\/p>\n




<\/p>\n

\uc624\ub298\uc740 \uc774\uc0c1\uacfc \uac19\uc774 mariadb\uc758 \uce90\ub9ad\ud130\uc14b\uc744 \ubcc0\uacbd\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574\uc11c \uc54c\uc544\ubcf4\uc558\uc2b5\ub2c8\ub2e4. <\/font><\/span><\/p>\n



<\/b><\/p>\n","protected":false},"excerpt":{"rendered":"

\uc708\ub3c4\uc6b010 \ud658\uacbd\uc5d0\uc11c mariadb \uce90\ub9ad\ud130\uc14b \ubcc0\uacbd\ud558\uae30 mariadb\ub97c \uc124\uce58\ud558\uace0 \ud504\ub85c\uadf8\ub7a8\uc744 \uc0ac\uc6a9\ud558\ub294\uc911\uc5d0 \ud55c\uae00\uc774 \uae68\uc9c0\uac70\ub098 \ud55c\uae00\ub85c \uac80\uc0c9\ub418\uc9c0 \uc54a\ub294 \uacbd\uc6b0\uac00 \ubc1c\uc0dd\ud558\uc5ec \ud655\uc778\ud574 \ubcf4\uc558\ub354\ub2c8 \uc544\ub798\uc640 \uac19\uc774 latin1\uc73c\ub85c \ub418\uc5b4\uc788\uc2b5\ub2c8\ub2e4. $ mysql -u user_id -p \uae30\ubcf8 \uce90\ub9ad\ud130\uc14b\uc744 UTF8\ub85c \ubcc0\uacbd\ud574\uc11c \uc0ac\uc6a9\ud574 \ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. \uc124\uce58\ub41c \ud3f4\ub354\uc5d0 my.ini \ud30c\uc77c\uc744 \ucc3e\uc544\uc11c \uc544\ub798\uc640 \uac19\uc774 \ubcc0\uacbd\ud569\ub2c8\ub2e4. \uae30\ubcf8\ub0b4\uc6a9\uc5d0 \uc544\ub798\uc758 \ub0b4\uc6a9\uc744 \ucd94\uac00\ud558\uc600\uc2b5\ub2c8\ub2e4. ################################################# # Chatset Setting ################################################# [client] default-character-set=utf8 [mysqld] character-set-server=utf8 … <\/p>\n

\ub354 \ubcf4\uae30 “\uc708\ub3c4\uc6b010 \ud658\uacbd\uc5d0\uc11c mariadb \uce90\ub9ad\ud130\uc14b \ubcc0\uacbd\ud558\uae30”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[5418],"tags":[23641,18565,23642,5291,23640],"class_list":["post-19898","post","type-post","status-publish","format-standard","hentry","category-5418","tag-characterset","tag-mariadb","tag-utf8","tag-5291","tag-23640","entry"],"_links":{"self":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts\/19898","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=19898"}],"version-history":[{"count":1,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts\/19898\/revisions"}],"predecessor-version":[{"id":19899,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts\/19898\/revisions\/19899"}],"wp:attachment":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=19898"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=19898"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=19898"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}