{"id":937,"date":"2020-06-20T17:00:35","date_gmt":"2020-06-20T08:00:35","guid":{"rendered":"https:\/\/www.skyer9.pe.kr\/wordpress\/?p=937"},"modified":"2020-06-30T15:59:59","modified_gmt":"2020-06-30T06:59:59","slug":"mysql-%ec%84%a4%ec%b9%98","status":"publish","type":"post","link":"https:\/\/www.skyer9.pe.kr\/wordpress\/?p=937","title":{"rendered":"MySQL \uc124\uce58"},"content":{"rendered":"

MySQL \uc124\uce58<\/h1>\n

\uc124\uce58<\/h2>\n
sudo apt-get update\nsudo apt-get install mysql-server<\/code><\/pre>\n
root \uc811\uc18d<\/h2>\n
sudo<\/code> \ub97c \uc774\uc6a9\ud574 \uc811\uc18d\ud569\ub2c8\ub2e4. \ud328\uc2a4\uc6cc\ub4dc\ub294 \uc785\ub825\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n
sudo mysql -u root<\/code><\/pre>\n
root<\/code> \uc5d0 \ube44\ubc00\ubc88\ud638\ub97c \uc124\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc, \uad8c\uc7a5\ud558\uc9c0\ub294 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n
SHOW VARIABLES LIKE "%version%";\n\n-- 5.7.6 \uc774\ud6c4 \ubc84\uc804\nALTER USER 'root'@'localhost' IDENTIFIED BY 'test1234';\n\n-- 5.7.6 \uc774\ud6c4 \ubc84\uc804\nSET PASSWORD FOR 'root'@'localhost' = PASSWORD('test1234');<\/code><\/pre>\n
\uacc4\uc815\uc0dd\uc131<\/h2>\n
CREATE DATABASE db_test DEFAULT CHARACTER SET UTF8 COLLATE UTF8_GENERAL_CI;\n\nCREATE USER 'testuser'@'localhost' IDENTIFIED BY 'test1234';\nGRANT ALL PRIVILEGES ON db_test.* to testuser@localhost;\n\nFLUSH PRIVILEGES;\n\nexit<\/code><\/pre>\n
mysql -u testuser -p db_test<\/code><\/pre>\n
\uc6d0\uaca9\uc811\uc18d<\/h2>\n
ssh \ud130\ub110\ub9c1\uc744 \uc774\uc6a9\ud55c \uc811\uc18d\uc774 \uc548\uc804\ud558\uace0 \ud3b8\ud558\ub2e4.<\/p>\n
\"\"<\/a><\/p>\n
\ud0c0\uc784\uc874 \uc9c0\uc815<\/h2>\n
\uc11c\ubc84\uc758 \uc2dc\uac04\ub300\uac00 KST<\/code> \uac00 \uc544\ub2cc \uacbd\uc6b0, \uc544\ub798 \uba85\ub839\uc73c\ub85c mysqld<\/code> \uc758 \uc2dc\uac04\ub300\ub97c \uc870\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
sudo vi \/etc\/mysql\/mysql.conf.d\/mysqld.cnf<\/code><\/pre>\n
[mysqld]\ndefault-time-zone='+9:00'<\/code><\/pre>\n
sudo service mysql restart<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
MySQL \uc124\uce58 \uc124\uce58 sudo apt-get update sudo apt-get install mysql-server root \uc811\uc18d sudo \ub97c \uc774\uc6a9\ud574 \uc811\uc18d\ud569\ub2c8\ub2e4. \ud328\uc2a4\uc6cc\ub4dc\ub294 \uc785\ub825\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. sudo mysql -u root root \uc5d0 \ube44\ubc00\ubc88\ud638\ub97c \uc124\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc, \uad8c\uc7a5\ud558\uc9c0\ub294 \uc54a\uc2b5\ub2c8\ub2e4. SHOW VARIABLES LIKE "%version%"; — 5.7.6 \uc774\ud6c4 \ubc84\uc804 ALTER USER 'root'@'localhost' IDENTIFIED BY 'test1234'; — 5.7.6 \uc774\ud6c4 \ubc84\uc804 SET PASSWORD FOR 'root'@'localhost' =\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,1],"tags":[],"class_list":["post-937","post","type-post","status-publish","format-standard","hentry","category-mysql","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/937","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=937"}],"version-history":[{"count":6,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/937\/revisions"}],"predecessor-version":[{"id":1061,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/937\/revisions\/1061"}],"wp:attachment":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=937"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=937"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=937"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}