{"id":370,"date":"2013-05-01T17:13:43","date_gmt":"2013-05-01T09:13:43","guid":{"rendered":"http:\/\/www.royalwzy.com\/?p=370"},"modified":"2015-09-02T07:32:27","modified_gmt":"2015-09-01T23:32:27","slug":"mysql%e5%ad%a6%e4%b9%a01-linux%e4%b8%8b%e5%ae%89%e8%a3%85mysql5-1%e6%95%b0%e6%8d%ae%e5%ba%93","status":"publish","type":"post","link":"http:\/\/www.royalwzy.com\/?p=370","title":{"rendered":"MySQL\u5b66\u4e601–Linux\u4e0b\u5b89\u88c5Mysql5.1\u6570\u636e\u5e93"},"content":{"rendered":"
\n
1.<\/span>\u521b\u5efa<\/span>mysql<\/span>\u7528\u6237<\/span>:>useradd mysql<\/span><\/div>\n
\"graphic\"<\/div>\n
2.<\/span>\u89e3\u538b\u7f29<\/span>mysql<\/span>\u7684\u6e90\u7801\u5b89\u88c5\u5305<\/span>:>tar \u2013zxvf mysql-VERSION.tar.gz (<\/span>\u5982\u679c\u8981\u6821\u9a8c\u5b8c\u6574\u6027\u4f7f\u7528<\/span>md5sum mysql-VERSION.tar.gz<\/span>\u00a0\u628a\u5f97\u5230\u7684<\/span>md5<\/span>\u503c\u6bd4\u8f83<\/span>)<\/span><\/div>\n
\"graphic\"<\/div>\n
3.<\/span>\u521b\u5efa\u5b89\u88c5<\/span>mysql<\/span>\u8f6f\u4ef6\u7684\u76ee\u5f55<\/span>:>mkdir \/usr\/local\/mysql<\/span><\/div>\n
4.<\/span>\u8fdb\u5165<\/span>mysql<\/span>\u6e90\u7801\u5305\u76ee\u5f55<\/span>,<\/span>\u5e76\u7f16\u8bd1\u6e90\u7801\u751f\u6210<\/span>makefile<\/span>\u6587\u4ef6<\/span>(<\/span>\u67e5\u770b<\/span>gcc<\/span>\u7684\u7248\u672c<\/span>,<\/span>\u4f7f\u7528<\/span>gcc \u2013version,<\/span>\u00a0\u67e5\u770b<\/span>configure<\/span>\u7684\u547d\u4ee4\u53ef\u4ee5\u8fdb\u5165<\/span>mysql-VERSION<\/span>\u76ee\u5f55\u4f7f\u7528<\/span>.\/configure \u2013help | less<\/span>\u547d\u4ee4<\/span>):<\/span><\/div>\n
.\/configure –prefix=\/usr\/local\/mysql \\\u00a0 \u00a0—<\/span>\u00a0\u5b89\u88c5\u8def\u5f84<\/span><\/div>\n
–without-debug \\\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0—<\/span>\u00a0\u4f7f\u7528\u975e<\/span>DEBUG<\/span>\u65b9\u5f0f\u7f16\u8bd1<\/span><\/div>\n
–enable-thread-safe-client \\\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0—<\/span>\u00a0\u5141\u8bb8\u4ee5\u5ba2\u6237\u7aef\u7ebf\u7a0b\u5b89\u5168\u65b9\u5f0f\u7f16\u8bd1<\/span><\/div>\n
–enable-assembler \\\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0—<\/span>\u00a0\u5141\u8bb8\u4f7f\u7528\u6c47\u7f16\u5b57\u7b26\u4e32\u5904\u7406\u51fd\u6570<\/span><\/div>\n
–enable-profiling \\<\/span><\/div>\n
–with-mysqld-ldflags=-all-static \\ \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0—<\/span>\u00a0\u9759\u6001\u7f16\u8bd1<\/span>,<\/span>\u628a\u51fd\u6570\u653e\u5728\u6267\u884c\u7a0b\u5e8f\u4e2d<\/span><\/div>\n
–with-client-ldflags=-all-static \\<\/span><\/div>\n
–with-charset=latin1 \\\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0—<\/span>\u00a0\u7cfb\u7edf\u9ed8\u8ba4\u5b57\u7b26\u96c6<\/span><\/div>\n
–with-extra-charsets=utf8,gbk \\\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0—<\/span>\u00a0\u7f16\u8bd1\u5b89\u88c5\u5b57\u7b26\u96c6<\/span><\/div>\n
–with-mysqld-user=mysql \\\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0—<\/span>\u00a0\u6307\u5b9a\u8fd0\u884c<\/span>mysqld<\/span>\u7684\u7528\u6237<\/span><\/div>\n
–without-embedded-server \\<\/span><\/div>\n
–with-server-suffix=snda \\\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0—<\/span>\u00a0\u4e2a\u6027\u5316\u5b9a\u5236<\/span>,<\/span>\u5728\u7cfb\u7edf\u7248\u672c\u540e\u7684\u540e\u7f00<\/span><\/div>\n
–with-plugins=innobase,partition\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0—<\/span>\u5b58\u50a8\u5f15\u64ce<\/span><\/div>\n
\"graphic\"<\/div>\n
5.<\/span>\u7f16\u8bd1\u6587\u4ef6<\/span>:>make;make install;<\/span>\u5728<\/span>mysql<\/span>\u7684\u5b89\u88c5\u76ee\u5f55\u4e0b\u751f\u6210\u53ef\u6267\u884c\u6587\u4ef6<\/span><\/div>\n
\"graphic\"<\/div>\n
6.<\/span>\u521b\u5efa\u6570\u636e\u6587\u4ef6<\/span>,<\/span>\u5e76\u4fee\u6539\u76ee\u5f55\u6743\u9650\u4e3a<\/span>mysql:mysql:>mkdir data;chown mysql:mysql data<\/span><\/div>\n
\"graphic\"<\/div>\n
7.<\/span>\u62f7\u8d1d\u914d\u7f6e\u6587\u4ef6<\/span>:>cp ..\/mysql-VERSION\/support-files\/my-medium.cnf .\/my.cnf<\/span><\/div>\n
\"graphic\"<\/div>\n
8.<\/span>\u5728\u914d\u7f6e\u6587\u4ef6\u4e0b\u6dfb\u52a0\u76ee\u5f55\u914d\u7f6e<\/span>,<\/span>\u6307\u5b9a\u6570\u636e\u6587\u4ef6\u7684\u4f4d\u7f6e<\/span><\/div>\n
basedir=\/usr\/local\/mysql<\/span><\/div>\n
datadir=\/usr\/local\/mysql\/data<\/span><\/div>\n
\"graphic\"<\/div>\n
9.<\/span>\u5728<\/span>\/var\/run<\/span>\u6587\u4ef6\u5939\u4e0b\u521b\u5efa<\/span>mysqld<\/span>\u76ee\u5f55\u5e76\u5c5e\u4e8e<\/span>mysql:mysql<\/span><\/div>\n
>cd \/var\/run<\/span><\/div>\n
>mkdir mysqld<\/span><\/div>\n
>chown mysql:mysql mysqld<\/span><\/div>\n
\"graphic\"<\/div>\n
10.<\/span>\u6570\u636e\u5e93\u7684\u521d\u59cb\u5316<\/span>,<\/span>\u4e3b\u8981\u662f\u6570\u636e\u5e93\u7684\u521b\u5efa<\/span>,<\/span>\u5e2e\u52a9\u6587\u4ef6\u7684\u586b\u5145<\/span>,<\/span>\u7528\u6237\u6587\u4ef6\u7684\u586b\u5145<\/span>,<\/span>\u6267\u884c<\/span>:>.\/bin\/mysql_install_db –defaults-file=.\/my.cnf –user=mysql<\/span><\/div>\n
\"graphic\"<\/div>\n
11.<\/span>\u542f\u52a8\u670d\u52a1\u5668<\/span>:>.bin\/mysqld_safe \u2013-user=mysql &<\/span><\/div>\n
\"graphic\"<\/div>\n
12.<\/span>\u4fee\u6539<\/span>MYSQL<\/span>\u670d\u52a1\u5668<\/span>root<\/span>\u7528\u6237\u7684\u5bc6\u7801<\/span>:>.\/bin\/mysqladmin \u2013u root password \u2018pwd\u2019<\/span><\/div>\n
\"graphic\"<\/div>\n
13.<\/span>\u767b\u5f55<\/span>:<\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a01.<\/span>\u5982\u679c\u6ca1\u6709\u8bbe\u7f6e<\/span>root<\/span>\u7684\u5bc6\u7801<\/span>,<\/span>\u9ed8\u8ba4\u662f\u7a7a\u5bc6\u7801<\/span>,<\/span>\u4f7f\u7528<\/span>>.\/bin\/mysql<\/span>\u5c31\u53ef\u4ee5\u767b\u5f55<\/span><\/div>\n
\u00a0\u00a0\u00a0\u00a02.<\/span>\u5982\u679c\u8bbe\u7f6e\u4e86<\/span>root<\/span>\u5bc6\u7801<\/span>,<\/span>\u5219\u767b\u5f55\u65f6\u8981\u6570\u636e\u5bc6\u7801\u9a8c\u8bc1<\/span>>.\/bin\/mysql \u2013uroot -p<\/span><\/div>\n
\"graphic\"<\/div>\n
<\/div>\n
<\/div>\n
mysql\u7684\u7a33\u5b9a\u7ea7\u522b<\/div>\n
1.alpha:\u8868\u660e\u53d1\u884c\u5305\u542b\u5927\u91cf\u672a\u88ab\u5f7b\u5e95\u6d4b\u8bd5\u7684\u65b0\u4ee3\u7801<\/div>\n
2.beta:\u610f\u5473\u7740\u8be5\u7248\u672c\u529f\u80fd\u662f\u5b8c\u6574\u7684,\u5e76\u4e14\u6240\u6709\u7684\u65b0\u4ee3\u7801\u88ab\u6d4b\u8bd5\u4e86,\u6ca1\u6709\u589e\u52a0\u91cd\u8981\u7684\u65b0\u7279\u5f81,\u5e94\u8be5\u6ca1\u6709\u5df2\u77e5\u7684\u7f3a\u9677.\u5f53appha\u7248\u672c\u81f3\u5c11\u4e00\u4e2a\u6708\u6ca1\u6709\u51fa\u73b0\u62a5\u5bfc\u7684\u81f4\u547d\u6f0f\u6d1e,\u5e76\u4e14\u6ca1\u6709\u8ba1\u5212\u589e\u52a0\u5bfc\u81f4\u5df2\u7ecf\u5b9e\u65bd\u7684\u529f\u80fd\u4e0d\u7a33\u5b9a\u7684\u65b0\u529f\u80fd\u65f6,\u7248\u672c\u4ecealpha\u53d8\u4e3abeta\u7248\u672c.<\/div>\n
3.re:\u662f\u53d1\u5e03\u4ee3\u8868,\u662f\u4e00\u4e2a\u53d1\u884c\u4e86\u4e00\u6bb5\u65f6\u95f4\u7684beta\u7248\u672c,\u770b\u8d77\u6765\u5e94\u8be5\u8fd0\u884c\u6b63\u5e38,\u53ea\u589e\u52a0\u4e86\u5f88\u5c0f\u7684\u4fee\u590d.<\/div>\n
4.ga:\u5982\u679c\u6ca1\u6709\u540e\u7f00,\u8fd9\u610f\u5473\u7740\u8be5\u7248\u672c\u5df2\u7ecf\u5728\u5f88\u591a\u5730\u65b9\u8fd0\u884c\u4e00\u6bb5\u65f6\u95f4\u4e86,\u800c\u4e14\u6ca1\u6709\u975e\u5e73\u53f0\u7279\u6027\u7684\u7f3a\u9677\u62a5\u544a.<\/div>\n
<\/div>\n
<\/div>\n
Mysql\u6e90\u7801\u76ee\u5f55,\u4e3b\u8981\u5305\u62ec\u5ba2\u6237\u7aef\u4ee3\u7801,\u670d\u52a1\u7aef\u4ee3\u7801,\u6d4b\u8bd5\u5de5\u5177\u548c\u5176\u4ed6\u5e93\u6587\u4ef6<\/div>\n
1.BUILD:\u5404\u79cd\u5e73\u53f0\u7684\u7f16\u8bd1\u811a\u672c,\u53ef\u4ee5\u7528\u6765\u5236\u4f5c\u5404\u79cd\u5e73\u53f0\u7684\u4e8c\u8fdb\u5236\u7248\u672c<\/div>\n
2.client:\u5ba2\u6237\u7aef\u76ee\u5f55(mysql.cc, mysqadmin.ccl)<\/div>\n
3.docs:\u6587\u6863\u76ee\u5f55<\/div>\n
4.storage:\u5b58\u50a8\u5f15\u64ce\u76ee\u5f55,\u5b9e\u73b0\u4e86handler\u62bd\u8c61\u63a5\u53e3,\u4e3b\u8981\u5305\u542b\u4e00\u4e0b\u76ee\u5f55:<\/div>\n
\u00a0 \u00a0 \u00a01.innobase<\/div>\n
\u00a0 \u00a0 \u00a02.myisam<\/div>\n
\u00a0 \u00a0 \u00a03.myisammrg<\/div>\n
\u00a0 \u00a0 \u00a04.heap<\/div>\n
\u00a0 \u00a0 \u00a05.cvs<\/div>\n
\u00a0 \u00a0 \u00a06.archive<\/div>\n
\u00a0 \u00a0 \u00a07.federated<\/div>\n
\u00a0 \u00a0 \u00a08.ndb<\/div>\n
\u00a0 \u00a0 \u00a09.blackhole<\/div>\n
5.mysys:mysql\u4e3a\u4e86\u5b9e\u73b0\u8de8\u5e73\u53f0\u5bf9\u7cfb\u7edf\u5e93\u5c01\u88c5<\/div>\n
6.sql:\u6570\u636e\u5e93\u4e3b\u7a0b\u5e8f\u76ee\u5f55(sql_insert.cc, sql_update.cc, ..),\u5b58\u50a8\u5f15\u64ce\u63a5\u53e3(handler.cc, handler.h)<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

1.\u521b\u5efamysql\u7528\u6237:>useradd mysql 2.\u89e3\u538b\u7f29mysql\u7684\u6e90\u7801\u5b89\u88c5\u5305:>tar […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[27],"class_list":["post-370","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-mysql"],"_links":{"self":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/370","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=370"}],"version-history":[{"count":0,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/370\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=370"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=370"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=370"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}