{"id":191,"date":"2018-04-16T23:50:05","date_gmt":"2018-04-16T14:50:05","guid":{"rendered":"https:\/\/dong1lkim.oboki.net\/?p=191"},"modified":"2019-09-01T22:21:42","modified_gmt":"2019-09-01T13:21:42","slug":"mysql-mysql-%ec%84%a4%ec%b9%98","status":"publish","type":"post","link":"https:\/\/oboki.net\/workspace\/data-engineering\/database\/mysql\/mysql-mysql-%ec%84%a4%ec%b9%98\/","title":{"rendered":"[MySQL] mysql \uc124\uce58"},"content":{"rendered":"<hr \/>\n<h2>\uc0ac\uc804 \uc900\ube44<\/h2>\n<h3>mysql \uc2dc\uc2a4\ud15c \uc720\uc800 \uc0dd\uc131<\/h3>\n<pre><code>mysql:x:3306:1000::\/home\/mysql:\/bin\/bash\n<\/code><\/pre>\n<h3>\ub514\ub809\ud1a0\ub9ac \uc0dd\uc131 \ubc0f \uad8c\ud55c \ubd80\uc5ec<\/h3>\n<ul>\n<li>\uc5d4\uc9c4 \uacbd\ub85c\n<ul>\n<li><code>mkdir \/apps\/mysql<\/code><\/li>\n<li><code>chown mysql \/apps\/mysql<\/code><\/li>\n<\/ul>\n<\/li>\n<li>\ub370\uc774\ud130\ud30c\uc77c \uacbd\ub85c\n<ul>\n<li><code>mkdir \/data\/mysql<\/code><\/li>\n<li><code>chown mysql \/data\/mysql<\/code><\/li>\n<\/ul>\n<\/li>\n<li>\ub85c\uadf8 \uacbd\ub85c\n<ul>\n<li><code>mkdir \/data\/mysql<\/code><\/li>\n<li><code>chown mysql \/logs\/mysql<\/code><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3>my.cnf<\/h3>\n<ul>\n<li>\ud30c\uc77c \uc0dd\uc131 \ubc0f \uad8c\ud55c \ubd80\uc5ec<br \/>\n<code>touch \/etc\/my.cnf<\/code><br \/>\n<code>chwon mysql \/etc\/my.cnf<\/code><\/li>\n<li>mysql \uc124\uc815\n<p><code>vi \/etc\/my.cnf<\/code><\/p>\n<pre><code>[mysqld]\nuser = mysql\nport = 3306\nbasedir=\/apps\/mysql\ndatadir=\/data\/mysql\nsocket=\/tmp\/mysql.sock\ninnodb_data_file_path=ibdata1:12M:autoextend\ninnodb_log_files_in_group=3\ninnodb_log_file_size=64M\n[mysqld_safe]\nlog-error=\/logs\/mysql\/mysqld.log\n<\/code><\/pre>\n<\/li>\n<\/ul>\n<h3>\ubc14\uc774\ub108\ub9ac \uc900\ube44<\/h3>\n<ul>\n<li>5.7.20 \ubc84\uc804 \uae30\uc900, ftp \uc11c\ubc84\uc5d0\uc11c pre-compiled \ubc14\uc774\ub108\ub9ac \ub2e4\uc6b4\ub85c\ub4dc<\/li>\n<li>mv mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz \/apps\/mysql\/.<\/li>\n<li>chown mysql mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz<\/li>\n<li>tar -xvzf *.tar.gz<\/li>\n<li>mv mysql-5.7.20-linux-glibc2.12-x86_64 5.7.20<\/li>\n<li>symbolic link \uc0dd\uc131<\/li>\n<\/ul>\n<h3>profile \uc124\uc815<\/h3>\n<pre><code>export LD_LIBRARY_PATH=\/apps\/mysql\/lib:$LD_LIBRARY_PATH\nexport PATH=\/apps\/mysql\/bin:$PAT\n<\/code><\/pre>\n<hr \/>\n<h2>mysql \uc124\uce58<\/h2>\n<h2>initialize mysql<\/h2>\n<p><code>mysqld --initialize --user=mysql<\/code><\/p>\n<h3>mysql \uc2e4\ud589<\/h3>\n<p><code>mysqld_safe --user=mysql &amp;<\/code><\/p>\n<h3>password \ubcc0\uacbd<\/h3>\n<p>mysql\uc744 \uc0ac\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294 \ubb34\uc870\uac74 \ucd08\uae30 \ube44\ubc00\ubc88\ud638\ub97c \ubcc0\uacbd\ud574\uc8fc\uc5b4\uc57c\ud55c\ub2e4. \uc55e\uc11c <code>mysqld --initialize --user=mysql<\/code> \uba85\ub839 \uc218\ud589 \uc2dc \ucd9c\ub825\ub41c \uc784\uc2dc \ube44\ubc00\ubc88\ud638\ub85c \uba3c\uc800 \ub85c\uadf8\uc778\ud55c\ub2e4.<br \/>\n<code>mysql -u root -p<\/code><br \/>\n\ud45c\uc900\ucd9c\ub825\uc73c\ub85c \ub098\ud0c0\ub09c \uc784\uc2dc \ube44\ubc00\ubc88\ud638\ub97c \uc785\ub825\ud558\uace0, SQL prompt \uc5d0 \uc544\ub798 DDL\uc744 \uc218\ud589\ud574 \ud328\uc2a4\uc6cc\ub4dc\ub97c \ubcc0\uacbd\ud55c\ub2e4.<\/p>\n<pre><code>ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';\n<\/code><\/pre>\n<h3>user \uc0dd\uc131<\/h3>\n<pre><code>create user 'myname'@'%' identified by 'mypassword';\n<\/code><\/pre>\n<h3>database \uc0dd\uc131<\/h3>\n<pre><code>create database database_name;\n<\/code><\/pre>\n<h3>\uad8c\ud55c \ubd80\uc5ec<\/h3>\n<pre><code>grant all privileges on database_name.* to myname@localhost;\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\uc0ac\uc804 \uc900\ube44 mysql \uc2dc\uc2a4\ud15c \uc720\uc800 \uc0dd\uc131 mysql:x:3306:1000::\/home\/mysql:\/bin\/bash \ub514\ub809\ud1a0\ub9ac \uc0dd\uc131 \ubc0f \uad8c\ud55c \ubd80\uc5ec \uc5d4\uc9c4 \uacbd\ub85c mkdir \/apps\/mysql chown mysql \/apps\/mysql \ub370\uc774\ud130\ud30c\uc77c \uacbd\ub85c mkdir \/data\/mysql chown mysql \/data\/mysql \ub85c\uadf8 \uacbd\ub85c mkdir \/data\/mysql chown mysql \/logs\/mysql my.cnf \ud30c\uc77c \uc0dd\uc131 \ubc0f \uad8c\ud55c \ubd80\uc5ec touch \/etc\/my.cnf chwon mysql \/etc\/my.cnf mysql \uc124\uc815 vi \/etc\/my.cnf [mysqld] user = mysql port = 3306 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[62],"tags":[110,50],"class_list":["post-191","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-mysql","tag-50"],"_links":{"self":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/191","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/comments?post=191"}],"version-history":[{"count":10,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/191\/revisions"}],"predecessor-version":[{"id":1276,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/191\/revisions\/1276"}],"wp:attachment":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/media?parent=191"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/categories?post=191"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/tags?post=191"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}