{"id":374,"date":"2013-07-01T17:15:46","date_gmt":"2013-07-01T09:15:46","guid":{"rendered":"http:\/\/www.royalwzy.com\/?p=374"},"modified":"2015-09-02T07:32:41","modified_gmt":"2015-09-01T23:32:41","slug":"mysql%e5%ad%a6%e4%b9%a03-mysql5-1%e7%9a%84%e5%90%af%e5%8a%a8%e5%92%8c%e5%81%9c%e6%ad%a2","status":"publish","type":"post","link":"http:\/\/www.royalwzy.com\/?p=374","title":{"rendered":"MySQL\u5b66\u4e603–MySQL5.1\u7684\u542f\u52a8\u548c\u505c\u6b62"},"content":{"rendered":"
Mysql\u542f\u52a8\u76844\u79cd\u65b9\u6cd5<\/span><\/p>\n
    \n
  1. mysqld<\/span>\n
      \n
    1. mysqld\u662fMySql\u670d\u52a1\u5668\u8fdb\u7a0b;<\/span><\/li>\n
    2. mysqld\u542f\u52a8\u65f6\u8bfb\u53d6\u914d\u7f6e\u6587\u4ef6\u4e2d\u7684[mysqld]\u548c[server]\u8282\u70b9<\/span><\/li>\n
    3. \u6211\u4eec\u53ef\u4ee5\u624b\u52a8\u7684\u8c03\u7528mysqld(\u67e5\u770b\u53c2\u6570:mysqld –verbose –help),\u4f46\u662f\u6211\u4eec\u4e00\u822c\u53ea\u5728\u8c03\u8bd5\u7684\u65f6\u5019\u624d\u8fd9\u4e48\u505a,\u5982\u679c\u624b\u52a8\u542f\u52a8\u7684\u8bdd,\u9519\u8bef\u6d88\u606f\u4f1a\u6253\u5370\u5230\u7ec8\u7aef\u5c4f\u5e55\u4e0a\u800c\u4e0d\u662f\u9519\u8bef\u65e5\u5fd7\u6587\u4ef6\u4e2d;<\/span><\/li>\n
    4. \u9ed8\u8ba4\u8bfb\u53d6\u914d\u7f6e\u6587\u4ef6\u7684\u987a\u5e8f\u662f:\n
        \n
      1. \/etc\/my.cnf;<\/li>\n
      2. \/etc\/mysql\/my.cnf;<\/li>\n
      3. \/usr\/local\/mysql\/etc\/my.cnf;<\/li>\n
      4. ~\/.my.cnf;<\/li>\n
      5. \u4f9d\u6b21\u8bfb\u53d6\u540e\u9762\u914d\u7f6e\u6587\u4ef6\u4e2d\u7684\u7684\u9879\u4f1a\u8986\u76d6\u6389\u524d\u9762;<\/li>\n<\/ol>\n<\/li>\n
      6. \u542f\u52a8\u65b9\u5f0f:$MYSQL_HOME\/libexec\/mysqld –defaults-file=.\/my.cnf –user=mysql;<\/span><\/li>\n
      7. \u8fde\u63a5\u65b9\u5f0f:\n
          \n
        1. mysql –defualts-file=.\/my.cnf<\/li>\n
        2. mysql -S \/tmp\/mysql.sock<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n
        3. mysqld_safe<\/span>\n
            \n
          1. mysqld_safe\u8bfb\u53d6\u914d\u7f6e\u6587\u4ef6\u7684[mysqld],[server]\u548c[mysqld_safe]\u8282\u70b9,\u4e3a\u4e86\u5411\u540e\u517c\u5bb9,\u4e5f\u4f1a\u8bfb\u53d6[safe_mysqld]\u8282\u70b9,\u5c3d\u7ba1\u4f60\u5e94\u8be5\u91cd\u547d\u540d[mysqld_safe]\u8282\u70b9\u5728MySql5.1\u7684\u5b89\u88c5\u8fc7\u7a0b\u4e2d;<\/span><\/li>\n
          2. mysqld_safe\u662f\u4e00\u4e2a\u53ef\u4ee5\u8c03\u7528mysqld\u8fdb\u7a0b\u7684shell\u811a\u672c<\/span>,\u5b83\u53ef\u4ee5\u8bbe\u7f6e\u9519\u8bef\u65e5\u5fd7,\u7136\u540e\u8c03\u7528\u5e76\u76d1\u63a7mysqld\u8fdb\u7a0b,\u5982\u679cmysqld\u8fdb\u7a0b\u5f02\u5e38\u7ec8\u6b62(kill -9 pid)\u7684\u8bdd,\u5219mysqld_safe\u53ef\u4ee5\u91cd\u65b0\u542f\u52a8\u5b83;<\/span><\/li>\n
          3. \u542f\u52a8\u65b9\u5f0f:$MYSQL_HOME\/lib\/mysqld_safe –defaults-file=.\/my.cnf –user=mysql &;<\/li>\n
          4. \u8fde\u63a5\u65b9\u5f0f:<\/span>\n
              \n
            1. mysql –defualts-file=.\/my.cnf<\/span><\/li>\n
            2. mysql -S \/tmp\/mysql.sock<\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n
            3. mysql.server\n
                \n
              1. MySql\u7684\u5206\u53d1\u7248\u672c\u5728Unix\u4e0a\u5305\u542b\u4e86\u4e00\u4e2a\u53ebmysql.server\u7684\u811a\u672c,\u5b83\u53ef\u4ee5\u7528\u4e8e\u50cfLinux\u548cSolaris\u7684OS,\u4ee5\u81f3\u4e8e\u80fd\u591f\u4f7f\u7528System V-style\u7684\u65b9\u5f0f\u8fd0\u884c\u76ee\u5f55\u6765\u542f\u52a8\u548c\u5173\u95ed\u7cfb\u7edf\u670d\u52a1.\u5b83\u540c\u6837\u53ef\u4ee5\u88ab\u7528\u4e8eMac OS X\u7cfb\u7edf\u4e0aMySql\u7684\u5f00\u673a\u9879;<\/li>\n
              2. \u5b58\u653e\u7684\u76ee\u5f55\u6709:\n
                  \n
                1. $MYSQL_HOME\/share\/mysql\/mysql.server<\/li>\n
                2. mysql-VERSION\/support-files\/mysql.server<\/li>\n<\/ol>\n<\/li>\n
                3. mysql.server\u8bfb\u53d6\u914d\u7f6e\u6587\u4ef6\u7684[mysql.server]\u548c[mysqld]\u8282\u70b9,\u4e3a\u4e86\u5411\u540e\u517c\u5bb9,\u5b83\u4e5f\u8bfb\u53d6[mysql_server]\u8282\u70b9,\u5c3d\u7ba1\u4f60\u5e94\u8be5\u91cd\u547d\u540d\u6b64\u8282\u70b9\u5728\u4f7f\u7528MySql5.1\u65f6;<\/li>\n
                4. \u5b83\u4f1a\u8c03\u7528mysqld_safe\u8fdb\u7a0b<\/span>;<\/li>\n
                5. \u542f\u52a8\u65b9\u5f0f:\n
                    \n
                  1. cd $MYSQL_HOME\/share\/mysql\/mysql.server start(stop\/restart\/reload\/force-reload\/status)<\/li>\n
                  2. cp\u00a0$MYSQL_HOME\/share\/mysql\/mysql.server \/etc\/rc.d\/init.d\/mysql;chkconfig –add mysql;service mysql start;<\/span><\/li>\n<\/ol>\n<\/li>\n
                  3. \u8fde\u63a5\u65b9\u5f0f:\n
                      \n
                    1. mysql –defualts-file=.\/my.cnf<\/li>\n
                    2. mysql -S \/tmp\/mysql.sock<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n
                    3. mysqld_multi\n
                        \n
                      1. mysqld_multi\u662f\u7528\u6765\u7ba1\u7406\u591a\u4e2a\u5728\u4e0d\u540c\u7684Unix socket\u6587\u4ef6\u548cTCP\/IP\u7aef\u53e3\u76d1\u542c\u7684mysqld\u8fdb\u7a0b\u7684,\u5b83\u53ef\u4ee5\u542f\u52a8,\u505c\u6b62\u548c\u62a5\u544a\u5b83\u4eec\u5f53\u524d\u7684\u72b6\u6001,MySql Instance Manager\u662f\u4e00\u4e2a\u5177\u6709\u9009\u62e9\u610f\u4e49\u7684\u591a\u5b9e\u4f8b\u7ba1\u7406\u670d\u52a1;<\/li>\n
                      2. \u914d\u7f6e\u65b9\u6cd5:\n
                          \n
                        1. \u521b\u5efa\u591a\u5b9e\u4f8b\u7684\u6570\u636e\u6587\u4ef6(\u6709\u51e0\u4e2a\u5b9e\u4f8b\u521b\u5efa\u51e0\u4e2a\u6570\u636e\u6587\u4ef6\u76ee\u5f55):>mkdir $MYSQL_HOME\/data2;<\/li>\n
                        2. \u4fee\u6539\u6570\u636e\u6587\u4ef6\u76ee\u5f55\u7684\u8bbf\u95ee\u6743\u9650:>chown -R mysql:mysql data2;<\/li>\n
                        3. \u5206\u522b\u521d\u59cb\u5316\u5404\u4e2a\u5b9e\u4f8b:>mysql_install_db –basedir=$MYSQL_HOME –datadir=$MYSQL_HOME\/data2 –user=mysql;(\u521d\u59cb\u5316\u65f6\u6307\u5b9abasedir\u548cdatadir\u800c\u4e0d\u662f\u4ece\u914d\u7f6e\u6587\u4ef6\u4e2d\u8bfb\u53d6)<\/li>\n
                        4. \u7f16\u8f91\u914d\u7f6e\u6587\u4ef6:\u6dfb\u52a0[mysqld_multi]\u8282\u70b9\u548c\u591a\u4e2a[mysqldxxxx]\u8282\u70b9;<\/li>\n
                        5. \u542f\u52a8\u5b9e\u4f8b:>mysqld_multi –defaults-file=.\/my.cnf start 3306;<\/li>\n
                        6. \u8fde\u63a5\u65b9\u5f0f:\n
                            \n
                          1. mysql -u root -P 3306 –protocol=tcp;<\/li>\n
                          2. mysql -S \/tmp\/mysql3306.sock<\/li>\n<\/ol>\n<\/li>\n
                          3. \u6dfb\u52a0\u6709\u5173\u95ed\u670d\u52a1\u6743\u9650\u7684\u7528\u6237:>grant shutdown on *.* to “shutdown_user”@”localhost” identified by “pwd” with grant option;(\u67e5\u770b\u6388\u6743\u8bed\u53e5:>show grants for root@localhost;)<\/li>\n
                          4. \u505c\u6b62\u670d\u52a1:>mysqld_multi –defualts-file=.\/my.cnf stop 3306;<\/li>\n
                          5. \u65e5\u5fd7\u6587\u4ef6\u5b58\u653e\u5728:$MYSQL_HOME\/share\/mysqld_multi.log\u6587\u4ef6\u4e2d(mysql5.5\u4e2d$MYSQL_HOME\/data\/mysqld_multi.log\u6587\u4ef6\u4e2d);<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
                            <\/div>\n
                            <\/div>\n
                            \u5173\u95edmysql\u6570\u636e\u5e93\u670d\u52a1\u5668:><\/span>mysqladmin shutdown;<\/div>\n
                            \u67e5\u770bmysql\u670d\u52a1\u5668\u662f\u5426\u5426\u542f\u52a8:>mysqladmin ping;<\/div>\n
                            <\/div>\n
                            \u8fde\u63a5MySql<\/div>\n
                              \n
                            1. \u4ea4\u4e92\u534f\u8bae\n
                                \n
                              1. TCP\/IP:\u652f\u6301\u672c\u5730\u8fde\u63a5\u548c\u8fdc\u7a0b\u8fde\u63a5,\u652f\u6301\u6240\u6709\u7684\u64cd\u4f5c\u7cfb\u7edf,\u9664\u975e\u6307\u5b9a–skip-networking\u9009\u9879;<\/li>\n
                              2. Unix Socket File:\u4ec5\u652f\u6301\u672c\u5730\u8fde\u63a5,\u4ec5\u652f\u6301Unix\u7cfb\u7edf;<\/li>\n
                              3. Named Pipe:\u4ec5\u652f\u6301\u672c\u5730\u8fde\u63a5,\u4ec5\u652f\u6301Windows\u7cfb\u7edf,\u9700\u8981\u4f7f\u7528-nt\u7684\u7248\u672c(mysql-nt or mysql-max-nt),\u6b64\u65b9\u5f0f\u9ed8\u8ba4\u7981\u6b62,\u5982\u679c\u8981\u5f00\u542fNamed Pipe\u65b9\u5f0f\u8fde\u63a5\u5fc5\u987b\u542f\u52a8-nt\u7248\u672c\u7684\u670d\u52a1\u5668\u5e76\u52a0\u4e0a–enable-named-pipe\u9009\u9879;<\/li>\n
                              4. Shared Memory:\u4ec5\u652f\u6301\u672c\u5730\u8fde\u63a5,\u4ec5\u652f\u6301Windows\u7cfb\u7edf,\u9ed8\u8ba4\u7981\u6b62,\u5982\u679c\u8981\u5f00\u542f\u9700\u8981\u6dfb\u52a0–share-memory\u9009\u9879;<\/li>\n<\/ol>\n<\/li>\n
                              5. \u5ba2\u6237\u7aef\u5de5\u5177\n
                                  \n
                                1. mysql:\u662f\u4e00\u4e2a\u5411\u670d\u52a1\u5668\u53d1\u9001SQL\u8bed\u53e5\u7684\u4e00\u822c\u7528\u9014\u7684\u5ba2\u6237\u7aef\u5de5\u5177,\u4e5f\u5305\u542b\u4e86\u4e00\u4e9b\u7ba1\u7406\u7684\u529f\u80fd;<\/li>\n
                                2. mysqladmin:\u662f\u4e00\u4e2a\u5e2e\u52a9\u7ba1\u7406\u670d\u52a1\u5668\u7684\u7ba1\u7406\u547d\u4ee4\u884c\u5ba2\u6237\u7aef;<\/li>\n
                                3. mysqlimport:\u63d0\u4f9b\u4e00\u4e2aLOAD DATA INFILE\u8bed\u53e5\u7684\u63a5\u53e3,\u5e2e\u52a9\u5bfc\u5165\u6570\u636e;<\/li>\n
                                4. mysqldump:\u662f\u4e00\u4e2a\u503e\u5012\u6570\u636e\u5e93\u548c\u8868\u7ed3\u6784\u53ca\u5185\u5bb9\u7684\u5ba2\u6237\u7aef,\u4e3b\u8981\u7528\u4e8e\u5907\u4efd\u548c\u62f7\u8d1d\u6570\u636e\u5e93\u5230\u5176\u5b83\u7684\u673a\u5668;<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
                                  \u00a0<\/span><\/div>\n
                                  \u00a0<\/span><\/div>\n
                                  \u00a0<\/span><\/div>\n
                                  \u00a0<\/span><\/div>\n
                                  \u00a0<\/span><\/div>\n
                                  .\/my.cnf\u6587\u4ef6:<\/span><\/div>\n
                                  [mysqld_multi]<\/span><\/div>\n
                                  mysqld \u00a0 \u00a0 = \/usr\/local\/mysql\/bin\/mysqld_safe \u00a0 \u00a0 — \u542f\u52a8\u670d\u52a1\u7684\u8fdb\u7a0b<\/span><\/div>\n
                                  mysqladmin = \/usr\/local\/mysql\/bin\/mysqladmin \u00a0 \u00a0— \u5173\u95ed\u670d\u52a1\u7684\u8fdb\u7a0b<\/span><\/div>\n
                                  user \u00a0 \u00a0 \u00a0 = shutdown_user \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0— \u6709\u5173\u95ed\u670d\u52a1\u5668\u6743\u9650\u7684\u7528\u6237<\/span><\/div>\n
                                  password \u00a0 = pwd \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0— \u7528\u6237\u5bc6\u7801<\/span><\/div>\n
                                  \u00a0<\/span><\/div>\n
                                  [mysqld3306]<\/div>\n
                                  port \u00a0 \u00a0 \u00a0= 3306 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0— \u76d1\u542c\u7aef\u53e3\u53f7<\/div>\n
                                  socket \u00a0 \u00a0= \/tmp\/mysql3306.sock \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 — socket\u6587\u4ef6<\/div>\n
                                  pid-file \u00a0= \/tmp\/mysql3306.pid \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0— pid\u6587\u4ef6<\/div>\n
                                  basedir \u00a0 = \/usr\/local\/mysql \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0— \u5b9e\u4f8b\u57fa\u76ee\u5f55<\/div>\n
                                  datadir \u00a0 = \/usr\/local\/mysql\/data \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 — \u5b9e\u4f8b\u6570\u636e\u6587\u4ef6\u76ee\u5f55<\/div>\n
                                  …… \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0— \u5176\u5b83\u670d\u52a1\u5668\u53c2\u6570<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

                                  Mysql\u542f\u52a8\u76844\u79cd\u65b9\u6cd5 mysqld mysqld\u662fMySql\u670d\u52a1\u5668\u8fdb\u7a0b; mysqld\u542f\u52a8\u65f6\u8bfb\u53d6\u914d\u7f6e\u6587\u4ef6\u4e2d […]<\/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-374","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\/374","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=374"}],"version-history":[{"count":0,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/374\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=374"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=374"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=374"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}