{"id":1291,"date":"2017-01-28T20:58:12","date_gmt":"2017-01-28T12:58:12","guid":{"rendered":"http:\/\/www.royalwzy.com\/?p=1291"},"modified":"2017-01-28T21:30:07","modified_gmt":"2017-01-28T13:30:07","slug":"mysql-ocp-03-%e7%b3%bb%e7%bb%9f%e7%ae%a1%e7%90%86","status":"publish","type":"post","link":"http:\/\/www.royalwzy.com\/?p=1291","title":{"rendered":"MySQL OCP-03-\u7cfb\u7edf\u7ba1\u7406"},"content":{"rendered":"
—\u00a0MySQL\u670d\u52a1\u5668\u5206\u53d1;<\/div>\n
1.MySQL\u53ef\u7528\u4e8e\u591a\u4e2a\u64cd\u4f5c\u7cfb\u7edf,\u5305\u62ecLinux\/Windows\/Mac\u00a0OS\u00a0X\u548cOracle\u00a0Solaris\u7b49;\u672c\u8bfe\u7a0b\u4ec5\u8bb2\u8ff0Linux;<\/div>\n
2.MySQL\u53ef\u4ee5\u4f5c\u4e3a\u4e8c\u8fdb\u5236\u6587\u4ef6\u5206\u53d1\u548c\u6e90\u4ee3\u7801\u5206\u53d1\u7684\u5f62\u5f0f\u63d0\u4f9b:<\/div>\n
\u00a0 \u00a0 1.\u4e8c\u8fdb\u5236\u6587\u4ef6\u5206\u53d1:\u662f\u9884\u7f16\u8bd1\u7684,\u53ef\u4ee5\u8fd0\u884c\u7684\u7a0b\u5e8f,\u53ef\u7528\u4e8eEnterprise\u548cCommunity\u00a0MySQL\u00a0Server\u7248\u672c,\u8fd9\u4e9b\u4e8c\u8fdb\u5236\u6587\u4ef6\u662f\u6b63\u5f0f\u7684\u7ecf\u8fc7Oracle\u6d4b\u8bd5\u7684\u7248\u672c;<\/div>\n
\u00a0 \u00a0 2.\u6e90\u4ee3\u7801\u5206\u53d1:\u4e0d\u4fdd\u8bc1\u4e0e\u5546\u4e1a\u4ee3\u7801\u66f4\u65b0\u4e00\u81f4,\u5b83\u4eec\u4e5f\u4e0d\u5305\u62ecOracle\u652f\u6301;<\/div>\n
TIPS:\u6709\u5173\u53ef\u7528OS\u7c7b\u578b\u7684\u5b8c\u6574\u5217\u8868http:\/\/dev.mysql.com\/downloads\/mysql\/;<\/div>\n
<\/div>\n
—\u00a0MySQL\u4e8c\u8fdb\u5236\u6587\u4ef6\u5206\u53d1;<\/div>\n
1.\u7528\u4e8eLinux\u7684\u4e8c\u8fdb\u5236\u6587\u4ef6:<\/div>\n
\u00a0 \u00a0 1.RPM\u6587\u4ef6\u53ef\u7528\u4e8e\u57fa\u4e8eRPM\u7684Linux\u5206\u53d1,\u4f8b\u5982Oracle\u00a0Linux;\u901a\u8fc7\u4f7f\u7528rpm\u7a0b\u5e8f\u6216\u8005\u901a\u8fc7\u4f7f\u7528yum\u7b49\u8f6f\u4ef6\u5305\u7ba1\u7406\u5668\u6765\u5b89\u88c5\u8fd9\u4e9b\u6587\u4ef6,\u6bcf\u4e2aRPM\u7684\u5b89\u88c5\u5e03\u5c40\u7531RPM\u6587\u4ef6\u81ea\u8eab\u5185\u5305\u542b\u7684\u89c4\u8303\u6587\u4ef6\u63d0\u4f9b;(\u4f7f\u7528rpm\u00a0-qpl\u00a0<rpm_file>\u6765\u67e5\u770b\u5b89\u88c5\u65f6RPM\u6587\u4ef6\u5185\u5bb9\u7684\u4f4d\u7f6e)<\/div>\n
\u00a0 \u00a0 2.TAR\u6587\u4ef6\u53ef\u7528\u4e8e\u591a\u79cdLinux\u548cUNIX\u7c7b\u4f3c\u7cfb\u7edf,\u8981\u5b89\u88c5\u8fd9\u79cd\u7c7b\u578b\u7684\u5206\u53d1,\u4f7f\u7528.tar\u7a0b\u5e8f\u5728\u5b89\u88c5\u76ee\u5f55\u4e2d\u89e3\u538b\u7f29\u8be5\u5206\u53d1;<\/div>\n
2.\u7528\u4e8eWindows\u7684\u4e8c\u8fdb\u5236\u6587\u4ef6:<\/div>\n
\u00a0 \u00a0 1.\u5b8c\u6574\u5206\u53d1:\u5305\u542bMySQL\u5b89\u88c5\u7684\u6240\u6709\u6587\u4ef6\u4ee5\u53ca\u914d\u7f6e\u5411\u5bfc\u3002<\/div>\n
\u00a0 \u00a0 2.\u975e\u5b89\u88c5\u5206\u53d1:.zip\u5f52\u6863\u6587\u4ef6,\u4e0d\u4f7f\u7528\u5b89\u88c5\u6216\u914d\u7f6e\u5411\u5bfc,\u60a8\u53ea\u9700\u89e3\u538b\u7f29\u8be5\u5f52\u6863\u6587\u4ef6\u5e76\u5c06\u5176\u79fb\u81f3\u6240\u9700\u7684\u5b89\u88c5\u4f4d\u7f6e;<\/div>\n
TIPS:\u4e8c\u8fdb\u5236\u6587\u4ef6\u5206\u53d1\u8fd8\u53ef\u4ee5\u538b\u7f29\u6587\u4ef6\u5f62\u5f0f\u7528\u4e8e\u591a\u4e2a\u5176\u4ed6\u64cd\u4f5c\u7cfb\u7edf(\u5305\u62ecOracle\u00a0Solaris);<\/div>\n
<\/div>\n
—\u00a0MySQL\u6e90\u4ee3\u7801\u5206\u53d1;<\/div>\n
1.\u5982\u679c\u9700\u8981\u9884\u7f16\u8bd1\u5206\u53d1\u4e2d\u53ef\u80fd\u6ca1\u6709\u7684\u529f\u80fd(\u4f8b\u5982\u5b8c\u6574\u7684\u8c03\u8bd5\u652f\u6301),\u53ef\u4ee5\u6839\u636e\u6e90\u4ee3\u7801\u7f16\u8bd1MySQL;<\/div>\n
2.\u8981\u4f7f\u670d\u52a1\u5668\u5728\u8fd0\u884c\u65f6\u4f7f\u7528\u8f83\u5c11\u5185\u5b58,\u53ef\u80fd\u9700\u8981\u7981\u7528\u4e0d\u9700\u8981\u7684\u529f\u80fd;\u4f8b\u5982,\u53ef\u80fd\u9700\u8981\u7981\u7528\u53ef\u9009\u5b58\u50a8\u5f15\u64ce,\u6216\u8005\u4ec5\u7f16\u8bd1\u5b9e\u9645\u9700\u8981\u7684\u90a3\u4e9b\u5b57\u7b26\u96c6;<\/div>\n
3.\u4e8c\u8fdb\u5236\u6587\u4ef6\u5206\u53d1\u4ec5\u53ef\u7528\u4e8e\u5df2\u53d1\u884c\u7684\u7248\u672c,\u4e0d\u53ef\u7528\u4e8e\u6700\u65b0\u7684\u5f00\u53d1\u6e90\u4ee3\u7801;<\/div>\n
4.\u6e90\u4ee3\u7801\u5206\u53d1\u53ef\u4ee5\u5b89\u88c5\u5728\u4efb\u4f55\u6240\u9700\u4f4d\u7f6e;\u9ed8\u8ba4Linux\u5b89\u88c5\u4f4d\u7f6e\u4e3a\/usr\/local\/mysql;<\/div>\n
<\/div>\n
—\u00a0\u7528\u4e8eLinux\u7684MySQL\u00a0RPM\u5b89\u88c5\u6587\u4ef6;<\/div>\n
1.Oracle\u63d0\u4f9b\u4e24\u79cd\u7c7b\u578b\u7684MySQL\u00a0RPM:<\/div>\n
\u00a0 \u00a0 1.\u4e0e\u5206\u53d1\u65e0\u5173:MySQL\u63d0\u4f9b\u7ed9\u793e\u533a\u7684RPM,\u5b83\u4eec\u5e94\u8be5\u53ef\u4ee5\u5728\u652f\u6301RPM\u8f6f\u4ef6\u5305\u5e76\u4f7f\u7528glibc\u00a02.3(GNU\u00a0C\u5e93\u662f\u6807\u51c6C\u5e93\u7684GNU\u5b9e\u73b0)\u7684\u6240\u6709Linux\u7248\u672c\u4e0a\u8fd0\u884c;(\u67e5\u770b\u65b9\u5f0f:ldd\u00a0–version)<\/div>\n
\u00a0 \u00a0 2.\u7279\u5b9a\u4e8e\u5206\u53d1:\u9762\u5411\u76ee\u6807Linux\u5e73\u53f0,Oracle\u4e3a\u8bb8\u591a\u5e73\u53f0\u63d0\u4f9b\u4e86RPM\u6587\u4ef6;<\/div>\n
2.MySQL\u7684RPM\u5b89\u88c5\u901a\u5e38\u5206\u4e3a\u4e0d\u540c\u7684\u8f6f\u4ef6\u5305,\u5bf9\u4e8e\u6807\u51c6\u5b89\u88c5,\u5fc5\u987b\u81f3\u5c11\u5b89\u88c5\u670d\u52a1\u5668\u7a0b\u5e8f\u00a0\u548c\u5ba2\u6237\u673a\u7a0b\u5e8f,\u6807\u51c6\u5b89\u88c5\u4e0d\u9700\u8981\u5176\u4ed6\u8f6f\u4ef6\u5305;<\/div>\n
\u00a0 \u00a0 1.MySQL-client-advanced-<version>.rpm:\u5ba2\u6237\u7aef\u547d\u4ee4\u884c\u5de5\u5177;<\/div>\n
\u00a0 \u00a0 2.MySQL-devel-advanced-<version>.rpm:\u5305\u542b\u4e86\u7f16\u8bd1\u8f6f\u4ef6\u6240\u9700\u8981\u7684\u5934\u6587\u4ef6,\u9700\u8981\u4f7f\u7528\u5ba2\u6237\u7aef\u5171\u4eab\u5e93;<\/div>\n
\u00a0 \u00a0 3.MySQL-embedded-advanced-<version>.rpm:\u5d4c\u5165\u5f0f\u6570\u636e\u5e93,\u4e3a\u79fb\u52a8\u667a\u80fd\u8bbe\u5907\u4f7f\u7528;<\/div>\n
\u00a0 \u00a0 4.MySQL-server-advanced-<version>.rpm:\u670d\u52a1\u7aef(\u5305\u542bmysqld\u7684\u4e8c\u8fdb\u5236\u6587\u4ef6);<\/div>\n
\u00a0 \u00a0 5.MySQL-shared-advanced-<version>.rpm:\u5305\u542b\u5ba2\u6237\u7aef\u7684\u5171\u4eab\u5e93(libmysqlclient.so*);<\/div>\n
\u00a0 \u00a0 6.MySQL-shared-compat-advanced-<version>.rpm:\u5305\u542b\u4e86\u517c\u5bb9\u65e7\u7248\u672c\u7684\u5ba2\u6237\u7aef\u5171\u4eab\u5e93;<\/div>\n
\u00a0 \u00a0 7.MySQL-test-advanced-<version>.rpm:\u5305\u542b\u4e86\u6d4b\u8bd5\u5957\u4ef6;<\/div>\n
<\/div>\n
—\u00a0Linux\u00a0MySQL\u00a0RPM\u5b89\u88c5\u8fc7\u7a0b;<\/div>\n
1.\u89e3\u538b\u7f29\u5305:unizp\u00a0MySQL-5.6.25-oel6-x86_64.zip;<\/div>\n
2.\u521b\u5efa\u7528\u6237:useradd\u00a0mysql;<\/div>\n
3.\u5b89\u88c5RPM\u5305:rpm\u00a0-ivh\u00a0MySQL-*-advanced-5.6.25-1.el6.x86_64.rpm;\u5b89\u88c5\u5728\u8fd0\u884c\u65f6\u81ea\u52a8\u6267\u884c\u4ee5\u4e0b\u4efb\u52a1:<\/div>\n
\u00a0 \u00a0 1.\u5c06RPM\u6587\u4ef6\u63d0\u53d6\u5230\u5176\u9ed8\u8ba4\u4f4d\u7f6e;<\/div>\n
\u00a0 \u00a0 2.\u5728\/etc\/init.d\u76ee\u5f55\u4e2d\u6ce8\u518c\u540d\u4e3amysql\u7684\u542f\u52a8\u811a\u672c;<\/div>\n
\u00a0 \u00a0 3.\u6267\u884cmysql_install_db,\u5373\u521b\u5efa\u7cfb\u7edf\u6570\u636e\u5e93\u548c\u9ed8\u8ba4my.cnf\u6587\u4ef6\u7684\u811a\u672c,\u4e3aroot\u5e10\u6237\u8bbe\u7f6e\u968f\u673a\u53e3\u4ee4\u5e76\u5c06\u8be5\u53e3\u4ee4\u4fdd\u5b58\u5728\u5b89\u88c5\u7528\u6237\u4e3b\u76ee\u5f55\u4e2d\u540d\u4e3a.mysql_secret\u7684\u6587\u4ef6\u4e2d;<\/div>\n
\u00a0 \u00a0 4.\u4e3amysql\u8bbe\u7f6e\u767b\u5f55\u5e10\u6237\u4ee5\u53ca\u7528\u6237\u540d\u548c\u7ec4\u540d\u79f0(\u7528\u4e8e\u7ba1\u7406\u548c\u8fd0\u884c\u670d\u52a1\u5668);<\/div>\n
4.\u53d1\u751f\u4e0e\u81ea\u5e26\u7248\u672c\u51b2\u7a81\u7684\u8bdd:<\/div>\n
\u00a0 \u00a0 1.\u5220\u9664\u539f\u6765\u7684\u5305:yum\u00a0remove\u00a0mysql-libs-5.1.73-3.el6_5.x86_64;\u7f3a\u70b9\u662f\u4f1a\u5220\u9664\u76f8\u5173\u7684\u4f9d\u8d56\u6587\u4ef6,\u53ef\u80fd\u5176\u5b83\u7a0b\u5e8f\u4f1a\u7528;<\/div>\n
\u00a0 \u00a0 2.\u6dfb\u52a0–replacefiles\u9009\u9879:rpm\u00a0-ivh\u00a0–replacefiles\u00a0MySQL-*-advanced*;<\/div>\n
5.\u4ea7\u751f\u7684\u76ee\u5f55:<\/div>\n
\u00a0 \u00a0 1.\/usr\/bin:\u5ba2\u6237\u7aef\u7a0b\u5e8f\u548c\u811a\u672c;<\/div>\n
\u00a0 \u00a0 2.\/usr\/sbin:mysqld\u670d\u52a1\u7a0b\u5e8f;<\/div>\n
\u00a0 \u00a0 3.\/var\/lib\/mysql:\u6570\u636e\u5e93\u548c\u65e5\u5fd7\u6587\u4ef6,\u4e4b\u540e\u8bb2\u5230\u6570\u636e\u5e93\u7ed3\u6784\u4f1a\u8bb2\u6bcf\u4e2a\u6587\u4ef6\u7684\u4f5c\u7528;<\/div>\n
\u00a0 \u00a0 4.\/usr\/share\/info:info\u683c\u5f0f\u7684MySQL\u624b\u518c;<\/div>\n
\u00a0 \u00a0 5.\/usr\/share\/man:\u6807\u51c6\u7684Unix\u00a0man\u683c\u5f0f\u624b\u518c;<\/div>\n
\u00a0 \u00a0 6.\/usr\/include\/mysql:MySQL\u6240\u9700\u7684\u5934\u6587\u4ef6;<\/div>\n
\u00a0 \u00a0 7.\/usr\/lib64\/mysql:\u5e93\u6587\u4ef6;<\/div>\n
\u00a0 \u00a0 8.\/usr\/share\/mysql:\u5176\u5b83\u6742\u9879,\u5305\u62ec\u652f\u6301\u6587\u4ef6,\u9519\u8bef\u4fe1\u606f,\u5b57\u7b26\u96c6\u6587\u4ef6,\u793a\u4f8b\u914d\u7f6e\u6587\u4ef6\u548c\u6570\u636e\u5e93\u5b89\u88c5\u7684SQL\u6587\u4ef6\u7b49;<\/div>\n
\u00a0 \u00a0 9.\/usr\/share\/sql-bench:\u6d4b\u8bd5\u57fa\u7ebf;<\/div>\n
\u00a0 \u00a0 10.\/etc\/my.cnf,\u00a0\/usr\/my.cnf:\u7f3a\u7701\u914d\u7f6e\u6587\u4ef6;<\/div>\n
\u00a0 \u00a0 11.\/etc\/init.d\/:\u5305\u542b\u4e86mysql\u542f\u52a8\u811a\u672c;<\/div>\n
\u00a0 \u00a0 12.\/var\/log:mysqld.log\u6587\u4ef6;<\/div>\n
6.\u542f\u52a8\u6570\u636e\u5e93:service\u00a0mysql\u00a0start;<\/div>\n
\u00a0 \u00a0 1.\u67e5\u770b\u540e\u53f0\u8fdb\u7a0b:ps\u00a0-ef\u00a0|\u00a0grep\u00a0mysql;<\/div>\n
\u00a0 \u00a0 2.\u672c\u6765\u662f\u542f\u52a8\u7684mysqld\u670d\u52a1,\u540e\u53f0\u591a\u4e86\u4e00\u4e2amysqld_safe\u670d\u52a1,\u4e4b\u540e\u8bb2\u6570\u636e\u5e93\u542f\u52a8\u7684\u51e0\u79cd\u65b9\u5f0f\u4f1a\u63d0\u5230;<\/div>\n
7.\u5ba2\u6237\u7aef\u767b\u9646:mysql;<\/div>\n
\u00a0 \u00a0 1.\u4e4b\u524d\u7248\u672c\u90fd\u53ef\u4ee5\u4f7f\u7528\u7a7a\u5bc6\u7801\u767b\u5f55,\u73b0\u5728\u5374\u62a5\u9519;<\/div>\n
\u00a0 \u00a0 2.\u67e5\u770b\u5b89\u88c5\u8fc7\u7a0b,\u4f1a\u63d0\u793a\u5bc6\u7801\u968f\u673a\u4e86,\u4e4b\u540e\u9700\u8981\u4fee\u6539\u5bc6\u7801;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 A\u00a0RANDOM\u00a0PASSWORD\u00a0HAS\u00a0BEEN\u00a0SET\u00a0FOR\u00a0THE\u00a0MySQL\u00a0root\u00a0USER\u00a0!<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 You\u00a0will\u00a0find\u00a0that\u00a0password\u00a0in\u00a0‘\/root\/.mysql_secret’.<\/div>\n
<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 You\u00a0must\u00a0change\u00a0that\u00a0password\u00a0on\u00a0your\u00a0first\u00a0connect,<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 no\u00a0other\u00a0statement\u00a0but\u00a0‘SET\u00a0PASSWORD’\u00a0will\u00a0be\u00a0accepted.<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 See\u00a0the\u00a0manual\u00a0for\u00a0the\u00a0semantics\u00a0of\u00a0the\u00a0‘password\u00a0expired’\u00a0flag.<\/div>\n
<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 Also,\u00a0the\u00a0account\u00a0for\u00a0the\u00a0anonymous\u00a0user\u00a0has\u00a0been\u00a0removed.<\/div>\n
\u00a0 \u00a0 3.\u67e5\u770b\u5230\u5bc6\u7801\u540e\u518d\u767b\u5f55:mysql\u00a0-uroot\u00a0-p;<\/div>\n
\u00a0 \u00a0 4.\u5982\u4f55\u4f7f\u7528SET\u00a0PASSWORD:\u00a0help\u00a0SET\u00a0PASSWORD,\u53d1\u73b0\u62a5\u9519,\u5fc5\u987b\u5148\u4fee\u6539:SET\u00a0PASSWORD\u00a0=\u00a0PASSWORD(“mysql”);<\/div>\n
8.\u5378\u8f7d\u6570\u636e\u5e93:<\/div>\n
\u00a0 \u00a0 1.\u67e5\u770b\u5b89\u88c5\u4e86\u54ea\u4e9b\u8f6f\u4ef6:yum\u00a0list\u00a0|\u00a0grep\u00a0MySQL;<\/div>\n
\u00a0 \u00a0 2.\u5220\u9664\u8f6f\u4ef6:yum\u00a0remove\u00a0MySQL-*;<\/div>\n
<\/div>\n
—\u00a0Linux\u00a0MySQL\u670d\u52a1\u5668\u5b89\u88c5\u76ee\u5f55;<\/div>\n
—\u00a0\u5728Linux\u4e0a\u542f\u52a8MySQL\u670d\u52a1\u5668;<\/div>\n
1.\u53ef\u4ee5\u4f7f\u7528\u591a\u79cd\u65b9\u6cd5\u5728Linux\u4e0a\u542f\u52a8\u670d\u52a1\u5668:<\/div>\n
\u00a0 \u00a0 1.mysqld:\u624b\u52a8\u8c03\u7528\u670d\u52a1\u5668\u6765\u8c03\u8bd5MySQL\u670d\u52a1\u5668;\u9ed8\u8ba4\u60c5\u51b5\u4e0b,\u9519\u8bef\u6d88\u606f\u4f20\u81f3\u7ec8\u7aef,\u800c\u4e0d\u662f\u9519\u8bef\u65e5\u5fd7;<\/div>\n
\u00a0 \u00a0 2.mysqld_safe:\u8bbe\u7f6e\u9519\u8bef\u65e5\u5fd7,\u7136\u540e\u542f\u52a8mysqld\u5e76\u5bf9\u5176\u8fdb\u884c\u76d1\u89c6,\u5982\u679cmysqld\u5f02\u5e38\u7ec8\u6b62(kill\u00a0-9\u00a0pid),mysqld_safe\u4f1a\u5c06\u5176\u91cd\u65b0\u542f\u52a8;\u5982\u679c\u670d\u52a1\u5668\u672a\u6b63\u5e38\u542f\u52a8,\u8bf7\u67e5\u770b\u9519\u8bef\u65e5\u5fd7;<\/div>\n
\u00a0 \u00a0 2.mysql.server:\u7528\u4f5cmysqld_safe\u7684\u5305\u88c5,\u9488\u5bf9\u4f7f\u7528System\u00a0V\u8fd0\u884c\u7ea7\u522b\u76ee\u5f55\u7684Linux\u548cOracle\u00a0Solaris\u7b49\u7cfb\u7edf;<\/div>\n
\u00a0 \u00a0 4.mysqld_multi:\u8be5Perl\u811a\u672c\u7528\u4e8e\u7b80\u5316\u5355\u53f0\u4e3b\u673a\u4e0a\u7684\u591a\u4e2a\u670d\u52a1\u5668\u7ba1\u7406,\u5b83\u53ef\u4ee5\u542f\u52a8\u6216\u505c\u6b62\u670d\u52a1\u5668,\u5b83\u8fd8\u53ef\u4ee5\u62a5\u544a\u670d\u52a1\u5668\u662f\u5426\u6b63\u5728\u8fd0\u884c;<\/div>\n
\u00a0 \u00a0 5.\u5176\u5b83:mysqladmin\u00a0-uroot\u00a0-p\u00a0start;<\/div>\n
2.\u5b89\u88c5\u6b63\u786e\u7684\u811a\u672c\u4ee5\u4f7f\u670d\u52a1\u5668\u5728\u542f\u52a8\u65f6\u81ea\u52a8\u8fd0\u884c:<\/div>\n
\u00a0 \u00a0 1.\u5728BSD\u6837\u5f0f\u7684Linux\u7cfb\u7edf\u4e0a,\u6700\u5e38\u89c1\u7684\u662f\u901a\u8fc7\u67d0\u4e00\u4e2a\u7cfb\u7edf\u542f\u52a8\u811a\u672c(\u4f8b\u5982\/etc\u76ee<\/div>\n
\u00a0 \u00a0 \u5f55\u4e2d\u7684rc.local\u811a\u672c)\u8c03\u7528mysqld_safe;<\/div>\n
\u00a0 \u00a0 2.\u5728\/etc\/init.d\u4e0b\u5177\u6709\u8fd0\u884c\u7ea7\u522b\u76ee\u5f55\u7684Linux\u548cUNIX\u00a0System\u00a0V\u53d8\u4f53\u4f7f\u7528mysql.server\u811a\u672c,\u9884\u5148\u6784\u5efa\u7684\u00a0Linux\u4e8c\u8fdb\u5236\u8f6f\u4ef6\u5305\u9488\u5bf9\u76f8\u5e94\u7684\u8fd0\u884c\u7ea7\u522b\u5728\u540d\u79f0mysql\u5b89\u88c5mysql.server;\u4f7f\u7528chkconfig\u6ce8\u518c\u670d\u52a1;<\/div>\n
<\/div>\n
—\u00a0\u5728Linux\u4e0a\u505c\u6b62MySQL\u670d\u52a1\u5668;<\/div>\n
1.\u8981\u624b\u52a8\u505c\u6b62\u670d\u52a1\u5668,\u8bf7\u4f7f\u7528\u4ee5\u4e0b\u65b9\u6cd5\u4e4b\u4e00:<\/div>\n
\u00a0 \u00a0 1.mysqladmin:\u5177\u6709\u5173\u95ed\u547d\u4ee4,\u5b83\u4f5c\u4e3a\u5ba2\u6237\u673a\u8fde\u63a5\u5230\u670d\u52a1\u5668\u5e76\u4e14\u53ef\u4ee5\u5173\u95ed\u672c\u5730\u6216\u8fdc\u7a0b\u670d\u52a1\u5668;mysqladmin\u00a0-uroot\u00a0-p\u00a0shutdown;<\/div>\n
\u00a0 \u00a0 2.mysql.server:\u5728\u4f7f\u7528stop\u53c2\u6570\u8c03\u7528\u65f6\u505c\u6b62\u548c\/\u6216\u5173\u95ed\u672c\u5730\u670d\u52a1\u5668;<\/div>\n
\u00a0 \u00a0 3.mysqld_multi:\u505c\u6b62\u548c\/\u6216\u5173\u95ed\u5176\u7ba1\u7406\u7684\u4efb\u4f55\u670d\u52a1\u5668,\u5b83\u901a\u8fc7\u8c03\u7528mysqladmin\u6765\u6267\u884c\u6b64\u64cd\u4f5c;<\/div>\n
2.mysqld_safe\u6ca1\u6709\u670d\u52a1\u5668\u5173\u95ed\u529f\u80fd;<\/div>\n
<\/div>\n
—\u00a0\u63d0\u9ad8\u5b89\u88c5\u5b89\u5168\u6027;<\/div>\n
1.\u4eceRPM\u8f6f\u4ef6\u5305\u5b89\u88c5MySQL\u65f6,\u5c06\u4e3aroot\u5e10\u6237\u8bbe\u7f6e\u968f\u673a\u53e3\u4ee4\u5e76\u5c06\u8be5\u53e3\u4ee4\u4fdd\u5b58\u5230\u5b89\u88c5\u7528\u6237\u4e3b\u76ee\u5f55\u4e2d\u7684.mysql_secret\u6587\u4ef6;\u5bf9\u4e8e\u6240\u6709\u5176\u4ed6\u5b89\u88c5,\u521d\u59cb\u53e3\u4ee4\u4e3a\u7a7a\u767d;<\/div>\n
2.\u5728\u4e0d\u5e26\u53c2\u6570\u7684\u60c5\u51b5\u4e0b\u8c03\u7528mysql_secure_installation,\u8fd9\u5c06\u63d0\u793a\u60a8\u786e\u5b9a\u8981\u6267\u884c\u7684\u64cd\u4f5c;<\/div>\n
\u4f8b\u5b50:\u53ef\u4ee5\u8fd0\u884c\u4e00\u4e0b#\u00a0\/usr\/bin\/mysql_secure_installation,\u867d\u7136\u6b64\u5904\u663e\u793amysql_secure_installation\u00a0\u811a\u672c\u4ee5Linux\u00a0root\u7528\u6237\u8eab\u4efd\u8fd0\u884c,\u4f46\u60a8\u53ef\u4ee5\u666e\u901a\u7528\u6237\u8eab\u4efd\u8fd0\u884c\u8be5\u811a\u672c;<\/div>\n
<\/div>\n
—\u00a0Windows\u00a0MySQL\u670d\u52a1\u5668\u5b89\u88c5\u76ee\u5f55;<\/div>\n
1.\u9ed8\u8ba4\u60c5\u51b5\u4e0b,MySQL5.6\u5b89\u88c5\u5728\u76ee\u5f55\u8def\u5f84C:\\Program\u00a0Files\\MySQL\\MySQL\u00a05.6\u00a0Server\u4e2d;<\/div>\n
2.\\bin\u5305\u542bMySQL\u670d\u52a1\u5668\u548c\u5ba2\u6237\u673a\u7a0b\u5e8f:<\/div>\n
\u00a0 \u00a0 1.mysqld.exe:\u6807\u51c6\u670d\u52a1\u5668;<\/div>\n
\u00a0 \u00a0 2.\u5176\u4ed6\u5ba2\u6237\u673a\u7a0b\u5e8f,\u4f8b\u5982mysqladmin.exe;<\/div>\n
3.\\data\u662f\u670d\u52a1\u5668\u5b58\u50a8\u6570\u636e\u5e93\u548c\u65e5\u5fd7\u6587\u4ef6\u7684\u4f4d\u7f6e,\u6b64\u76ee\u5f55\u662f\u9884\u914d\u7f6e\u7684,\u53ef\u4ee5\u76f4\u63a5\u4f7f\u7528;\u4f8b\u5982,\u6b64\u76ee\u5f55\u5305\u62ecmysql\u5b50\u76ee\u5f55(\u5305\u542b\u6388\u6743\u8868)\u548c\u7528\u4e8etest\u6570\u636e\u5e93\u7684test\u5b50\u76ee\u5f55(\u53ef\u7528\u4e8e\u6d4b\u8bd5\u76ee\u7684);<\/div>\n
4.my.ini:\u914d\u7f6e\u9009\u9879\u6587\u4ef6\u6307\u5b9a\u5b89\u88c5\u76ee\u5f55\u7684\u4f4d\u7f6e\u4ee5\u53ca\u5176\u4ed6\u53ef\u9009\u8bbe\u7f6e;<\/div>\n
<\/div>\n
—\u00a0\u5728Windows\u4e0a\u8fd0\u884cMySQL;<\/div>\n
1.\u901a\u8fc7\u4f7f\u7528net\u00a0start\u00a0MySQL\u548cnet\u00a0stop\u00a0MySQL\u547d\u4ee4\u4ece\u547d\u4ee4\u884c\u624b\u52a8\u542f\u52a8\u548c\u505c\u6b62\u670d\u52a1;<\/div>\n
2.\u4f7f\u7528mysqld\u00a0–install\u547d\u4ee4\u4ece\u547d\u4ee4\u884c\u8c03\u7528\u670d\u52a1\u5668;\u5728\u505c\u6b62\u670d\u52a1\u540e\u5c06\u5176\u5220\u9664,\u4f7f\u7528mysqld\u00a0–remove;<\/div>\n
<\/div>\n
—\u00a0\u6570\u636e\u76ee\u5f55;<\/div>\n
1.\u6bcf\u4e2a\u8868\u90fd\u5177\u6709*.frm\u6587\u4ef6(\u5305\u62ec\u89c6\u56fe);<\/div>\n
2.MySQL\u670d\u52a1\u5668\u5f00\u59cb\u6267\u884c\u65f6\u4f1a\u5c06\u5176\u5f53\u524d\u5de5\u4f5c\u76ee\u5f55\u8f6c\u5230\u5176data\u76ee\u5f55,\u5fc5\u987b\u786e\u4fddMySQL\u670d\u52a1\u5668\u5177\u6709\u6b63\u786e\u7684\u8bbf\u95ee\u6743\u9650,\u4ee5\u4fbf\u5728data\u76ee\u5f55\u4e2d\u521b\u5efa\u6587\u4ef6,\u8be5\u670d\u52a1\u5668\u5fc5\u987b\u53ef\u4ee5\u8bbf\u95ee\u5b83\u8981\u5728\u5176\u4e2d\u521b\u5efa\u6570\u636e\u6587\u4ef6\u6216\u65e5\u5fd7\u6587\u4ef6\u7684\u6240\u6709\u76ee\u5f55;<\/div>\n
3.MySQL\u670d\u52a1\u5668\u5c06\u6bcf\u4e2a\u6570\u636e\u5e93\u6620\u5c04\u5230MySQL\u00a0data\u76ee\u5f55\u4e0b\u7684\u4e00\u4e2a\u76ee\u5f55,\u5e76\u4e14\u9ed8\u8ba4\u60c5\u51b5\u4e0b,\u5b83\u5c06\u6570\u636e\u5e93\u4e2d\u7684\u8868\u6620\u5c04\u5230\u6570\u636e\u5e93\u76ee\u5f55\u4e2d\u7684\u6587\u4ef6\u540d;\u8fd9\u5177\u6709\u4ee5\u4e0b\u542b\u4e49:<\/div>\n
\u00a0 \u00a0 1.\u6570\u636e\u5e93\u548c\u8868\u540d\u79f0\u4ec5\u5728\u5177\u6709\u533a\u5206\u5927\u5c0f\u5199\u7684\u6587\u4ef6\u540d\u7684\u64cd\u4f5c\u7cfb\u7edf(\u4f8b\u5982\u5927\u591a\u6570Linux\u7cfb\u7edf)\u4e0a\u7684MySQL\u670d\u52a1\u5668\u4e2d\u624d\u533a\u5206\u5927\u5c0f\u5199;<\/div>\n
\u00a0 \u00a0 2.\u53ef\u4ee5\u901a\u8fc7\u5c06\u6570\u636e\u76ee\u5f55,\u6570\u636e\u5e93\u548c\/\u6216\u5355\u4e2a\u8868(\u5177\u4f53\u53d6\u51b3\u4e8e\u5b58\u50a8\u5f15\u64ce\u9009\u9879)\u79fb\u81f3\u4e0d\u540c\u7684\u7269\u7406\u4f4d\u7f6e\u6765\u5206\u5272\u78c1\u76d8\u4f7f\u7528,\u8fd9\u53ef\u4ee5\u63d0\u9ad8\u6027\u80fd;<\/div>\n
<\/div>\n
—\u00a0MySQL\u670d\u52a1\u5668\u53d1\u884c\u7248;<\/div>\n
1.\u5347\u7ea7\u4e4b\u524d\u8fd8\u5e94\u8be5\u67e5\u770breadme\u6587\u6863:<\/div>\n
\u00a0 \u00a0 1.\u5728\u5173\u4e8e\u5347\u7ea7\u7684\u90e8\u5206\u4e2d,\u4e00\u5b9a\u8981\u9605\u8bfb\u4e0e\u6b63\u5728\u6267\u884c\u7684\u5347\u7ea7\u7c7b\u578b\u6709\u5173\u7684\u6ce8\u91ca,\u6309\u7167\u5efa\u8bae\u7684\u8fc7\u7a0b\u6267\u884c\u64cd\u4f5c;<\/div>\n
\u00a0 \u00a0 2.\u5728\u5173\u4e8e\u65b0\u7248\u672c\u7684\u66f4\u6539\u6ce8\u91ca\u90e8\u5206\u4e2d,\u67e5\u770b\u5728\u5f53\u524d\u7248\u672c\u4e0e\u8981\u5b89\u88c5\u7684\u7248\u672c\u4e4b\u95f4\u53d1\u751f\u7684\u6240\u6709\u66f4\u6539,\u8bf7\u6ce8\u610f\u4e0d\u4e0e\u5f53\u524d\u7248\u672c\u5411\u540e\u517c\u5bb9\u7684\u6240\u6709\u66f4\u6539;<\/div>\n
2.RPM\u548c\u6e90\u4ee3\u7801\u5347\u7ea7\u901a\u5e38\u4e0d\u9700\u8981\u8fdb\u884c\u91cd\u65b0\u914d\u7f6e,\u56e0\u4e3a\u5b83\u4eec\u5f80\u5f80\u4f7f\u7528\u76f8\u540c\u5b89\u88c5\u76ee\u5f55\u4f4d\u7f6e,\u800c\u4e0d\u8003\u8651MySQL\u7248\u672c;<\/div>\n
3.\u9700\u8981\u8fdb\u884c\u4e00\u4e9b\u91cd\u65b0\u914d\u7f6e\u7684\u60c5\u51b5:<\/div>\n
\u00a0 \u00a0 1.\u5982\u679c\u4f7f\u7528\u901a\u7528Linux\u4e8c\u8fdb\u5236\u6587\u4ef6\u8fdb\u884c\u5347\u7ea7,\u53ef\u4ee5\u9009\u62e9\u521b\u5efa\u7279\u5b9a\u4e8e\u65b0\u7248\u672c\u7684\u76ee\u5f55\u6765\u5305\u542b\u5347\u7ea7\u7684\u53d1\u884c\u7248;<\/div>\n
\u00a0 \u00a0 2.\u6b64\u5916,Windows\u5b89\u88c5\u7a0b\u5e8f\u5728Program\u00a0Files\u4e0b\u521b\u5efa\u7279\u5b9a\u4e8e\u7248\u672c\u7684\u6587\u4ef6\u5939;<\/div>\n
4.\u8bbe\u7f6e\u6307\u5411\u65e7\u5b89\u88c5\u76ee\u5f55\u7684\u8f6f\u94fe\u63a5,\u4ece\u800c\u53ef\u4ee5\u8f7b\u677e\u5220\u9664\u5e76\u91cd\u65b0\u521b\u5efa\u8be5\u94fe\u63a5\u6765\u6307\u5411\u65b0\u5b89\u88c5\u76ee\u5f55,\u5bf9\u8be5\u7b26\u53f7\u94fe\u63a5\u7684\u540e\u7eed\u5f15\u7528\u5c06\u8bbf\u95ee\u65b0\u5b89\u88c5;\u6bd4\u5982:\u628adata\u76ee\u5f55\u505a\u6210\u4e00\u4e2a\u8f6f\u94fe\u63a5;<\/div>\n
5.\u5982\u679c\u60a8\u7684\u5b89\u88c5\u6700\u521d\u662f\u901a\u8fc7\u5b89\u88c5\u591a\u4e2aRPM\u8f6f\u4ef6\u5305\u800c\u751f\u6210\u7684,\u5219\u6700\u597d\u5347\u7ea7\u6240\u6709\u8f6f\u4ef6\u5305,\u800c\u4e0d\u4ec5\u662f\u5176\u4e2d\u7684\u4e00\u4e9b;\u4f8b\u5982,\u5982\u679c\u5148\u524d\u5b89\u88c5\u4e86\u670d\u52a1\u5668\u548c\u5ba2\u6237\u673aRPM,\u5219\u4e0d\u8981\u4ec5\u5347\u7ea7\u670d\u52a1\u5668RPM;<\/div>\n
\u8865\u5145:<\/div>\n
1.\u5347\u7ea7MySQL\u603b\u4f53\u4e0a\u53ef\u4ee5\u7b80\u5355\u4f7f\u7528\u4ee5\u4e0b\u6b65\u9aa4\u8fdb\u884c\u64cd\u4f5c:<\/div>\n
\u00a0 \u00a0 1.\u5907\u4efd\u4f60\u7684\u6570\u636e\u5e93;<\/div>\n
\u00a0 \u00a0 2.\u5173\u95edServer;<\/div>\n
\u00a0 \u00a0 3.\u5728\u5df2\u5b58\u7248\u672c\u4e0a\u5b89\u88c5\u65b0\u7248\u672cMySQL;<\/div>\n
\u00a0 \u00a0 4.\u542f\u52a8Server;<\/div>\n
2.MySQL\u5f53\u524d\u63d0\u4f9b\u7684\u5347\u7ea7\u4e0d\u63d0\u4f9b\u8df3\u7ea7\u5347\u7ea7,\u56e0\u6b64,\u5982\u679c\u4f60\u5f53\u524d\u7684MySQL\u7248\u672c\u4e3a5.1,\u90a3\u4e48\u5347\u7ea7\u52305.7\u7684\u6d41\u7a0b\u4e3a:<\/div>\n
5.1->5.5->5.6->5.7;<\/div>\n
<\/div>\n
—\u00a0\u68c0\u67e5\u5347\u7ea7\u7684\u8868;<\/div>\n
1.\u5728\u6bcf\u6b21\u8fdb\u884cMySQL\u5347\u7ea7\u65f6,\u90fd\u9700\u8981\u8fd0\u884cmysql_upgrade\u7a0b\u5e8f,\u4e3b\u8981\u662f\u6267\u884c\u4e86\u4ee5\u4e0b\u64cd\u4f5c:<\/div>\n
\u00a0 \u00a0 1.\u68c0\u67e5\u6570\u636e\u5e93\u4e2d\u7684\u6240\u6709\u8868\u4e0eMySQL\u670d\u52a1\u5668\u5f53\u524d\u7248\u672c\u662f\u5426\u517c\u5bb9\u6027;<\/div>\n
\u00a0 \u00a0 2.\u4fee\u590d\u8868\u4e2d\u53d1\u73b0\u7684\u6240\u6709\u95ee\u9898\u4ee5\u53ca\u53ef\u80fd\u7684\u4e0d\u517c\u5bb9\u6027;<\/div>\n
\u00a0 \u00a0 3.\u5347\u7ea7\u7cfb\u7edf\u8868\u6765\u6dfb\u52a0\u65b0\u7248\u672c\u4e2d\u53ef\u7528\u7684\u6240\u6709\u65b0\u7279\u6743\u6216\u529f\u80fd;<\/div>\n
\u00a0 \u00a0 4.\u4f7f\u7528\u5f53\u524dMySQL\u7248\u672c\u53f7\u6807\u8bb0\u6240\u6709\u5df2\u68c0\u67e5\u548c\u5df2\u4fee\u590d\u7684\u8868;<\/div>\n
2.mysql_upgrade\u4f1a\u5c06MySQL\u7248\u672c\u53f7\u4fdd\u5b58\u5728\u6570\u636e\u76ee\u5f55\u4e0b\u7684\u4e00\u4e2amysql_upgrade_info\u7684\u6587\u4ef6\u4e2d,\u8fd9\u4e2a\u6587\u4ef6\u88ab\u7528\u4e8e\u5feb\u901f\u67e5\u770b\u662f\u5426\u6240\u6709\u8868\u9488\u5bf9\u5347\u7ea7\u7248\u672c\u5df2\u7ecf\u505a\u4e86\u68c0\u67e5,\u662f\u5426\u53ef\u4ee5\u8df3\u8fc7\u8868\u68c0\u67e5;\u5f53\u7136,\u8fd0\u884cmysql_upgrade\u65f6,\u4f60\u4e5f\u53ef\u4ee5\u4f7f\u7528–force\u9879\u6765\u8df3\u8fc7\u67e5\u770b\u6b64\u6587\u4ef6;<\/div>\n
3.\u5728MySQL\u00a05.7.5\u4e4b\u524d,\u4e3a\u4e86\u68c0\u67e5\u548c\u4fee\u6b63\u8868\u5e76\u8fdb\u884c\u7cfb\u7edf\u8868\u5347\u7ea7,mysql_upgrade\u4f1a\u8c03\u7528\u4ee5\u4e0b2\u6761\u547d\u4ee4:<\/div>\n
\u00a0 \u00a0 mysqlcheck\u00a0–check-upgrade\u00a0–all-databases\u00a0–auto-repair<\/div>\n
\u00a0 \u00a0 mysql_fix_privilege_tables<\/div>\n
\u00a0 \u4eceMySQL\u00a05.7.5\u4ee5\u540e,mysql_upgrade\u5c06\u76f4\u63a5\u548cMySQL\u00a0Server\u4ea4\u4e92,\u53d1\u9001\u6240\u9700\u7684SQL\u8bed\u53e5\u6765\u6267\u884c\u5347\u7ea7;<\/div>\n
<\/div>\n
\u8865\u5145:\u5347\u7ea7\u8fc7\u7a0b;<\/div>\n
1.\u505c\u6b62\u670d\u52a1:service\u00a0mysql\u00a0stop;<\/div>\n
2.\u5907\u4efd\u6587\u4ef6:<\/div>\n
\u00a0 \u00a0 1.\u521b\u5efa\u4e34\u65f6\u76ee\u5f55:mkdir\u00a0\/tmp\/mbackup;<\/div>\n
\u00a0 \u00a0 2.\u5907\u4efd\u914d\u7f6e\u6587\u4ef6:cp\u00a0\/etc\/my.cnf\u00a0\/tmp\/mbackup\/;<\/div>\n
\u00a0 \u00a0 3.\u5907\u4efd\u6570\u636e\u6587\u4ef6:cp\u00a0-rf\u00a0\/var\/lib\/mysql\/\u00a0\/tmp\/mbackup\/mysql;\u4e5f\u53ef\u4ee5\u7528mysqldump\/xtrabackup;<\/div>\n
3.\u5220\u9664\u8f6f\u4ef6:yum\u00a0-y\u00a0remove\u00a0MySQL-*-advanced-5.6.25-1.el6.x86_64;(\u4e0d\u63a8\u8350)<\/div>\n
4.\u5b89\u88c5\u8f6f\u4ef6:rpm\u00a0-ivh\u00a0–replacefiles\u00a0MySQL-server-advanced-5.6.26-1.el6.x86_64.rpm\u00a0MySQL-client-advanced-5.6.26-1.el6.x86_64.rpm;<\/div>\n
5.\u62f7\u8d1d\u56de\u914d\u7f6e\u6587\u4ef6:cp\u00a0\/tmp\/mbackup\/my.cnf\u00a0\/etc\/my.cnf;<\/div>\n
6.\u5c1d\u8bd5\u91cd\u542f:service\u00a0mysql\u00a0restart;<\/div>\n
7.\u6267\u884c\u66f4\u65b0:mysql_upgrade\u00a0-uroot\u00a0-p;<\/div>\n
8.\u67e5\u770b\u751f\u6210\u7684\u66f4\u65b0\u6587\u4ef6\u5e76\u4e14\u5c1d\u8bd5\u767b\u5f55\u67e5\u770b\u7248\u672c\u4fe1\u606f:less\u00a0$MYSQL_DATADIR\/mysql_upgrade_info;<\/div>\n
<\/div>\n
—\u00a0\u4f7f\u7528\u591a\u4e2a\u670d\u52a1\u5668;<\/div>\n
1.\u8981\u5728\u8fd0\u884c\u751f\u4ea7\u670d\u52a1\u5668\u7684\u540c\u4e00\u53f0\u8ba1\u7b97\u673a\u4e0a\u6d4b\u8bd5MySQL\u7684\u65b0\u53d1\u884c\u7248\u65f6,\u9700\u8981\u8fd0\u884c\u591a\u4e2a\u670d\u52a1\u5668;\u5047\u5b9a\u6bcf\u4e2a\u7ec4\u5177\u6709\u5176\u81ea\u5df1\u7684\u6307\u5b9aroot\u7528\u6237,\u8be5\u7528\u6237\u65e0\u6cd5\u67e5\u770b\u5c5e\u4e8e\u5176\u4ed6\u7ec4\u7684\u6570\u636e\u5e93,\u5982\u679c\u6240\u6709\u00a0\u5ba2\u6237\u673a\u5c06\u5171\u4eab\u540c\u4e00\u670d\u52a1\u5668\u5219\u53ef\u80fd\u4f1a\u8fd9\u6837;<\/div>\n
2.\u4e0d\u5141\u8bb8\u4efb\u4f55\u670d\u52a1\u5668\u5171\u4eab\u5fc5\u987b\u7531\u5355\u4e2a\u670d\u52a1\u5668\u72ec\u5360\u4f7f\u7528\u7684\u8d44\u6e90;<\/div>\n
3.mysqld_multi\u811a\u672c\u8bbe\u8ba1\u7528\u6765\u7ba1\u7406\u591a\u4e2amysqld\u8fdb\u7a0b,\u8fd9\u4e9b\u8fdb\u7a0b\u76d1\u542c\u4e0d\u540cUNIX\u5957\u63a5\u5b57\u6587\u4ef6\u548cTCP\/IP\u7aef\u53e3\u4e0a\u7684\u8fde\u63a5,\u8be5\u811a\u672c\u641c\u7d22my.cnf\u4e2d\u540d\u4e3a[mysqldN]\u7684\u7ec4,\u7136\u540e\u5c06\u8be5N\u7684\u8bbe\u7f6e\u5e94\u7528\u4e8e\u7f16\u53f7\u7684\u5b9e\u4f8b;<\/div>\n
\u00a0 \u00a0 \u4f8b\u5982,\u8981\u542f\u52a8\u4e24\u4e2amysqld\u5b9e\u4f8b,\u5b83\u4eec\u5206\u522b\u5e94\u7528\u6765\u81eamy.cnf\u90e8\u5206[mysqld3]\u548c[mysqld5]\u7684\u8bbe\u7f6e,\u8bf7\u8fd0\u884c\u4ee5\u4e0b\u547d\u4ee4:<\/div>\n
\u00a0 \u00a0 shell>\u00a0mysqld_multi\u00a0start\u00a03,\u00a05<\/div>\n
<\/div>\n
—\u00a0\u591a\u4e2a\u670d\u52a1\u5668\u9009\u9879;<\/div>\n
\u4f7f\u7528mysqld\u6216mysqld_multi\u4ee5\u53ca\u6bcf\u4e2a\u670d\u52a1\u5668\u51fd\u6570\u7684\u76f8\u5e94\u9009\u9879\u6765\u8c03\u7528\u6bcf\u4e2aMySQL\u670d\u52a1\u5668:<\/div>\n
\u00a0 \u00a0 1.\u6570\u636e\u76ee\u5f55:\u4f7f\u7528–datadir\u9009\u9879\u7684\u552f\u4e00\u503c\u542f\u52a8\u6bcf\u4e2a\u670d\u52a1\u5668;<\/div>\n
\u00a0 \u00a0 2.\u7f51\u7edc:\u901a\u8fc7\u4f7f\u7528–port,–socket\u548c–shared-memory-basename\u9009\u9879\u7684\u552f\u4e00\u503c\u542f\u52a8\u6bcf\u4e2a\u670d\u52a1\u5668,\u5c06\u6bcf\u4e2a\u670d\u52a1\u5668\u8bbe\u7f6e\u4e3a\u4f7f\u7528\u5176\u81ea\u5df1\u7684\u7f51\u7edc\u63a5\u53e3;<\/div>\n
\u00a0 \u00a0 3.\u7ec4\u540d\u79f0:\u4f7f\u7528mysqld_multi\u65f6,\u6bcf\u4e2a\u670d\u52a1\u5668\u7ec4\u5728Linux\u6216UNIX\u4e0a\u5fc5\u987b\u5177\u6709\u552f\u4e00\u7684mysqldN\u540d\u79f0;<\/div>\n
\u00a0 \u00a0 4.\u65e5\u5fd7\u6587\u4ef6:\u6bcf\u4e2a\u670d\u52a1\u5668\u5fc5\u987b\u5177\u6709\u5176\u81ea\u5df1\u7684\u65e5\u5fd7\u548cPID\u6587\u4ef6;<\/div>\n
\u00a0 \u00a0 5.InnoDB\u8868\u7a7a\u95f4\u548c\u65e5\u5fd7\u6587\u4ef6:\u4e0d\u80fd\u7531\u591a\u4e2a\u670d\u52a1\u5668\u5171\u4eab;<\/div>\n
\u00a0 \u00a0 6.Windows\u670d\u52a1\u540d\u79f0:\u6bcf\u4e2amysqld\u00a0Windows\u670d\u52a1\u5fc5\u987b\u4f7f\u7528\u552f\u4e00\u7684\u670d\u52a1\u540d\u79f0,\u901a\u8fc7\u4f7f\u7528–install\u8bbe\u7f6e\u670d\u52a1\u540d\u79f0;\u670d\u52a1\u5668\u542f\u52a8\u65f6,\u5b83\u4eec\u4ece\u6807\u51c6\u9009\u9879\u6587\u4ef6\u4e2d\u7684\u5404\u4e2a\u76f8\u5e94\u670d\u52a1\u7ec4\u4e2d\u8bfb\u53d6\u9009\u9879;<\/div>\n
<\/div>\n
—\u00a0\u7ec3\u4e60\u4efb\u52a1:<\/div>\n
1.\u521b\u5efa\u548c\u5bfc\u5165world_innodb\u6570\u636e\u5e93;<\/div>\n
\u00a0 \u00a0 $\u00a0mysql\u00a0-uroot\u00a0-p;<\/div>\n
\u00a0 \u00a0 mysql>\u00a0CREATE\u00a0DATABASE\u00a0world_innodb;<\/div>\n
\u00a0 \u00a0 mysql>\u00a0USE\u00a0world_innodb<\/div>\n
\u00a0 \u00a0 mysql>\u00a0SET\u00a0autocommit=0;<\/div>\n
\u00a0 \u00a0 mysql>\u00a0SOURCE\u00a0\/labs\/world_innodb.sql;<\/div>\n
\u00a0 \u00a0 mysql>\u00a0SET\u00a0autocommit=1;\u00a0\/\/\u00a0\u4e3a\u4e86\u63d0\u9ad8\u8fd0\u884c\u901f\u5ea6,\u6279\u91cf\u63d0\u4ea4;<\/div>\n
2.\u67e5\u770b\u672c\u5730MySQL\u670d\u52a1\u5668\u6570\u636e\u76ee\u5f55;<\/div>\n
\u00a0 \u00a0 mysql>\u00a0SHOW\u00a0VARIABLES\u00a0LIKE\u00a0‘datadir’\\G<\/div>\n
3.\u68c0\u67e5MySQL\u670d\u52a1\u5668\u7684\u72b6\u6001;<\/div>\n
\u00a0 \u00a0 service\u00a0mysql\u00a0status;<\/div>\n
4.\u5173\u95ed\/\u542f\u52a8MySQL\u670d\u52a1\u5668;<\/div>\n
\u00a0 \u00a0 service\u00a0mysql\u00a0stop\/start;<\/div>\n
<\/div>\n
<\/div>\n
—\u00a0\u8865\u5145:\u6e90\u7801\u5b89\u88c5MySQL<\/div>\n
1.\u51c6\u5907\u5b89\u88c5\u5de5\u5177:yum\u00a0-y\u00a0install\u00a0gcc*\u00a0make*\u00a0perl*;<\/div>\n
\u00a0 \u00a0 1.cmake:\u4eceMysql5.5\u4ee5\u540e\u4f7f\u7528cmake\u7f16\u8bd1,\u53ef\u4ee5\u4ecewww.cmake.org\u4e0b\u8f7d\u6700\u65b0\u7248\u672c;<\/div>\n
\u00a0 \u00a0 2.GUN\u00a0make:\u64cd\u4f5c\u7cfb\u7edf\u81ea\u5e26;<\/div>\n
\u00a0 \u00a0 3.gcc:\u64cd\u4f5c\u7cfb\u7edf\u81ea\u5e26;<\/div>\n
\u00a0 \u00a0 4.perl:\u64cd\u4f5c\u7cfb\u7edf\u81ea\u5e26;<\/div>\n
\u00a0 \u00a0 5.libncurses5-dev(ncurses-devel):\u8fd0\u884ccmake\u5fc5\u987b\u7684\u5305,\u5982\u679c\u6ca1\u6709\u5b89\u88c5\u4f1a\u62a5\u9519.<\/div>\n
2.\u5b89\u88c5cmake:<\/div>\n
\u00a0 \u00a0 1.\u89e3\u538b\u538b\u7f29\u5305:>tar\u00a0-zxvf\u00a0cmake-VERSION.tar.gz;<\/div>\n
\u00a0 \u00a0 2.\u8fdb\u5165\u5230cmake\u7684\u89e3\u538b\u7f29\u76ee\u5f55,\u6267\u884c.\/configure\u547d\u4ee4\u751f\u6210makefile;<\/div>\n
\u00a0 \u00a0 3.\u6267\u884c>make;make\u00a0install;\u547d\u4ee4\u751f\u6210\u5b89\u88c5\u8f6f\u4ef6\u5e76\u5b89\u88c5cmake;<\/div>\n
\u00a0 \u00a0 4.\u8f6f\u4ef6\u5b89\u88c5\u5230\u4e86\/usr\/local\/share\/cmake-VERSION\/\u76ee\u5f55\u4e0b,\u6267\u884c\u6587\u4ef6\u5728\/usr\/local\/bin\u76ee\u5f55\u4e0b;<\/div>\n
3.\u5b89\u88c5ncurses-devel\u63d2\u4ef6<\/div>\n
\u00a0 \u00a0 1.\u5728Debian\u548cUbuntu\u4e0a\u7684\u5305\u540d\u662flibncurses5-dev;<\/div>\n
\u00a0 \u00a0 2.\u5728RHEL\u548c\u5176\u5b83\u7248\u672c\u4e0a\u662fncurses-devel,\u6267\u884c:yum\u00a0install\u00a0-y\u00a0ncurses-devel*;<\/div>\n
\u00a0 \u00a0 3.\u5982\u679c\u4e0d\u5b89\u88c5\u4f1a\u51fa\u73b0\u4ee5\u4e0b\u9519\u8bef;<\/div>\n
4.\u521b\u5efamysql\u7528\u6237:>useradd\u00a0mysql;<\/div>\n
5.\u89e3\u538b\u7f29mysql5.5\u7684\u6e90\u7801\u5305:>tar\u00a0-zxvf\u00a0mysql-VERSION.tar.gz;<\/div>\n
6.\u8fdb\u5165\u76ee\u5f55mysql-VERSION\u76ee\u5f55;<\/div>\n
7.\u6267\u884ccmake\u547d\u4ee4\u751f\u6210makefile(MyISAM,MERGE,MEMBER\u548cCSV\u56db\u79cd\u5f15\u64ce\u9ed8\u8ba4\u9759\u6001\u7f16\u8bd1);<\/div>\n
\u00a0 \u00a0 cmake\u00a0-DCMAKE_INSTALL_PREFIX=\/usr\/local\/mysql\u00a0\\<\/div>\n
\u00a0 \u00a0 -DDEFAULT_CHARSET=utf8\u00a0\\<\/div>\n
\u00a0 \u00a0 -DDEFAULT_COLLATION=utf8_general_ci\u00a0\\<\/div>\n
\u00a0 \u00a0 -DWITH_EXTRA_CHARSETS:STRING=utf8,gbk\u00a0\\<\/div>\n
\u00a0 \u00a0 -DWITH_MYISAM_STORAGE_ENGINE=1\u00a0\\<\/div>\n
\u00a0 \u00a0 -DWITH_INNOBASE_STORAGE_ENGINE=1\u00a0\\<\/div>\n
\u00a0 \u00a0 -DWITH_FEDERATED_STORAGE_ENGINE=1\u00a0\\<\/div>\n
\u00a0 \u00a0 -DWITH_BLACKHOLE_STORAGE_ENGINE=1\u00a0\\<\/div>\n
\u00a0 \u00a0 -DWITH_ARCHIVE_STORAGE_ENGINE=1\u00a0\\<\/div>\n
\u00a0 \u00a0 -DWITH_READLINE=1\u00a0\\<\/div>\n
\u00a0 \u00a0 -DENABLED_LOCAL_INFILE=1\u00a0\\<\/div>\n
\u00a0 \u00a0 -DMYSQL_TCP_PORT=3306<\/div>\n
8.\u7f16\u8bd1\u6587\u4ef6:>make;make\u00a0install;\u5728mysql\u7684\u5b89\u88c5\u76ee\u5f55\u4e0b\u751f\u6210\u53ef\u6267\u884c\u6587\u4ef6,\u5e76\u81ea\u52a8\u521b\u5efa\u4e86data\u6587\u4ef6(\u53ef\u4ee5\u624b\u52a8\u518d\u521b\u5efa\u4e00\u4e2alogs\u76ee\u5f55,\u7528\u6765\u5b58\u653e\u751f\u6210\u7684\u65e5\u5fd7\u6587\u4ef6,\u4e0e\u6570\u636e\u76ee\u5f55\u4e0d\u5728\u540c\u4e00\u5757\u78c1\u76d8\u4e0a,\u51cf\u5c0fI\/O\u5e76\u53d1),\u4fee\u6539\u76ee\u5f55\u6743\u9650\u4e3amysql:>chown\u00a0mysql:mysql\u00a0data;<\/div>\n
9.\u7f16\u5199\/etc\/my.cnf;<\/div>\n
10.\u5728\u914d\u7f6e\u6587\u4ef6\u4e0b\u6dfb\u52a0\u76ee\u5f55\u914d\u7f6e,\u6307\u5b9a\u6570\u636e\u6587\u4ef6\u7684\u4f4d\u7f6e;<\/div>\n
\u00a0 \u00a0 bsedir\u00a0=\u00a0\/usr\/local\/mysql\/<\/div>\n
\u00a0 \u00a0 datadir\u00a0=\u00a0\/usr\/local\/mysql\/data<\/div>\n
11.\u6570\u636e\u5e93\u7684\u521d\u59cb\u5316,\u4e3b\u8981\u662f\u6570\u636e\u5e93\u7684\u521b\u5efa,\u5e2e\u52a9\u6587\u4ef6\u7684\u586b\u5145,\u7528\u6237\u6587\u4ef6\u7684\u586b\u5145,\u6267\u884c:>.\/scripts\/mysql_install_db\u00a0–defaults-file=.\/my.cnf\u00a0–user=mysql(\u5728my.cnf\u914d\u7f6e\u6587\u4ef6\u4e2d\u6dfb\u52a0user\u53c2\u6570,\u5e76\u4e14\u62f7\u8d1d\u5230\/etc\u76ee\u5f55\u4e0b\u5c31\u4e0d\u7528\u518d\u52a0\u53c2\u6570,\u6267\u884c>.\/scripts\/mysql_install_db\u5373\u53ef)<\/div>\n
12.\u542f\u52a8\u670d\u52a1\u5668:>.\/bin\/mysqld_safe\u00a0\u2013-user=mysql\u00a0&;<\/div>\n
13.\u4fee\u6539MYSQL\u670d\u52a1\u5668root\u7528\u6237\u7684\u5bc6\u7801:>.\/bin\/mysqladmin\u00a0\u2013u\u00a0root\u00a0password\u00a0‘pwd’;<\/div>\n
14.\u767b\u5f55:<\/div>\n
\u00a0 \u00a0 1.\u5982\u679c\u6ca1\u6709\u8bbe\u7f6eroot\u7684\u5bc6\u7801,\u9ed8\u8ba4\u662f\u7a7a\u5bc6\u7801,\u4f7f\u7528>.\/bin\/mysql\u5c31\u53ef\u4ee5\u767b\u5f55;<\/div>\n
\u00a0 \u00a0 2.\u5982\u679c\u8bbe\u7f6e\u4e86root\u5bc6\u7801,\u5219\u767b\u5f55\u65f6\u8981\u6570\u636e\u5bc6\u7801\u9a8c\u8bc1>.\/bin\/mysql\u00a0\u2013uroot\u00a0-p;<\/div>\n
\u00a0 \u00a0 3.\u8fdb\u5165\u6570\u636e\u5e93\u540e\u4fee\u6539\u7528\u6237\u5bc6\u7801:update\u00a0user\u00a0set\u00a0password=PASSWORD(‘123456′)\u00a0where\u00a0user=’root’;<\/div>\n
15.\u628amysql\u6dfb\u52a0\u5230\u73af\u5883\u53d8\u91cf:<\/div>\n
\u00a0 \u00a0 1.\u6253\u5f00~root\/.bash_profile\u6587\u4ef6;<\/div>\n
\u00a0 \u00a0 2.\u4fee\u6539\u73af\u5883\u53d8\u91cf:>PATH=\/usr\/local\/mysql\/bin:$PATH,\u5c3d\u91cf\u628amysql\u7684bin\u76ee\u5f55\u653e\u5728PATH\u7684\u524d\u9762,\u4f7f\u7528mysql\u7684\u5de5\u5177\u7684\u65f6\u5019\u63d0\u9ad8\u4f18\u5148\u7ea7,\u5426\u5219\u53ef\u80fd\u4f1a\u4f7f\u7528\u7cfb\u7edf\u9884\u88c5\u7684mysql\u7684\u5de5\u5177,\u9020\u6210\u7248\u672c\u4e0d\u4e00\u81f4\u7684\u9519\u8bef;<\/div>\n
\u00a0 \u00a0 3.\u4f7f\u73af\u5883\u53d8\u91cf\u7acb\u5373\u751f\u6548:>.\u00a0.\/.bash_profile;<\/div>\n
16.\u628a\u914d\u7f6e\u6587\u4ef6\u653e\u5230\u9ed8\u8ba4\u8bfb\u53d6\u7684\u8def\u5f84,\u5e76\u5728\u914d\u7f6e\u6587\u4ef6\u4e2d\u6307\u5b9a\u542f\u52a8\u7528\u6237\u4e3amysql,\u6dfb\u52a0\u5f00\u673a\u542f\u52a8:<\/div>\n
\u00a0 \u00a0 1.\u62f7\u8d1d\u6587\u4ef6\u5230\u5f00\u673a\u542f\u52a8\u76ee\u5f55:cp\u00a0\/usr\/local\/mysql\/support-files\/mysql.server\u00a0\/etc\/rc.d\/init.d\/mysqld;<\/div>\n
\u00a0 \u00a0 2.\u6dfb\u52a0\u5f00\u673a\u542f\u52a8\u9879\uff1achkconfig\u00a0–add\u00a0mysqld;chkconfig\u00a0mysqld\u00a0on;<\/div>\n
\u00a0 \u00a0 3.\u542f\u52a8\/\u5173\u95edmysql\u670d\u52a1:service\u00a0mysqld\u00a0start\/stop;<\/div>\n
<\/div>\n
<\/div>\n
—\u00a0\u914d\u7f6e\u6587\u4ef6my.cnf(RPM\u5b89\u88c5);<\/div>\n
#\u00a0————-mysql\u00a0client\u00a0profile——————-<\/div>\n
[client]<\/div>\n
port\u00a0=\u00a03306<\/div>\n
socket\u00a0=\u00a0\/var\/lib\/mysql\/mysqld.sock<\/div>\n
#\u00a0————-mysql\u00a0client\u00a0profile——————-<\/div>\n
<\/div>\n
#\u00a0————-mysql\u00a0general\u00a0profile——————<\/div>\n
[mysqld]<\/div>\n
user\u00a0=\u00a0mysql<\/div>\n
port\u00a0=\u00a03306<\/div>\n
socket\u00a0=\u00a0\/var\/lib\/mysql\/mysqld.sock<\/div>\n
pid-file\u00a0=\u00a0\/var\/lib\/mysql\/mysqld.pid<\/div>\n
skip-external-locking<\/div>\n
key_buffer_size\u00a0=\u00a064M<\/div>\n
max_allowed_packet\u00a0=\u00a016M<\/div>\n
table_open_cache\u00a0=\u00a0512<\/div>\n
sort_buffer_size\u00a0=\u00a01M<\/div>\n
read_buffer_size\u00a0=\u00a01M<\/div>\n
read_rnd_buffer_size\u00a0=\u00a04M<\/div>\n
myisam_sort_buffer_size\u00a0=\u00a08M<\/div>\n
thread_cache_size\u00a0=\u00a0128<\/div>\n
query_cache_size=\u00a08M<\/div>\n
binlog_cache_size\u00a0=\u00a04M<\/div>\n
tmp_table_size\u00a0=\u00a04M<\/div>\n
#\u00a0Try\u00a0number\u00a0of\u00a0CPU’s*2\u00a0for\u00a0thread_concurrency<\/div>\n
thread_concurrency\u00a0=\u00a02<\/div>\n
#\u00a0————-mysql\u00a0general\u00a0profile——————<\/div>\n
<\/div>\n
#\u00a0————-mysql\u00a0base\u00a0profile——————<\/div>\n
#\u00a0MYSQL\u00a0server\u00a0home\u00a0directory<\/div>\n
basedir\u00a0=\u00a0\/usr\/<\/div>\n
#\u00a0data\u00a0files\u00a0directory<\/div>\n
datadir\u00a0=\u00a0\/var\/lib\/mysql\/<\/div>\n
#\u00a0————-mysql\u00a0base\u00a0profile——————<\/div>\n
<\/div>\n
#\u00a0————-log\u00a0files\u00a0profile——————<\/div>\n
#\u00a0binary\u00a0log\u00a0files\u00a0directory<\/div>\n
log_bin\u00a0=\u00a0\/var\/lib\/mysql\/mysql-bin.log<\/div>\n
binlog_format\u00a0=\u00a0mixed<\/div>\n
log_bin_index\u00a0=\u00a0\/var\/lib\/mysql\/mysql-bin.index<\/div>\n
max_binlog_size\u00a0=\u00a0500M<\/div>\n
#\u00a0mysql’s\u00a0error\u00a0log\u00a0file\u00a0dir(same\u00a0as\u00a0Oracle’s\u00a0alter_SID.log\u00a0file)<\/div>\n
log_error\u00a0=\u00a0\/var\/lib\/mysql\/alert_mysql.log<\/div>\n
#\u00a0mysql’s\u00a0general\u00a0log\u00a0file(disabled\u00a0by\u00a0default)<\/div>\n
general_log_file\u00a0=\u00a0\/var\/lib\/mysql\/general_mysql.log<\/div>\n
#\u00a0mysql’s\u00a0slow\u00a0log\u00a0file(disabled\u00a0by\u00a0default)<\/div>\n
long_query_time\u00a0=\u00a01\u00a0#\u00a0second;<\/div>\n
slow_query_log_file\u00a0=\u00a0\/var\/lib\/mysql\/slow_query_mysql.log<\/div>\n
#\u00a0————-log\u00a0files\u00a0profile——————<\/div>\n
<\/div>\n
#\u00a0————-innodb\u00a0engine\u00a0profile——————<\/div>\n
#\u00a0InnoDB\u00a0engine\u00a0profile<\/div>\n
autocommit\u00a0=\u00a00<\/div>\n
innodb_file_per_table\u00a0=\u00a01<\/div>\n
innodb_log_group_home_dir\u00a0=\u00a0\/var\/lib\/mysql\/<\/div>\n
innodb_log_files_in_group\u00a0=\u00a04<\/div>\n
innodb_data_file_path\u00a0=\u00a0ibdata1:1000M:autoextend<\/div>\n
innodb_data_home_dir\u00a0=\u00a0\/var\/lib\/mysql\/data<\/div>\n
#\u00a0same\u00a0as\u00a0oracle’s\u00a0database\u00a0buffer\u00a0cache,\u00a0the\u00a0larger\u00a0the\u00a0better<\/div>\n
innodb_buffer_pool_size\u00a0=\u00a0128M<\/div>\n
#\u00a0same\u00a0as\u00a0oracle’s\u00a0redo\u00a0log\u00a0files<\/div>\n
innodb_log_file_size\u00a0=\u00a0100M<\/div>\n
#\u00a0same\u00a0as\u00a0oracle’s\u00a0redo\u00a0log\u00a0buffer\u00a0cache,\u00a0the\u00a0larger\u00a0the\u00a0better<\/div>\n
innodb_log_buffer_size\u00a0=\u00a04M<\/div>\n
#\u00a0turn\u00a0off\u00a0indexes\u00a0statistic\u00a0when\u00a0DDL\u00a0operater,default\u00a0ON,\u00a0it’s\u00a0deprecated<\/div>\n
#Innodb_buffer_pool_pages_free\u00a0=\u00a00<\/div>\n
#\u00a0————-innodb\u00a0engine\u00a0profile——————<\/div>\n
<\/div>\n
#\u00a0————-semi-sync\u00a0profile——————<\/div>\n
#\u00a0master\u00a0configure<\/div>\n
#server-id\u00a0 \u00a0 \u00a0 \u00a0=\u00a01<\/div>\n
#rpl_semi_sync_master_enabled=1<\/div>\n
#rpl_semi_sync_master_timeout=1000<\/div>\n
<\/div>\n
#\u00a0slave\u00a0configure<\/div>\n
#server-id\u00a0 \u00a0 \u00a0 \u00a0=\u00a02<\/div>\n
#rpl_semi_sync_slave_enabled=1<\/div>\n
#\u00a0————-semi-sync\u00a0profile——————<\/div>\n
<\/div>\n
#\u00a0————-identify\u00a0column——————<\/div>\n
#Master-Master\u00a0generate\u00a0odd\u00a0identifier<\/div>\n
#auto_increment_offset\u00a0=\u00a01<\/div>\n
#auto_increment_increment\u00a0=\u00a02<\/div>\n
<\/div>\n
#Master-Master\u00a0generate\u00a0even\u00a0identifier<\/div>\n
#auto_increment_offset\u00a0=\u00a02<\/div>\n
#auto_increment_increment\u00a0=\u00a02<\/div>\n
#\u00a0————-identify\u00a0column——————<\/div>\n
<\/div>\n
#\u00a0————-others\u00a0profile——————<\/div>\n
max_connections\u00a0=\u00a01000<\/div>\n
innodb_use_sys_malloc\u00a0=\u00a00<\/div>\n
log_slave_updates<\/div>\n
#\u00a0skip\u00a0ip\u00a0to\u00a0host\u00a0name\u00a0resolve<\/div>\n
skip_name_resolve<\/div>\n
#\u00a0enable\u00a0event\u00a0scheduler\u00a0process<\/div>\n
event_scheduler\u00a0=\u00a0on<\/div>\n
#\u00a0add\u00a0federated\u00a0engine\u00a0plugin<\/div>\n
federated<\/div>\n
#\u00a0open\u00a0Event\u00a0Scheduler\u00a0default<\/div>\n
event_scheduler\u00a0=\u00a0on<\/div>\n
#\u00a0create\u00a0functions<\/div>\n
#\u00a0log_bin_trust_function_creators\u00a0=\u00a0ON;<\/div>\n
#\u00a0————-others\u00a0profile——————<\/div>\n
<\/div>\n
[mysqldump]<\/div>\n
quick<\/div>\n
max_allowed_packet\u00a0=\u00a016M<\/div>\n
<\/div>\n
[mysql]<\/div>\n
no-auto-rehash<\/div>\n
#\u00a0Remove\u00a0the\u00a0next\u00a0comment\u00a0character\u00a0if\u00a0you\u00a0are\u00a0not\u00a0familiar\u00a0with\u00a0SQL<\/div>\n
#safe-updates<\/div>\n
<\/div>\n
[myisamchk]<\/div>\n
key_buffer_size\u00a0=\u00a08M<\/div>\n
sort_buffer_size\u00a0=\u00a08M<\/div>\n
read_buffer\u00a0=\u00a04M<\/div>\n
write_buffer\u00a0=\u00a04M<\/div>\n
<\/div>\n
[mysqlhotcopy]<\/div>\n
interactive-timeout<\/div>\n
<\/div>\n
<\/div>\n
—\u00a0\u914d\u7f6e\u6587\u4ef6my.cnf(\u7f16\u8bd1\u5b89\u88c5);<\/div>\n
#\u00a0————-mysql\u00a0client\u00a0profile——————-<\/div>\n
[client]<\/div>\n
port\u00a0=\u00a03306<\/div>\n
socket\u00a0=\u00a0\/usr\/local\/mysql\/log\/mysqld.sock<\/div>\n
#\u00a0————-mysql\u00a0client\u00a0profile——————-<\/div>\n
<\/div>\n
#\u00a0————-mysql\u00a0general\u00a0profile——————<\/div>\n
[mysqld]<\/div>\n
user\u00a0=\u00a0mysql<\/div>\n
port\u00a0=\u00a03306<\/div>\n
socket\u00a0=\u00a0\/usr\/local\/mysql\/log\/mysqld.sock<\/div>\n
pid-file\u00a0=\u00a0\/usr\/local\/mysql\/log\/mysqld.pid<\/div>\n
skip-external-locking<\/div>\n
key_buffer_size\u00a0=\u00a064M<\/div>\n
max_allowed_packet\u00a0=\u00a016M<\/div>\n
table_open_cache\u00a0=\u00a0512<\/div>\n
sort_buffer_size\u00a0=\u00a01M<\/div>\n
read_buffer_size\u00a0=\u00a01M<\/div>\n
read_rnd_buffer_size\u00a0=\u00a04M<\/div>\n
myisam_sort_buffer_size\u00a0=\u00a08M<\/div>\n
thread_cache_size\u00a0=\u00a0128<\/div>\n
query_cache_size=\u00a08M<\/div>\n
binlog_cache_size\u00a0=\u00a04M<\/div>\n
tmp_table_size\u00a0=\u00a04M<\/div>\n
#\u00a0Try\u00a0number\u00a0of\u00a0CPU’s*2\u00a0for\u00a0thread_concurrency<\/div>\n
thread_concurrency\u00a0=\u00a02<\/div>\n
#\u00a0————-mysql\u00a0general\u00a0profile——————<\/div>\n
<\/div>\n
#\u00a0————-mysql\u00a0base\u00a0profile——————<\/div>\n
#\u00a0MYSQL\u00a0server\u00a0home\u00a0directory<\/div>\n
basedir\u00a0=\u00a0\/usr\/local\/mysql\/<\/div>\n
#\u00a0data\u00a0files\u00a0directory<\/div>\n
datadir\u00a0=\u00a0\/usr\/local\/mysql\/data\/<\/div>\n
#\u00a0————-mysql\u00a0base\u00a0profile——————<\/div>\n
<\/div>\n
#\u00a0————-log\u00a0files\u00a0profile——————<\/div>\n
#\u00a0binary\u00a0log\u00a0files\u00a0directory<\/div>\n
log_bin\u00a0=\u00a0\/usr\/local\/mysql\/log\/mysql-bin.log<\/div>\n
binlog_format\u00a0=\u00a0mixed<\/div>\n
log_bin_index\u00a0=\u00a0\/usr\/local\/mysql\/log\/mysql-bin.index<\/div>\n
max_binlog_size\u00a0=\u00a0500M<\/div>\n
#\u00a0mysql’s\u00a0error\u00a0log\u00a0file\u00a0dir(same\u00a0as\u00a0Oracle’s\u00a0alter_SID.log\u00a0file)<\/div>\n
log_error\u00a0=\u00a0\/usr\/local\/mysql\/log\/alert_mysql.log<\/div>\n
#\u00a0mysql’s\u00a0general\u00a0log\u00a0file(disabled\u00a0by\u00a0default)<\/div>\n
general_log_file\u00a0=\u00a0\/usr\/local\/mysql\/log\/general_mysql.log<\/div>\n
#\u00a0mysql’s\u00a0slow\u00a0log\u00a0file(disabled\u00a0by\u00a0default)<\/div>\n
long_query_time\u00a0=\u00a01\u00a0#\u00a0second;<\/div>\n
slow_query_log_file\u00a0=\u00a0\/usr\/local\/mysql\/log\/slow_query_mysql.log<\/div>\n
#\u00a0————-log\u00a0files\u00a0profile——————<\/div>\n
<\/div>\n
#\u00a0————-innodb\u00a0engine\u00a0profile——————<\/div>\n
#\u00a0InnoDB\u00a0engine\u00a0profile<\/div>\n
autocommit\u00a0=\u00a00<\/div>\n
innodb_file_per_table\u00a0=\u00a01<\/div>\n
innodb_log_group_home_dir\u00a0=\u00a0\/usr\/local\/mysql\/log\/<\/div>\n
innodb_log_files_in_group\u00a0=\u00a04<\/div>\n
innodb_data_file_path\u00a0=\u00a0ibdata1:1000M:autoextend<\/div>\n
innodb_data_home_dir\u00a0=\u00a0\/usr\/local\/mysql\/data<\/div>\n
#\u00a0same\u00a0as\u00a0oracle’s\u00a0database\u00a0buffer\u00a0cache,\u00a0the\u00a0larger\u00a0the\u00a0better<\/div>\n
innodb_buffer_pool_size\u00a0=\u00a0128M<\/div>\n
#\u00a0same\u00a0as\u00a0oracle’s\u00a0redo\u00a0log\u00a0files<\/div>\n
innodb_log_file_size\u00a0=\u00a0100M<\/div>\n
#\u00a0same\u00a0as\u00a0oracle’s\u00a0redo\u00a0log\u00a0buffer\u00a0cache,\u00a0the\u00a0larger\u00a0the\u00a0better<\/div>\n
innodb_log_buffer_size\u00a0=\u00a04M<\/div>\n
#\u00a0turn\u00a0off\u00a0indexes\u00a0statistic\u00a0when\u00a0DDL\u00a0operater,default\u00a0ON,\u00a0it’s\u00a0deprecated<\/div>\n
#Innodb_buffer_pool_pages_free\u00a0=\u00a00<\/div>\n
#\u00a0————-innodb\u00a0engine\u00a0profile——————<\/div>\n
<\/div>\n
#\u00a0————-semi-sync\u00a0profile——————<\/div>\n
#\u00a0master\u00a0configure<\/div>\n
#server-id\u00a0 \u00a0 \u00a0 \u00a0=\u00a01<\/div>\n
#rpl_semi_sync_master_enabled=1<\/div>\n
#rpl_semi_sync_master_timeout=1000<\/div>\n
<\/div>\n
#\u00a0slave\u00a0configure<\/div>\n
#server-id\u00a0 \u00a0 \u00a0 \u00a0=\u00a02<\/div>\n
#rpl_semi_sync_slave_enabled=1<\/div>\n
#\u00a0————-semi-sync\u00a0profile——————<\/div>\n
<\/div>\n
#\u00a0————-identify\u00a0column——————<\/div>\n
#Master-Master\u00a0generate\u00a0odd\u00a0identifier<\/div>\n
#auto_increment_offset\u00a0=\u00a01<\/div>\n
#auto_increment_increment\u00a0=\u00a02<\/div>\n
<\/div>\n
#Master-Master\u00a0generate\u00a0even\u00a0identifier<\/div>\n
#auto_increment_offset\u00a0=\u00a02<\/div>\n
#auto_increment_increment\u00a0=\u00a02<\/div>\n
#\u00a0————-identify\u00a0column——————<\/div>\n
<\/div>\n
#\u00a0————-others\u00a0profile——————<\/div>\n
max_connections\u00a0=\u00a01000<\/div>\n
innodb_use_sys_malloc\u00a0=\u00a00<\/div>\n
log_slave_updates<\/div>\n
#\u00a0skip\u00a0ip\u00a0to\u00a0host\u00a0name\u00a0resolve<\/div>\n
skip_name_resolve<\/div>\n
#\u00a0enable\u00a0event\u00a0scheduler\u00a0process<\/div>\n
event_scheduler\u00a0=\u00a0on<\/div>\n
#\u00a0add\u00a0federated\u00a0engine\u00a0plugin<\/div>\n
federated<\/div>\n
#\u00a0open\u00a0Event\u00a0Scheduler\u00a0default<\/div>\n
event_scheduler\u00a0=\u00a0on<\/div>\n
#\u00a0create\u00a0functions<\/div>\n
#\u00a0log_bin_trust_function_creators\u00a0=\u00a0ON;<\/div>\n
#\u00a0————-others\u00a0profile——————<\/div>\n
<\/div>\n
[mysqldump]<\/div>\n
quick<\/div>\n
max_allowed_packet\u00a0=\u00a016M<\/div>\n
<\/div>\n
[mysql]<\/div>\n
no-auto-rehash<\/div>\n
#\u00a0Remove\u00a0the\u00a0next\u00a0comment\u00a0character\u00a0if\u00a0you\u00a0are\u00a0not\u00a0familiar\u00a0with\u00a0SQL<\/div>\n
#safe-updates<\/div>\n
<\/div>\n
[myisamchk]<\/div>\n
key_buffer_size\u00a0=\u00a08M<\/div>\n
sort_buffer_size\u00a0=\u00a08M<\/div>\n
read_buffer\u00a0=\u00a04M<\/div>\n
write_buffer\u00a0=\u00a04M<\/div>\n
<\/div>\n
[mysqlhotcopy]<\/div>\n
interactive-timeout<\/div>\n","protected":false},"excerpt":{"rendered":"

—\u00a0MySQL\u670d\u52a1\u5668\u5206\u53d1; 1.MySQL\u53ef\u7528\u4e8e\u591a\u4e2a\u64cd\u4f5c\u7cfb\u7edf,\u5305\u62ecLinux\/Windows\/Ma […]<\/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,31],"class_list":["post-1291","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-mysql","tag-mysql_ocp"],"_links":{"self":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1291","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=1291"}],"version-history":[{"count":1,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1291\/revisions"}],"predecessor-version":[{"id":1292,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1291\/revisions\/1292"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1291"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1291"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1291"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}