{"id":1550,"date":"2006-12-11T23:21:54","date_gmt":"2006-12-11T14:21:54","guid":{"rendered":"http:\/\/pchero21.com\/?p=1550"},"modified":"2006-12-11T23:21:54","modified_gmt":"2006-12-11T14:21:54","slug":"apm-mysql-%ec%84%a4%ec%b9%98-2","status":"publish","type":"post","link":"http:\/\/pchero21.com\/?p=1550","title":{"rendered":"[APM] MYSQL \uc124\uce58"},"content":{"rendered":"

1. MYSQL \uc124\uce58<\/p>\n

– \ud648\ud398\uc774\uc9c0 : http:\/\/www.mysql.org<\/a><\/p>\n

– MYSQL \ub2e4\uc6b4\ubc1b\uae30
\nwget ftp:\/\/ftp.superuser.co.kr\/mysql\/mysql-4.1.8.tar.gz<\/p>\n

– \uc555\ucd95\ud574\uc81c
\ntar xvfz mysql-4.1.8.tar.gz<\/p>\n

– \ub514\ub809\ud1a0\ub9ac \uc774\ub3d9
\ncd mysql-4.1.8<\/p>\n

– configure
\n.\/configure –prefix=\/usr\/local\/mysql –localstatedir=\/usr\/local\/mysql\/data –with-charset=euckr<\/p>\n

– configure \uc635\uc158 \uc124\uba85
\n–prefix=\/usr\/local\/mysql : \uc124\uce58\ub420 MYSQL \uc758 \uc704\uce58\uc9c0\uc815<\/p>\n

–localstatedir=\/usr\/local\/mysql\/data : MYSQL \uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub370\uc774\ud130\ub4e4\uc774 \uc800\uc7a5\ub420 \uc704\uce58\uc9c0\uc815<\/p>\n

–with-charset=euckr : MYSQL \uc5d0\uc11c \ud55c\uae00\uc9c0\uc6d0\uc744 \ud558\uae30\uc704\ud55c \uc124\uc815. \uc8fc\uc758\ud560 \uac83\uc740 \uc608\uc804\ubc84\uc804\uc5d0\uc11c\ub294 euc_kr \ub85c \uc9c0\uc815\uc744 \ud558\uc600\uc73c\ub098 4.1.X \uc774\ud6c4\ubc84\uc804 \ubd80\ud130\ub294 euckr \ub85c \uc9c0\uc815\ud568.<\/p>\n

–without-innodb : InnoDB \ud14c\uc774\ube14 \ud578\ub4e4\ub7ec\ub97c \ud3ec\ud568\ud558\uc9c0 \uc54a\uace0 \ucef4\ud30c\uc77c\uc744 \ud55c\ub2e4.<\/p>\n

–disable-largefile : \ud070\ud30c\uc77c \uc9c0\uc6d0\uc744 \ud558\uc9c0 \uc54a\ub3c4\ub85d \uc124\uce58\ud55c\ub2e4. MYSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc131\ub2a5\ubcf4\ub2e4\ub294 \uc548\uc815\uc131\uc744 \uc704\ud55c \uc635\uc158\uc785.<\/p>\n

–with-raid : RAID \ub97c \uc9c0\uc6d0\ud558\ub3c4\ub85d \ucef4\ud30c\uc77c\ud55c\ub2e4.<\/p>\n

–with-unix-socket-path=SOCKET : MYSQL \uc18c\ucf13\ud30c\uc77c( mysql.socket ) \ud30c\uc77c\uc758 \uc704\uce58\ub97c \uc9c0\uc815\ud560 \uc218 \uc788\uc74c. \ub2e8, \uc9c0\uc815\ud560 \ub54c\uc5d0\ub294 \ubc18\ub4dc\uc2dc \uc808\ub300\uacbd\ub85c\ub97c \uc774\uc6a9\ud574\uc57c \ud568.<\/p>\n

–with-mysqld-user=username : mysqld\ub370\ubaac\uc744 \uc2e4\ud589\ud560 \uacc4\uc815\uba85\uc744 \uc9c0\uc815\ud560 \uc218 \uc788\uc74c.<\/p>\n

— with-zlib-dir=DIR : \ub370\uc774\ud130\uc555\ucd95 \ub77c\uc774\ube0c\ub7ec\ub9ac\uc778 zlib\uc744 \uc9c0\uc6d0\ud558\uae30 \uc704\ud55c zlib\uc124\uce58\uc704\uce58\ub97c \uc9c0\uc815\ud558\ub294 \uc635\uc158\uc784.<\/p>\n

–with-openssl-includes=DIR : OpenSSL \uc744 \uc9c0\uc6d0\ud558\uae30\uc704\ud55c \uc635\uc158\uc73c\ub85c DIR \uc5d0\ub294 OpenSSL \uc758 \ud5e4\ub4dc\uc704\uce58\ub97c \uc9c0\uc815\ud55c\ub2e4.<\/p>\n

–with-openssl-libs=DIR : OpeSSL \uc758 \ub77c\uc774\ube0c\ub7ec\ub9ac\ub97c \uc9c0\uc6d0\ud558\uae30\uc704\ud55c \uc635\uc158\uc73c\ub85c DIR \uc5d0\ub294 OpenSSL \uc758 \ub77c\uc774\ube0c\ub7ec\ub9ac \uc704\uce58\ub97c \uc9c0\uc815\ud55c\ub2e4.<\/p>\n

–with-isam : ISAM \ud0c0\uc785\uc758 \ud14c\uc774\ube14\uc744 \uc9c0\uc6d0\ud558\ub294 \uc635\uc158\uc784<\/p>\n

– make
\nmake<\/p>\n

– make install
\nmake install<\/p>\n

– \/usr\/local\/mysql\/bin \uc73c\ub85c \uc774\ub3d9\ud558\uc5ec mysql_install.db \ub97c \uc2e4\ud589\ud55c\ub2e4. \uadf8 \uacb0\uacfc \/usr\/local\/mysql\/data \ub514\ub809\ud1a0\ub9ac\uac00 \uc0dd\uc131\uc774 \ub418\uba70 \uc774 \ub514\ub809\ud1a0\ub9ac\ub0b4\uc5d0 mysql \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 test \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0dd\uc131\ud558\uac8c \ub41c\ub2e4.
\ncd \/usr\/local\/mysql\/bin
\n.\/mysql_install.db<\/p>\n

– MYSQL \uc758 \uc2e4\ud589
\n\/usr\/local\/mysql\/bin\/mysqld_safe &<\/p>\n

– error \uac00 \ubc1c\uc0dd\ud55c\ub2e4. mysql \uc0ac\uc6a9\uc790\ub97c \ucd94\uac00\ud558\uace0 \ub2e4\uc2dc \uc2e4\ud589\ud55c\ub2e4.
\nuseradd -M mysql
\nchown -r mysql:mysql \/usr\/local\/mysql\/data<\/p>\n

– MYSQL \uc2e4\ud589
\n\/usr\/local\/mysql\/bin\/mysqld_safe &<\/p>\n

– MYSQL \uc758 \uad00\ub9ac\uc790( root ) \ud328\uc2a4\uc6cc\ub4dc \uc124\uc815
\ncd \/usr\/local\/mysql\/bin
\n.\/mysqladmin -u root password 88888888
\n.\/mysqladmin -u root -p mysql<\/p>\n","protected":false},"excerpt":{"rendered":"

1. MYSQL \uc124\uce58 – \ud648\ud398\uc774\uc9c0 : http:\/\/www.mysql.org – MYSQL \ub2e4\uc6b4\ubc1b\uae30 wget ftp:\/\/ftp.superuser.co.kr\/mysql\/mysql-4.1.8.tar.gz – \uc555\ucd95\ud574\uc81c tar xvfz mysql-4.1.8.tar.gz – \ub514\ub809\ud1a0\ub9ac \uc774\ub3d9 cd mysql-4.1.8 – configure .\/configure –prefix=\/usr\/local\/mysql –localstatedir=\/usr\/local\/mysql\/data –with-charset=euckr – configure \uc635\uc158 \uc124\uba85 –prefix=\/usr\/local\/mysql : \uc124\uce58\ub420 MYSQL \uc758 \uc704\uce58\uc9c0\uc815 –localstatedir=\/usr\/local\/mysql\/data : … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[17],"tags":[],"_links":{"self":[{"href":"http:\/\/pchero21.com\/index.php?rest_route=\/wp\/v2\/posts\/1550"}],"collection":[{"href":"http:\/\/pchero21.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/pchero21.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/pchero21.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/pchero21.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1550"}],"version-history":[{"count":0,"href":"http:\/\/pchero21.com\/index.php?rest_route=\/wp\/v2\/posts\/1550\/revisions"}],"wp:attachment":[{"href":"http:\/\/pchero21.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1550"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/pchero21.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1550"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/pchero21.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1550"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}