{"id":753,"date":"2017-12-05T18:55:00","date_gmt":"2017-12-05T10:55:00","guid":{"rendered":"https:\/\/damogame.cn:15443\/wordpress\/?p=753"},"modified":"2017-12-05T18:55:00","modified_gmt":"2017-12-05T10:55:00","slug":"%e5%9c%a8centos7%e7%b3%bb%e7%bb%9f%e4%b8%8a%e7%bc%96%e8%af%91%e5%ae%89%e8%a3%85mysql-5-7-13%e6%ad%a5%e9%aa%a4%e8%af%a6%e8%a7%a3","status":"publish","type":"post","link":"https:\/\/i007.cc\/wordpress\/archives\/753","title":{"rendered":"\u5728CentOS7\u7cfb\u7edf\u4e0a\u7f16\u8bd1\u5b89\u88c5MySQL 5.7.13\u6b65\u9aa4\u8be6\u89e3"},"content":{"rendered":"<div class=\"title\">\n<p>\u4f5c\u8005\uff1a\u6280\u672f\u5b66\u4e60 \u5b57\u4f53\uff1a[<a>\u589e\u52a0<\/a>\u00a0<a>\u51cf\u5c0f<\/a>] \u7c7b\u578b\uff1a\u8f6c\u8f7d \u65f6\u95f4\uff1a2017-01-23<a href=\"http:\/\/www.jb51.net\/article\/104016.htm#comments\">\u00a0\u6211\u8981\u8bc4\u8bba<\/a><\/p>\n<\/div>\n<div class=\"art_desc mt10\">\n<div id=\"art_demo\">\u672c\u7bc7\u6587\u7ae0\u4e3b\u8981\u4ecb\u7ecd\u4e86\u5728CentOS7\u7cfb\u7edf\u4e0a\u7f16\u8bd1\u5b89\u88c5MySQL 5.7.13\u6b65\u9aa4\u8be6\u89e3\uff0c\u5177\u6709\u4e00\u5b9a\u7684\u53c2\u8003\u4ef7\u503c\uff0c\u6709\u5174\u8da3\u7684\u53ef\u4ee5\u4e86\u89e3\u4e00\u4e0b\u3002<\/div>\n<\/div>\n<div class=\"lbd clearfix\">\n<div><iframe loading=\"lazy\" src=\"http:\/\/pos.baidu.com\/s?hei=100&amp;wid=680&amp;di=u2866688&amp;ltu=http%3A%2F%2Fwww.jb51.net%2Farticle%2F104016.htm&amp;ant=0&amp;ps=954x370&amp;dc=2&amp;dis=0&amp;dai=1&amp;ccd=24&amp;par=1920x1028&amp;cdo=-1&amp;pcs=1731x852&amp;cmi=5&amp;cpl=4&amp;tcn=1512471160&amp;ltr=https%3A%2F%2Fwww.baidu.com%2Flink%3Furl%3DZaGBkTKgamEaCaGM3V-2Nq6QADTwhE3fz8zjlDdEz_Y02ZT0nI7p7xxcmNKQeJ1Q%26wd%3D%26eqid%3D9098a1a900037dde000000045a267958&amp;tlm=1512471159&amp;pis=-1x-1&amp;cce=true&amp;chi=1&amp;tpr=1512471159625&amp;col=zh-CN&amp;cja=false&amp;ti=%E5%9C%A8CentOS7%E7%B3%BB%E7%BB%9F%E4%B8%8A%E7%BC%96%E8%AF%91%E5%AE%89%E8%A3%85MySQL%205.7.13%E6%AD%A5%E9%AA%A4%E8%AF%A6%E8%A7%A3_Linux_%E8%84%9A%E6%9C%AC%E4%B9%8B%E5%AE%B6&amp;ari=2&amp;pss=1731x7270&amp;exps=111000&amp;cec=GBK&amp;dri=0&amp;cfv=0&amp;dtm=HTML_POST&amp;drs=1&amp;psr=1920x1080\" width=\"680\" height=\"100\" frameborder=\"0\" scrolling=\"no\" data-mce-fragment=\"1\"><\/iframe><\/div>\n<\/div>\n<div id=\"content\">\n<p>MySQL 5.7\u4e3b\u8981\u7279\u6027<\/p>\n<p>1\u3001\u66f4\u597d\u7684\u6027\u80fd<\/p>\n<p>\u5bf9\u4e8e\u591a\u6838CPU\u3001\u56fa\u6001\u786c\u76d8\u3001\u9501\u6709\u7740\u66f4\u597d\u7684\u4f18\u5316\uff0c\u6bcf\u79d2100W QPS\u5df2\u4e0d\u518d\u662fMySQL\u7684\u8ffd\u6c42\uff0c\u4e0b\u4e2a\u7248\u672c\u80fd\u5426\u4e0a200W QPS\u624d\u662f\u7528\u6237\u66f4\u5173\u5fc3\u7684\u3002<\/p>\n<p>2\u3001\u66f4\u597d\u7684InnoDB\u5b58\u50a8\u5f15\u64ce<\/p>\n<p>3\u3001\u66f4\u4e3a\u5065\u58ee\u7684\u590d\u5236\u529f\u80fd<\/p>\n<p>\u590d\u5236\u5e26\u6765\u4e86\u6570\u636e\u5b8c\u5168\u4e0d\u4e22\u5931\u7684\u65b9\u6848\uff0c\u4f20\u7edf\u91d1\u878d\u5ba2\u6237\u4e5f\u53ef\u4ee5\u9009\u62e9\u4f7f\u7528\u3002\u6b64\u5916\uff0cGTID\u5728\u7ebf\u5e73\u6ed1\u5347\u7ea7\u4e5f\u53d8\u5f97\u53ef\u80fd\u3002<\/p>\n<p>4\u3001\u66f4\u597d\u7684\u4f18\u5316\u5668<\/p>\n<p>\u4f18\u5316\u5668\u4ee3\u7801\u91cd\u6784\u7684\u610f\u4e49\u5c06\u5728\u8fd9\u4e2a\u7248\u672c\u53ca\u4ee5\u540e\u7684\u7248\u672c\u4e2d\u5e26\u6765\u5de8\u5927\u7684\u6539\u8fdb\uff0cOracle\u5b98\u65b9\u6b63\u5728\u89e3\u51b3MySQL\u4e4b\u524d\u6700\u5927\u7684\u96be\u9898\u3002<\/p>\n<p>5\u3001\u539f\u751fJSON\u7c7b\u578b\u7684\u652f\u6301<\/p>\n<p>6\u3001\u66f4\u597d\u7684\u5730\u7406\u4fe1\u606f\u670d\u52a1\u652f\u6301<\/p>\n<p>InnoDB\u539f\u751f\u652f\u6301\u5730\u7406\u4f4d\u7f6e\u7c7b\u578b\uff0c\u652f\u6301GeoJSON\uff0cGeoHash\u7279\u6027<br \/>\n7\u3001\u65b0\u589esys\u5e93<\/p>\n<p>\u4ee5\u540e\u8fd9\u4f1a\u662fDBA\u8bbf\u95ee\u6700\u9891\u7e41\u7684\u5e93MySQL 5.7\u5df2\u7ecf\u4f5c\u4e3a\u6570\u636e\u5e93\u53ef\u9009\u9879\u6dfb\u52a0\u5230\u300aOneinStack\u300b<\/p>\n<p><strong>\u5b89\u88c5\u51c6\u5907<\/strong><\/p>\n<p><strong>\u5b89\u88c5\u4f9d\u8d56\u5305<\/strong><\/p>\n<div class=\"jb51code\">\n<div>\n<div id=\"highlighter_465376\" class=\"syntaxhighlighter  bash\">\n<div class=\"toolbar\"><a class=\"toolbar_item command_help help\" href=\"http:\/\/www.jb51.net\/article\/104016.htm#\">?<\/a><\/div>\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"bash plain\">[root@snails ~]<\/code><code class=\"bash comments\"># yum -y install gcc gcc-c++ ncurses ncurses-devel cmake bison<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<p>\u4e0b\u8f7d\u76f8\u5e94\u6e90\u7801\u5305<\/p>\n<div class=\"jb51code\">\n<div>\n<div id=\"highlighter_36106\" class=\"syntaxhighlighter  bash\">\n<div class=\"toolbar\"><a class=\"toolbar_item command_help help\" href=\"http:\/\/www.jb51.net\/article\/104016.htm#\">?<\/a><\/div>\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<div class=\"line number2 index1 alt1\">2<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"bash plain\">[root@snails ~]<\/code><code class=\"bash comments\"># wget <a href=\"https:\/\/sourceforge.net\/projects\/boost\/files\/boost\/1.59.0\/boost_1_59_0.tar.gz\">https:\/\/sourceforge.net\/projects\/boost\/files\/boost\/1.59.0\/boost_1_59_0.tar.gz<\/a><\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"bash plain\">[root@snails ~]<\/code><code class=\"bash comments\"># wget <a href=\"http:\/\/cdn.mysql.com\/Downloads\/MySQL-5.7\/mysql-5.7.13.tar.gz\">http:\/\/cdn.mysql.com\/Downloads\/MySQL-5.7\/mysql-5.7.13.tar.gz<\/a><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<p><strong>\u65b0\u5efaMySQL\u7528\u6237\u548c\u7528\u6237\u7ec4<\/strong><\/p>\n<div class=\"jb51code\">\n<div>\n<div id=\"highlighter_115851\" class=\"syntaxhighlighter  bash\">\n<div class=\"toolbar\"><a class=\"toolbar_item command_help help\" href=\"http:\/\/www.jb51.net\/article\/104016.htm#\">?<\/a><\/div>\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"bash plain\">[root@snails ~]<\/code><code class=\"bash comments\"># groupadd -r mysql &amp;&amp; useradd -r -g mysql -s \/sbin\/nologin -M mysql<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<p><strong>\u9884\u7f16\u8bd1<\/strong><\/p>\n<div class=\"jb51code\">\n<div>\n<div id=\"highlighter_418170\" class=\"syntaxhighlighter  bash\">\n<div class=\"toolbar\"><a class=\"toolbar_item command_help help\" href=\"http:\/\/www.jb51.net\/article\/104016.htm#\">?<\/a><\/div>\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<div class=\"line number2 index1 alt1\">2<\/div>\n<div class=\"line number3 index2 alt2\">3<\/div>\n<div class=\"line number4 index3 alt1\">4<\/div>\n<div class=\"line number5 index4 alt2\">5<\/div>\n<div class=\"line number6 index5 alt1\">6<\/div>\n<div class=\"line number7 index6 alt2\">7<\/div>\n<div class=\"line number8 index7 alt1\">8<\/div>\n<div class=\"line number9 index8 alt2\">9<\/div>\n<div class=\"line number10 index9 alt1\">10<\/div>\n<div class=\"line number11 index10 alt2\">11<\/div>\n<div class=\"line number12 index11 alt1\">12<\/div>\n<div class=\"line number13 index12 alt2\">13<\/div>\n<div class=\"line number14 index13 alt1\">14<\/div>\n<div class=\"line number15 index14 alt2\">15<\/div>\n<div class=\"line number16 index15 alt1\">16<\/div>\n<div class=\"line number17 index16 alt2\">17<\/div>\n<div class=\"line number18 index17 alt1\">18<\/div>\n<div class=\"line number19 index18 alt2\">19<\/div>\n<div class=\"line number20 index19 alt1\">20<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"bash plain\">[root@snails ~]<\/code><code class=\"bash comments\"># tar -zxvf boost_1_59_0.tar.gz<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"bash plain\">[root@snails data]<\/code><code class=\"bash comments\"># md5sum mysql-5.7.13.tar.gz <\/code><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"bash plain\">8fab75dbcafcd1374d07796bff88ae00 mysql-5.7.13.<\/code><code class=\"bash functions\">tar<\/code><code class=\"bash plain\">.gz<\/code><\/div>\n<div class=\"line number4 index3 alt1\"><code class=\"bash plain\">[root@snails ~]<\/code><code class=\"bash comments\"># tar -zxvf mysql-5.7.13.tar.gz<\/code><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"bash plain\">[root@snails data]<\/code><code class=\"bash comments\"># mkdir -p \/data\/mysql<\/code><\/div>\n<div class=\"line number6 index5 alt1\"><code class=\"bash plain\">[root@snails data]<\/code><code class=\"bash comments\"># cd mysql-5.7.13<\/code><\/div>\n<div class=\"line number7 index6 alt2\"><code class=\"bash plain\">[root@snails data]<\/code><code class=\"bash comments\"># cmake . -DCMAKE_INSTALL_PREFIX=\/usr\/local\/mysql \\<\/code><\/div>\n<div class=\"line number8 index7 alt1\"><code class=\"bash plain\">-DMYSQL_DATADIR=<\/code><code class=\"bash plain\">\/data\/mysql<\/code> <code class=\"bash plain\">\\<\/code><\/div>\n<div class=\"line number9 index8 alt2\"><code class=\"bash plain\">-DWITH_BOOST=..<\/code><code class=\"bash plain\">\/boost_1_59_0<\/code> <code class=\"bash plain\">\\<\/code><\/div>\n<div class=\"line number10 index9 alt1\"><code class=\"bash plain\">-DSYSCONFDIR=<\/code><code class=\"bash plain\">\/etc<\/code> <code class=\"bash plain\">\\<\/code><\/div>\n<div class=\"line number11 index10 alt2\"><code class=\"bash plain\">-DWITH_INNOBASE_STORAGE_ENGINE=1 \\<\/code><\/div>\n<div class=\"line number12 index11 alt1\"><code class=\"bash plain\">-DWITH_PARTITION_STORAGE_ENGINE=1 \\<\/code><\/div>\n<div class=\"line number13 index12 alt2\"><code class=\"bash plain\">-DWITH_FEDERATED_STORAGE_ENGINE=1 \\<\/code><\/div>\n<div class=\"line number14 index13 alt1\"><code class=\"bash plain\">-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \\<\/code><\/div>\n<div class=\"line number15 index14 alt2\"><code class=\"bash plain\">-DWITH_MYISAM_STORAGE_ENGINE=1 \\<\/code><\/div>\n<div class=\"line number16 index15 alt1\"><code class=\"bash plain\">-DENABLED_LOCAL_INFILE=1 \\<\/code><\/div>\n<div class=\"line number17 index16 alt2\"><code class=\"bash plain\">-DENABLE_DTRACE=0 \\<\/code><\/div>\n<div class=\"line number18 index17 alt1\"><code class=\"bash plain\">-DDEFAULT_CHARSET=utf8mb4 \\<\/code><\/div>\n<div class=\"line number19 index18 alt2\"><code class=\"bash plain\">-DDEFAULT_COLLATION=utf8mb4_general_ci \\<\/code><\/div>\n<div class=\"line number20 index19 alt1\"><code class=\"bash plain\">-DWITH_EMBEDDED_SERVER=1<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<p><strong>\u7f16\u8bd1\u5b89\u88c5<\/strong><\/p>\n<div class=\"jb51code\">\n<div>\n<div id=\"highlighter_823923\" class=\"syntaxhighlighter  bash\">\n<div class=\"toolbar\"><a class=\"toolbar_item command_help help\" href=\"http:\/\/www.jb51.net\/article\/104016.htm#\">?<\/a><\/div>\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<div class=\"line number2 index1 alt1\">2<\/div>\n<div class=\"line number3 index2 alt2\">3<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"bash plain\">[root@snails mysql-5.7.13]<\/code><code class=\"bash comments\"># make -j `grep processor \/proc\/cpuinfo | wc -l`<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"bash comments\">#\u7f16\u8bd1\u5f88\u6d88\u8017\u7cfb\u7edf\u8d44\u6e90\uff0c\u5c0f\u5185\u5b58\u53ef\u80fd\u7f16\u8bd1\u901a\u4e0d\u8fc7make install<\/code><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"bash plain\">[root@snails mysql-5.7.13]<\/code><code class=\"bash comments\"># make install<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<p><strong>\u8bbe\u7f6e\u542f\u52a8\u811a\u672c\uff0c\u5f00\u673a\u81ea\u542f\u52a8<\/strong><\/p>\n<div class=\"jb51code\">\n<div>\n<div id=\"highlighter_837478\" class=\"syntaxhighlighter  bash\">\n<div class=\"toolbar\"><a class=\"toolbar_item command_help help\" href=\"http:\/\/www.jb51.net\/article\/104016.htm#\">?<\/a><\/div>\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<div class=\"line number2 index1 alt1\">2<\/div>\n<div class=\"line number3 index2 alt2\">3<\/div>\n<div class=\"line number4 index3 alt1\">4<\/div>\n<div class=\"line number5 index4 alt2\">5<\/div>\n<div class=\"line number6 index5 alt1\">6<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"bash plain\">[root@snails mysql-5.7.13]<\/code><code class=\"bash comments\"># ls -lrt \/usr\/local\/mysql<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"bash plain\">[root@snails mysql-5.7.13]<\/code><code class=\"bash comments\"># cp \/usr\/local\/mysql\/support-files\/mysql.server \/etc\/init.d\/mysqld<\/code><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"bash plain\">[root@snails mysql-5.7.13]<\/code><code class=\"bash comments\"># chmod +x \/etc\/init.d\/mysqld<\/code><\/div>\n<div class=\"line number4 index3 alt1\"><code class=\"bash plain\">[root@snails mysql-5.7.13]<\/code><code class=\"bash comments\"># systemctl enable mysqld<\/code><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"bash plain\">mysqld.service is not a native service, redirecting to <\/code><code class=\"bash plain\">\/sbin\/chkconfig<\/code><code class=\"bash plain\">.<\/code><\/div>\n<div class=\"line number6 index5 alt1\"><code class=\"bash plain\">Executing <\/code><code class=\"bash plain\">\/sbin\/chkconfig<\/code> <code class=\"bash plain\">mysqld on<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<p><strong>\u914d\u7f6e\u6587\u4ef6<\/strong><\/p>\n<p>\/etc\/my.cnf\uff0c\u4ec5\u4f9b\u53c2\u8003<\/p>\n<div class=\"jb51code\">\n<div>\n<div id=\"highlighter_226587\" class=\"syntaxhighlighter  bash\">\n<div class=\"toolbar\"><a class=\"toolbar_item command_help help\" href=\"http:\/\/www.jb51.net\/article\/104016.htm#\">?<\/a><\/div>\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<div class=\"line number2 index1 alt1\">2<\/div>\n<div class=\"line number3 index2 alt2\">3<\/div>\n<div class=\"line number4 index3 alt1\">4<\/div>\n<div class=\"line number5 index4 alt2\">5<\/div>\n<div class=\"line number6 index5 alt1\">6<\/div>\n<div class=\"line number7 index6 alt2\">7<\/div>\n<div class=\"line number8 index7 alt1\">8<\/div>\n<div class=\"line number9 index8 alt2\">9<\/div>\n<div class=\"line number10 index9 alt1\">10<\/div>\n<div class=\"line number11 index10 alt2\">11<\/div>\n<div class=\"line number12 index11 alt1\">12<\/div>\n<div class=\"line number13 index12 alt2\">13<\/div>\n<div class=\"line number14 index13 alt1\">14<\/div>\n<div class=\"line number15 index14 alt2\">15<\/div>\n<div class=\"line number16 index15 alt1\">16<\/div>\n<div class=\"line number17 index16 alt2\">17<\/div>\n<div class=\"line number18 index17 alt1\">18<\/div>\n<div class=\"line number19 index18 alt2\">19<\/div>\n<div class=\"line number20 index19 alt1\">20<\/div>\n<div class=\"line number21 index20 alt2\">21<\/div>\n<div class=\"line number22 index21 alt1\">22<\/div>\n<div class=\"line number23 index22 alt2\">23<\/div>\n<div class=\"line number24 index23 alt1\">24<\/div>\n<div class=\"line number25 index24 alt2\">25<\/div>\n<div class=\"line number26 index25 alt1\">26<\/div>\n<div class=\"line number27 index26 alt2\">27<\/div>\n<div class=\"line number28 index27 alt1\">28<\/div>\n<div class=\"line number29 index28 alt2\">29<\/div>\n<div class=\"line number30 index29 alt1\">30<\/div>\n<div class=\"line number31 index30 alt2\">31<\/div>\n<div class=\"line number32 index31 alt1\">32<\/div>\n<div class=\"line number33 index32 alt2\">33<\/div>\n<div class=\"line number34 index33 alt1\">34<\/div>\n<div class=\"line number35 index34 alt2\">35<\/div>\n<div class=\"line number36 index35 alt1\">36<\/div>\n<div class=\"line number37 index36 alt2\">37<\/div>\n<div class=\"line number38 index37 alt1\">38<\/div>\n<div class=\"line number39 index38 alt2\">39<\/div>\n<div class=\"line number40 index39 alt1\">40<\/div>\n<div class=\"line number41 index40 alt2\">41<\/div>\n<div class=\"line number42 index41 alt1\">42<\/div>\n<div class=\"line number43 index42 alt2\">43<\/div>\n<div class=\"line number44 index43 alt1\">44<\/div>\n<div class=\"line number45 index44 alt2\">45<\/div>\n<div class=\"line number46 index45 alt1\">46<\/div>\n<div class=\"line number47 index46 alt2\">47<\/div>\n<div class=\"line number48 index47 alt1\">48<\/div>\n<div class=\"line number49 index48 alt2\">49<\/div>\n<div class=\"line number50 index49 alt1\">50<\/div>\n<div class=\"line number51 index50 alt2\">51<\/div>\n<div class=\"line number52 index51 alt1\">52<\/div>\n<div class=\"line number53 index52 alt2\">53<\/div>\n<div class=\"line number54 index53 alt1\">54<\/div>\n<div class=\"line number55 index54 alt2\">55<\/div>\n<div class=\"line number56 index55 alt1\">56<\/div>\n<div class=\"line number57 index56 alt2\">57<\/div>\n<div class=\"line number58 index57 alt1\">58<\/div>\n<div class=\"line number59 index58 alt2\">59<\/div>\n<div class=\"line number60 index59 alt1\">60<\/div>\n<div class=\"line number61 index60 alt2\">61<\/div>\n<div class=\"line number62 index61 alt1\">62<\/div>\n<div class=\"line number63 index62 alt2\">63<\/div>\n<div class=\"line number64 index63 alt1\">64<\/div>\n<div class=\"line number65 index64 alt2\">65<\/div>\n<div class=\"line number66 index65 alt1\">66<\/div>\n<div class=\"line number67 index66 alt2\">67<\/div>\n<div class=\"line number68 index67 alt1\">68<\/div>\n<div class=\"line number69 index68 alt2\">69<\/div>\n<div class=\"line number70 index69 alt1\">70<\/div>\n<div class=\"line number71 index70 alt2\">71<\/div>\n<div class=\"line number72 index71 alt1\">72<\/div>\n<div class=\"line number73 index72 alt2\">73<\/div>\n<div class=\"line number74 index73 alt1\">74<\/div>\n<div class=\"line number75 index74 alt2\">75<\/div>\n<div class=\"line number76 index75 alt1\">76<\/div>\n<div class=\"line number77 index76 alt2\">77<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"bash plain\">[root@snails mysql-5.7.13]<\/code><code class=\"bash comments\"># cat &gt; \/etc\/my.cnf &lt;&lt; EOF<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"bash plain\">[client]<\/code><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"bash plain\">port = 3306<\/code><\/div>\n<div class=\"line number4 index3 alt1\"><code class=\"bash plain\">socket = <\/code><code class=\"bash plain\">\/dev\/shm\/mysql<\/code><code class=\"bash plain\">.sock<\/code><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"bash plain\">[mysqld]<\/code><\/div>\n<div class=\"line number6 index5 alt1\"><code class=\"bash plain\">port = 3306<\/code><\/div>\n<div class=\"line number7 index6 alt2\"><code class=\"bash plain\">socket = <\/code><code class=\"bash plain\">\/dev\/shm\/mysql<\/code><code class=\"bash plain\">.sock<\/code><\/div>\n<div class=\"line number8 index7 alt1\"><code class=\"bash plain\">basedir = <\/code><code class=\"bash plain\">\/usr\/local\/mysql<\/code><\/div>\n<div class=\"line number9 index8 alt2\"><code class=\"bash plain\">datadir = <\/code><code class=\"bash plain\">\/data\/mysql<\/code><\/div>\n<div class=\"line number10 index9 alt1\"><code class=\"bash plain\">pid-<\/code><code class=\"bash functions\">file<\/code> <code class=\"bash plain\">= <\/code><code class=\"bash plain\">\/data\/mysql\/mysql<\/code><code class=\"bash plain\">.pid<\/code><\/div>\n<div class=\"line number11 index10 alt2\"><code class=\"bash plain\">user = mysql<\/code><\/div>\n<div class=\"line number12 index11 alt1\"><code class=\"bash plain\">bind-address = 0.0.0.0<\/code><\/div>\n<div class=\"line number13 index12 alt2\"><code class=\"bash plain\">server-<\/code><code class=\"bash functions\">id<\/code> <code class=\"bash plain\">= 1<\/code><\/div>\n<div class=\"line number14 index13 alt1\"><code class=\"bash plain\">init-connect = <\/code><code class=\"bash string\">'SET NAMES utf8mb4'<\/code><\/div>\n<div class=\"line number15 index14 alt2\"><code class=\"bash plain\">character-<\/code><code class=\"bash functions\">set<\/code><code class=\"bash plain\">-server = utf8mb4<\/code><\/div>\n<div class=\"line number16 index15 alt1\"><code class=\"bash comments\">#skip-name-resolve<\/code><\/div>\n<div class=\"line number17 index16 alt2\"><code class=\"bash comments\">#skip-networking<\/code><\/div>\n<div class=\"line number18 index17 alt1\"><code class=\"bash plain\">back_log = 300<\/code><\/div>\n<div class=\"line number19 index18 alt2\"><code class=\"bash plain\">max_connections = 1000<\/code><\/div>\n<div class=\"line number20 index19 alt1\"><code class=\"bash plain\">max_connect_errors = 6000<\/code><\/div>\n<div class=\"line number21 index20 alt2\"><code class=\"bash plain\">open_files_limit = 65535<\/code><\/div>\n<div class=\"line number22 index21 alt1\"><code class=\"bash plain\">table_open_cache = 128<\/code><\/div>\n<div class=\"line number23 index22 alt2\"><code class=\"bash plain\">max_allowed_packet = 4M<\/code><\/div>\n<div class=\"line number24 index23 alt1\"><code class=\"bash plain\">binlog_cache_size = 1M<\/code><\/div>\n<div class=\"line number25 index24 alt2\"><code class=\"bash plain\">max_heap_table_size = 8M<\/code><\/div>\n<div class=\"line number26 index25 alt1\"><code class=\"bash plain\">tmp_table_size = 16M<\/code><\/div>\n<div class=\"line number27 index26 alt2\"><code class=\"bash plain\">read_buffer_size = 2M<\/code><\/div>\n<div class=\"line number28 index27 alt1\"><code class=\"bash plain\">read_rnd_buffer_size = 8M<\/code><\/div>\n<div class=\"line number29 index28 alt2\"><code class=\"bash plain\">sort_buffer_size = 8M<\/code><\/div>\n<div class=\"line number30 index29 alt1\"><code class=\"bash plain\">join_buffer_size = 8M<\/code><\/div>\n<div class=\"line number31 index30 alt2\"><code class=\"bash plain\">key_buffer_size = 4M<\/code><\/div>\n<div class=\"line number32 index31 alt1\"><code class=\"bash plain\">thread_cache_size = 8<\/code><\/div>\n<div class=\"line number33 index32 alt2\"><code class=\"bash plain\">query_cache_type = 1<\/code><\/div>\n<div class=\"line number34 index33 alt1\"><code class=\"bash plain\">query_cache_size = 8M<\/code><\/div>\n<div class=\"line number35 index34 alt2\"><code class=\"bash plain\">query_cache_limit = 2M<\/code><\/div>\n<div class=\"line number36 index35 alt1\"><code class=\"bash plain\">ft_min_word_len = 4<\/code><\/div>\n<div class=\"line number37 index36 alt2\"><code class=\"bash plain\">log_bin = mysql-bin<\/code><\/div>\n<div class=\"line number38 index37 alt1\"><code class=\"bash plain\">binlog_format = mixed<\/code><\/div>\n<div class=\"line number39 index38 alt2\"><code class=\"bash plain\">expire_logs_days = 30<\/code><\/div>\n<div class=\"line number40 index39 alt1\"><code class=\"bash plain\">log_error = <\/code><code class=\"bash plain\">\/data\/mysql\/mysql-error<\/code><code class=\"bash plain\">.log<\/code><\/div>\n<div class=\"line number41 index40 alt2\"><code class=\"bash plain\">slow_query_log = 1<\/code><\/div>\n<div class=\"line number42 index41 alt1\"><code class=\"bash plain\">long_query_time = 1<\/code><\/div>\n<div class=\"line number43 index42 alt2\"><code class=\"bash plain\">slow_query_log_file = <\/code><code class=\"bash plain\">\/data\/mysql\/mysql-slow<\/code><code class=\"bash plain\">.log<\/code><\/div>\n<div class=\"line number44 index43 alt1\"><code class=\"bash plain\">performance_schema = 0<\/code><\/div>\n<div class=\"line number45 index44 alt2\"><code class=\"bash plain\">explicit_defaults_for_timestamp<\/code><\/div>\n<div class=\"line number46 index45 alt1\"><code class=\"bash comments\">#lower_case_table_names = 1<\/code><\/div>\n<div class=\"line number47 index46 alt2\"><code class=\"bash plain\">skip-external-locking<\/code><\/div>\n<div class=\"line number48 index47 alt1\"><code class=\"bash plain\">default_storage_engine = InnoDB<\/code><\/div>\n<div class=\"line number49 index48 alt2\"><code class=\"bash comments\">#default-storage-engine = MyISAM<\/code><\/div>\n<div class=\"line number50 index49 alt1\"><code class=\"bash plain\">innodb_file_per_table = 1<\/code><\/div>\n<div class=\"line number51 index50 alt2\"><code class=\"bash plain\">innodb_open_files = 500<\/code><\/div>\n<div class=\"line number52 index51 alt1\"><code class=\"bash plain\">innodb_buffer_pool_size = 64M<\/code><\/div>\n<div class=\"line number53 index52 alt2\"><code class=\"bash plain\">innodb_write_io_threads = 4<\/code><\/div>\n<div class=\"line number54 index53 alt1\"><code class=\"bash plain\">innodb_read_io_threads = 4<\/code><\/div>\n<div class=\"line number55 index54 alt2\"><code class=\"bash plain\">innodb_thread_concurrency = 0<\/code><\/div>\n<div class=\"line number56 index55 alt1\"><code class=\"bash plain\">innodb_purge_threads = 1<\/code><\/div>\n<div class=\"line number57 index56 alt2\"><code class=\"bash plain\">innodb_flush_log_at_trx_commit = 2<\/code><\/div>\n<div class=\"line number58 index57 alt1\"><code class=\"bash plain\">innodb_log_buffer_size = 2M<\/code><\/div>\n<div class=\"line number59 index58 alt2\"><code class=\"bash plain\">innodb_log_file_size = 32M<\/code><\/div>\n<div class=\"line number60 index59 alt1\"><code class=\"bash plain\">innodb_log_files_in_group = 3<\/code><\/div>\n<div class=\"line number61 index60 alt2\"><code class=\"bash plain\">innodb_max_dirty_pages_pct = 90<\/code><\/div>\n<div class=\"line number62 index61 alt1\"><code class=\"bash plain\">innodb_lock_wait_timeout = 120<\/code><\/div>\n<div class=\"line number63 index62 alt2\"><code class=\"bash plain\">bulk_insert_buffer_size = 8M<\/code><\/div>\n<div class=\"line number64 index63 alt1\"><code class=\"bash plain\">myisam_sort_buffer_size = 8M<\/code><\/div>\n<div class=\"line number65 index64 alt2\"><code class=\"bash plain\">myisam_max_sort_file_size = 10G<\/code><\/div>\n<div class=\"line number66 index65 alt1\"><code class=\"bash plain\">myisam_repair_threads = 1<\/code><\/div>\n<div class=\"line number67 index66 alt2\"><code class=\"bash plain\">interactive_timeout = 28800<\/code><\/div>\n<div class=\"line number68 index67 alt1\"><code class=\"bash plain\">wait_timeout = 28800<\/code><\/div>\n<div class=\"line number69 index68 alt2\"><code class=\"bash plain\">[mysqldump]<\/code><\/div>\n<div class=\"line number70 index69 alt1\"><code class=\"bash plain\">quick<\/code><\/div>\n<div class=\"line number71 index70 alt2\"><code class=\"bash plain\">max_allowed_packet = 16M<\/code><\/div>\n<div class=\"line number72 index71 alt1\"><code class=\"bash plain\">[myisamchk]<\/code><\/div>\n<div class=\"line number73 index72 alt2\"><code class=\"bash plain\">key_buffer_size = 8M<\/code><\/div>\n<div class=\"line number74 index73 alt1\"><code class=\"bash plain\">sort_buffer_size = 8M<\/code><\/div>\n<div class=\"line number75 index74 alt2\"><code class=\"bash plain\">read_buffer = 4M<\/code><\/div>\n<div class=\"line number76 index75 alt1\"><code class=\"bash plain\">write_buffer = 4M<\/code><\/div>\n<div class=\"line number77 index76 alt2\"><code class=\"bash plain\">EOF<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<p><strong>\u6dfb\u52a0mysql\u7684\u73af\u5883\u53d8\u91cf<\/strong><\/p>\n<div class=\"codetitle\"><a id=\"copybut89591\" class=\"copybut\"><\/a><u>\u590d\u5236\u4ee3\u7801<\/u>\u4ee3\u7801\u5982\u4e0b:<\/div>\n<div id=\"code89591\" class=\"codebody\">\n[root@snails mysql-5.7.13]# echo -e &#8216;\\n\\nexport PATH=\/usr\/local\/mysql\/bin:$PATH\\n&#8217; &gt;&gt; \/etc\/profile &amp;&amp; source \/etc\/profile<\/div>\n<p><strong>\u521d\u59cb\u5316\u6570\u636e\u5e93<\/strong><\/p>\n<div class=\"codetitle\"><a id=\"copybut81305\" class=\"copybut\"><\/a><u>\u590d\u5236\u4ee3\u7801<\/u>\u4ee3\u7801\u5982\u4e0b:<\/div>\n<div id=\"code81305\" class=\"codebody\">\n[root@snails mysql-5.7.13]# mysqld &#8211;initialize-insecure &#8211;user=mysql &#8211;basedir=\/usr\/local\/mysql &#8211;datadir=\/data\/mysql<\/div>\n<p>\u6ce8\uff1a<\/p>\n<ul>\n<li>MySQL\u4e4b\u524d\u7248\u672cmysql_install_db\u662f\u5728mysql_basedir\/script\u4e0b<\/li>\n<li>MySQL 5.7\u76f4\u63a5\u653e\u5728\u4e86mysql_install_db\/bin\u76ee\u5f55\u4e0b\u3002<\/li>\n<li>&#8220;\u2013initialize&#8221;\u5df2\u5e9f\u5f03,\u751f\u6210\u4e00\u4e2a\u968f\u673a\u5bc6\u7801(~\/.mysql_secret)<\/li>\n<li>&#8220;\u2013initialize-insecure&#8221;\u4e0d\u4f1a\u751f\u6210\u5bc6\u7801<\/li>\n<li>&#8220;\u2013datadir&#8221;\u76ee\u5f55\u4e0b\u4e0d\u80fd\u6709\u6570\u636e\u6587\u4ef6<\/li>\n<\/ul>\n<p><strong>\u542f\u52a8\u6570\u636e\u5e93<\/strong><\/p>\n<div class=\"jb51code\">\n<div>\n<div id=\"highlighter_694547\" class=\"syntaxhighlighter  bash\">\n<div class=\"toolbar\"><a class=\"toolbar_item command_help help\" href=\"http:\/\/www.jb51.net\/article\/104016.htm#\">?<\/a><\/div>\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<div class=\"line number2 index1 alt1\">2<\/div>\n<div class=\"line number3 index2 alt2\">3<\/div>\n<div class=\"line number4 index3 alt1\">4<\/div>\n<div class=\"line number5 index4 alt2\">5<\/div>\n<div class=\"line number6 index5 alt1\">6<\/div>\n<div class=\"line number7 index6 alt2\">7<\/div>\n<div class=\"line number8 index7 alt1\">8<\/div>\n<div class=\"line number9 index8 alt2\">9<\/div>\n<div class=\"line number10 index9 alt1\">10<\/div>\n<div class=\"line number11 index10 alt2\">11<\/div>\n<div class=\"line number12 index11 alt1\">12<\/div>\n<div class=\"line number13 index12 alt2\">13<\/div>\n<div class=\"line number14 index13 alt1\">14<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"bash plain\">[root@snails mysql-5.7.13]<\/code><code class=\"bash comments\"># systemctl start mysqld<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"bash plain\">[root@snails mysql-5.7.13]<\/code><code class=\"bash comments\"># systemctl status mysqld<\/code><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"bash spaces\">\u00a0<\/code><code class=\"bash plain\">mysqld.service - LSB: start and stop MySQL<\/code><\/div>\n<div class=\"line number4 index3 alt1\"><code class=\"bash spaces\">\u00a0<\/code><code class=\"bash plain\">Loaded: loaded (<\/code><code class=\"bash plain\">\/etc\/rc<\/code><code class=\"bash plain\">.d<\/code><code class=\"bash plain\">\/init<\/code><code class=\"bash plain\">.d<\/code><code class=\"bash plain\">\/mysqld<\/code><code class=\"bash plain\">)<\/code><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"bash spaces\">\u00a0<\/code><code class=\"bash plain\">Active: active (running) since \u4e00 2016-07-18 11:15:35 CST; 8s ago<\/code><\/div>\n<div class=\"line number6 index5 alt1\"><code class=\"bash spaces\">\u00a0\u00a0<\/code><code class=\"bash plain\">Docs: <\/code><code class=\"bash functions\">man<\/code><code class=\"bash plain\">:systemd-sysv-generator(8)<\/code><\/div>\n<div class=\"line number7 index6 alt2\"><code class=\"bash spaces\">\u00a0<\/code><code class=\"bash plain\">Process: 23927 ExecStart=<\/code><code class=\"bash plain\">\/etc\/rc<\/code><code class=\"bash plain\">.d<\/code><code class=\"bash plain\">\/init<\/code><code class=\"bash plain\">.d<\/code><code class=\"bash plain\">\/mysqld<\/code> <code class=\"bash plain\">start (code=exited, status=0<\/code><code class=\"bash plain\">\/SUCCESS<\/code><code class=\"bash plain\">)<\/code><\/div>\n<div class=\"line number8 index7 alt1\"><code class=\"bash spaces\">\u00a0<\/code><code class=\"bash plain\">CGroup: <\/code><code class=\"bash plain\">\/system<\/code><code class=\"bash plain\">.slice<\/code><code class=\"bash plain\">\/mysqld<\/code><code class=\"bash plain\">.service<\/code><\/div>\n<div class=\"line number9 index8 alt2\"><code class=\"bash spaces\">\u00a0\u00a0\u00a0<\/code><code class=\"bash plain\">\u251c\u250023940 <\/code><code class=\"bash plain\">\/bin\/sh<\/code> <code class=\"bash plain\">\/usr\/local\/mysql\/bin\/mysqld_safe<\/code> <code class=\"bash plain\">--datadir=<\/code><code class=\"bash plain\">\/data\/mysql<\/code> <code class=\"bash plain\">--pid-<\/code><code class=\"bash functions\">file<\/code><code class=\"bash plain\">=<\/code><code class=\"bash plain\">\/data\/mysql\/mysql<\/code><code class=\"bash plain\">.pid<\/code><\/div>\n<div class=\"line number10 index9 alt1\"><code class=\"bash spaces\">\u00a0\u00a0\u00a0<\/code><code class=\"bash plain\">\u2514\u250024776 <\/code><code class=\"bash plain\">\/usr\/local\/mysql\/bin\/mysqld<\/code> <code class=\"bash plain\">--basedir=<\/code><code class=\"bash plain\">\/usr\/local\/mysql<\/code> <code class=\"bash plain\">--datadir=<\/code><code class=\"bash plain\">\/data\/mysql<\/code> <code class=\"bash plain\">--plugin-<\/code><code class=\"bash functions\">dir<\/code><code class=\"bash plain\">=<\/code><code class=\"bash plain\">\/usr\/local\/mysql\/lib\/plugin<\/code> <code class=\"bash plain\">--user=mysql --log-error=<\/code><code class=\"bash plain\">\/data\/mysql\/mysql-err<\/code><code class=\"bash plain\">...<\/code><\/div>\n<div class=\"line number11 index10 alt2\"><\/div>\n<div class=\"line number12 index11 alt1\"><code class=\"bash plain\">7\u6708 18 11:15:32 snails systemd[1]: Starting LSB: start and stop MySQL...<\/code><\/div>\n<div class=\"line number13 index12 alt2\"><code class=\"bash plain\">7\u6708 18 11:15:35 snails mysqld[23927]: Starting MySQL..[ OK ]<\/code><\/div>\n<div class=\"line number14 index13 alt1\"><code class=\"bash plain\">7\u6708 18 11:15:35 snails systemd[1]: Started LSB: start and stop MySQL.<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<p><strong>\u67e5\u770bMySQL\u670d\u52a1\u8fdb\u7a0b\u548c\u7aef\u53e3<\/strong><\/p>\n<div class=\"jb51code\">\n<div>\n<div id=\"highlighter_21986\" class=\"syntaxhighlighter  bash\">\n<div class=\"toolbar\"><a class=\"toolbar_item command_help help\" href=\"http:\/\/www.jb51.net\/article\/104016.htm#\">?<\/a><\/div>\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<div class=\"line number2 index1 alt1\">2<\/div>\n<div class=\"line number3 index2 alt2\">3<\/div>\n<div class=\"line number4 index3 alt1\">4<\/div>\n<div class=\"line number5 index4 alt2\">5<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"bash plain\">[root@snails mysql-5.7.13]<\/code><code class=\"bash comments\"># ps -ef | grep mysql<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"bash plain\">root\u00a0 23940\u00a0 1 0 11:15 ?\u00a0 00:00:00 <\/code><code class=\"bash plain\">\/bin\/sh<\/code> <code class=\"bash plain\">\/usr\/local\/mysql\/bin\/mysqld_safe<\/code> <code class=\"bash plain\">--datadir=<\/code><code class=\"bash plain\">\/data\/mysql<\/code> <code class=\"bash plain\">--pid-<\/code><code class=\"bash functions\">file<\/code><code class=\"bash plain\">=<\/code><code class=\"bash plain\">\/data\/mysql\/mysql<\/code><code class=\"bash plain\">.pid<\/code><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"bash plain\">mysql 24776 23940 0 11:15 ?\u00a0 00:00:00 <\/code><code class=\"bash plain\">\/usr\/local\/mysql\/bin\/mysqld<\/code> <code class=\"bash plain\">--basedir=<\/code><code class=\"bash plain\">\/usr\/local\/mysql<\/code> <code class=\"bash plain\">--datadir=<\/code><code class=\"bash plain\">\/data\/mysql<\/code> <code class=\"bash plain\">--plugin-<\/code><code class=\"bash functions\">dir<\/code><code class=\"bash plain\">=<\/code><code class=\"bash plain\">\/usr\/local\/mysql\/lib\/plugin<\/code> <code class=\"bash plain\">--user=mysql --log-error=<\/code><code class=\"bash plain\">\/data\/mysql\/mysql-error<\/code><code class=\"bash plain\">.log --<\/code><code class=\"bash functions\">open<\/code><code class=\"bash plain\">-files-limit=65535 --pid-<\/code><code class=\"bash functions\">file<\/code><code class=\"bash plain\">=<\/code><code class=\"bash plain\">\/data\/mysql\/mysql<\/code><code class=\"bash plain\">.pid --socket=<\/code><code class=\"bash plain\">\/dev\/shm\/mysql<\/code><code class=\"bash plain\">.sock --port=3306<\/code><\/div>\n<div class=\"line number4 index3 alt1\"><code class=\"bash plain\">[root@snails mysql-5.7.13]<\/code><code class=\"bash comments\"># netstat -tunpl | grep 3306<\/code><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"bash plain\">tcp\u00a0 0\u00a0 0 0.0.0.0:3306\u00a0\u00a0 0.0.0.0:*\u00a0\u00a0\u00a0 LISTEN\u00a0 24776<\/code><code class=\"bash plain\">\/mysqld<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<p><strong>\u8bbe\u7f6e\u6570\u636e\u5e93root\u7528\u6237\u5bc6\u7801<\/strong><\/p>\n<p>MySQL\u548cOracle\u6570\u636e\u5e93\u4e00\u6837\uff0c\u6570\u636e\u5e93\u4e5f\u9ed8\u8ba4\u81ea\u5e26\u4e86\u4e00\u4e2a root \u7528\u6237\uff08\u8fd9\u4e2a\u548c\u5f53\u524dLinux\u4e3b\u673a\u4e0a\u7684root\u7528\u6237\u662f\u5b8c\u5168\u4e0d\u642d\u8fb9\u7684\uff09\uff0c\u6211\u4eec\u5728\u8bbe\u7f6e\u597dMySQL\u6570\u636e\u5e93\u7684\u5b89\u5168\u914d\u7f6e\u540e\u521d\u59cb\u5316root\u7528\u6237\u7684\u5bc6\u7801\u3002\u914d\u5236\u8fc7\u7a0b\u4e2d\uff0c\u4e00\u8def\u8f93\u5165 y \u5c31\u884c\u4e86\u3002\u8fd9\u91cc\u53ea\u8bf4\u660e\u4e0bMySQL5.7.13\u7248\u672c\u4e2d\uff0c\u7528\u6237\u5bc6\u7801\u7b56\u7565\u5206\u6210\u4f4e\u7ea7 LOW \u3001\u4e2d\u7b49 MEDIUM \u548c\u8d85\u5f3a STRONG \u4e09\u79cd\uff0c\u63a8\u8350\u4f7f\u7528\u4e2d\u7b49 MEDIUM \u7ea7\u522b\uff01<\/p>\n<div class=\"jb51code\">\n<div>\n<div id=\"highlighter_517961\" class=\"syntaxhighlighter  bash\">\n<div class=\"toolbar\"><a class=\"toolbar_item command_help help\" href=\"http:\/\/www.jb51.net\/article\/104016.htm#\">?<\/a><\/div>\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"bash plain\">[root@snails mysql-5.7.13]<\/code><code class=\"bash comments\"># mysql_secure_installation<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<p><strong>\u5e38\u7528\u64cd\u4f5c<\/strong><\/p>\n<p><strong>\u5c06MySQL\u6570\u636e\u5e93\u7684\u52a8\u6001\u94fe\u63a5\u5e93\u5171\u4eab\u81f3\u7cfb\u7edf\u94fe\u63a5\u5e93<\/strong><\/p>\n<p>\u4e00\u822cMySQL\u6570\u636e\u5e93\u8fd8\u4f1a\u88ab\u7c7b\u4f3c\u4e8ePHP\u7b49\u670d\u52a1\u8c03\u7528\uff0c\u6240\u4ee5\u6211\u4eec\u9700\u8981\u5c06MySQL\u7f16\u8bd1\u540e\u7684lib\u5e93\u6587\u4ef6\u6dfb\u52a0\u81f3\u5f53\u524dLinux\u4e3b\u673a\u94fe\u63a5\u5e93 \/etc\/ld.so.conf.d\/\u4e0b\uff0c\u8fd9\u6837MySQL\u670d\u52a1\u5c31\u53ef\u4ee5\u88ab\u5176\u5b83\u670d\u52a1\u8c03\u7528\u4e86\u3002<\/p>\n<div class=\"jb51code\">\n<div>\n<div id=\"highlighter_374098\" class=\"syntaxhighlighter  bash\">\n<div class=\"toolbar\"><a class=\"toolbar_item command_help help\" href=\"http:\/\/www.jb51.net\/article\/104016.htm#\">?<\/a><\/div>\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<div class=\"line number2 index1 alt1\">2<\/div>\n<div class=\"line number3 index2 alt2\">3<\/div>\n<div class=\"line number4 index3 alt1\">4<\/div>\n<div class=\"line number5 index4 alt2\">5<\/div>\n<div class=\"line number6 index5 alt1\">6<\/div>\n<div class=\"line number7 index6 alt2\">7<\/div>\n<div class=\"line number8 index7 alt1\">8<\/div>\n<div class=\"line number9 index8 alt2\">9<\/div>\n<div class=\"line number10 index9 alt1\">10<\/div>\n<div class=\"line number11 index10 alt2\">11<\/div>\n<div class=\"line number12 index11 alt1\">12<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"bash plain\">[root@snails mysql-5.7.13]<\/code><code class=\"bash comments\"># ldconfig |grep mysql<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"bash plain\">[root@snails mysql-5.7.13]<\/code><code class=\"bash comments\"># echo \"\/usr\/local\/mysql\/lib\" &gt; \/etc\/ld.so.conf.d\/mysql.conf<\/code><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"bash plain\">[root@snails mysql-5.7.13]<\/code><code class=\"bash comments\"># ldconfig<\/code><\/div>\n<div class=\"line number4 index3 alt1\"><code class=\"bash plain\">[root@snails mysql-5.7.13]<\/code><code class=\"bash comments\"># ldconfig -v |grep mysql<\/code><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"bash plain\">ldconfig: \u65e0\u6cd5\u5bf9 <\/code><code class=\"bash plain\">\/libx32<\/code> <code class=\"bash plain\">\u8fdb\u884c stat \u64cd\u4f5c: \u6ca1\u6709\u90a3\u4e2a\u6587\u4ef6\u6216\u76ee\u5f55<\/code><\/div>\n<div class=\"line number6 index5 alt1\"><code class=\"bash plain\">ldconfig: \u591a\u6b21\u7ed9\u51fa\u8def\u5f84\u201c<\/code><code class=\"bash plain\">\/usr\/lib<\/code><code class=\"bash plain\">\u201d<\/code><\/div>\n<div class=\"line number7 index6 alt2\"><code class=\"bash plain\">ldconfig: \u591a\u6b21\u7ed9\u51fa\u8def\u5f84\u201c<\/code><code class=\"bash plain\">\/usr\/lib64<\/code><code class=\"bash plain\">\u201d<\/code><\/div>\n<div class=\"line number8 index7 alt1\"><code class=\"bash plain\">ldconfig: \u65e0\u6cd5\u5bf9 <\/code><code class=\"bash plain\">\/usr\/libx32<\/code> <code class=\"bash plain\">\u8fdb\u884c stat \u64cd\u4f5c: \u6ca1\u6709\u90a3\u4e2a\u6587\u4ef6\u6216\u76ee\u5f55<\/code><\/div>\n<div class=\"line number9 index8 alt2\"><code class=\"bash plain\">\/usr\/lib64\/mysql<\/code><code class=\"bash plain\">:<\/code><\/div>\n<div class=\"line number10 index9 alt1\"><code class=\"bash spaces\">\u00a0<\/code><code class=\"bash plain\">libmysqlclient.so.18 -&gt; libmysqlclient.so.18.0.0<\/code><\/div>\n<div class=\"line number11 index10 alt2\"><code class=\"bash plain\">\/usr\/local\/mysql\/lib<\/code><code class=\"bash plain\">:<\/code><\/div>\n<div class=\"line number12 index11 alt1\"><code class=\"bash spaces\">\u00a0<\/code><code class=\"bash plain\">libmysqlclient.so.20 -&gt; libmysqlclient.so.20.3.0<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<p><strong>\u521b\u5efa\u5176\u5b83MySQL\u6570\u636e\u5e93\u7528\u6237<\/strong><\/p>\n<div class=\"jb51code\">\n<div>\n<div id=\"highlighter_818348\" class=\"syntaxhighlighter  sql\">\n<div class=\"toolbar\"><a class=\"toolbar_item command_help help\" href=\"http:\/\/www.jb51.net\/article\/104016.htm#\">?<\/a><\/div>\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<div class=\"line number2 index1 alt1\">2<\/div>\n<div class=\"line number3 index2 alt2\">3<\/div>\n<div class=\"line number4 index3 alt1\">4<\/div>\n<div class=\"line number5 index4 alt2\">5<\/div>\n<div class=\"line number6 index5 alt1\">6<\/div>\n<div class=\"line number7 index6 alt2\">7<\/div>\n<div class=\"line number8 index7 alt1\">8<\/div>\n<div class=\"line number9 index8 alt2\">9<\/div>\n<div class=\"line number10 index9 alt1\">10<\/div>\n<div class=\"line number11 index10 alt2\">11<\/div>\n<div class=\"line number12 index11 alt1\">12<\/div>\n<div class=\"line number13 index12 alt2\">13<\/div>\n<div class=\"line number14 index13 alt1\">14<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"sql plain\">[root@snails mysql-5.7.13]# mysql -uroot -p<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"sql plain\">Enter <\/code><code class=\"sql keyword\">password<\/code><code class=\"sql plain\">: <\/code><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"sql plain\">Welcome <\/code><code class=\"sql keyword\">to<\/code> <code class=\"sql plain\">the MySQL monitor. Commands <\/code><code class=\"sql keyword\">end<\/code> <code class=\"sql keyword\">with<\/code> <code class=\"sql plain\">; <\/code><code class=\"sql color1\">or<\/code> <code class=\"sql plain\">\\g.<\/code><\/div>\n<div class=\"line number4 index3 alt1\"><code class=\"sql plain\">Your MySQL <\/code><code class=\"sql keyword\">connection<\/code> <code class=\"sql plain\">id <\/code><code class=\"sql keyword\">is<\/code> <code class=\"sql plain\">4<\/code><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"sql plain\">Server version: 5.7.13-log Source distribution<\/code><\/div>\n<div class=\"line number6 index5 alt1\"><\/div>\n<div class=\"line number7 index6 alt2\"><code class=\"sql plain\">Copyright (c) 2000, 2016, Oracle <\/code><code class=\"sql color1\">and<\/code><code class=\"sql plain\">\/<\/code><code class=\"sql color1\">or<\/code> <code class=\"sql plain\">its affiliates. <\/code><code class=\"sql color1\">All<\/code> <code class=\"sql plain\">rights reserved.<\/code><\/div>\n<div class=\"line number8 index7 alt1\"><\/div>\n<div class=\"line number9 index8 alt2\"><code class=\"sql plain\">Oracle <\/code><code class=\"sql keyword\">is<\/code> <code class=\"sql plain\">a registered trademark <\/code><code class=\"sql keyword\">of<\/code> <code class=\"sql plain\">Oracle Corporation <\/code><code class=\"sql color1\">and<\/code><code class=\"sql plain\">\/<\/code><code class=\"sql color1\">or<\/code> <code class=\"sql plain\">its<\/code><\/div>\n<div class=\"line number10 index9 alt1\"><code class=\"sql plain\">affiliates. Other names may be trademarks <\/code><code class=\"sql keyword\">of<\/code> <code class=\"sql plain\">their respective<\/code><\/div>\n<div class=\"line number11 index10 alt2\"><code class=\"sql plain\">owners.<\/code><\/div>\n<div class=\"line number12 index11 alt1\"><\/div>\n<div class=\"line number13 index12 alt2\"><code class=\"sql plain\">Type <\/code><code class=\"sql string\">'help;'<\/code> <code class=\"sql color1\">or<\/code> <code class=\"sql string\">'\\h'<\/code> <code class=\"sql keyword\">for<\/code> <code class=\"sql plain\">help. Type <\/code><code class=\"sql string\">'\\c'<\/code> <code class=\"sql keyword\">to<\/code> <code class=\"sql plain\">clear the <\/code><code class=\"sql keyword\">current<\/code> <code class=\"sql plain\">input statement.<\/code><\/div>\n<div class=\"line number14 index13 alt1\"><code class=\"sql plain\">mysql&gt;<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"jb51code\">\n<div>\n<div id=\"highlighter_15500\" class=\"syntaxhighlighter  sql\">\n<div class=\"toolbar\"><a class=\"toolbar_item command_help help\" href=\"http:\/\/www.jb51.net\/article\/104016.htm#\">?<\/a><\/div>\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<div class=\"line number2 index1 alt1\">2<\/div>\n<div class=\"line number3 index2 alt2\">3<\/div>\n<div class=\"line number4 index3 alt1\">4<\/div>\n<div class=\"line number5 index4 alt2\">5<\/div>\n<div class=\"line number6 index5 alt1\">6<\/div>\n<div class=\"line number7 index6 alt2\">7<\/div>\n<div class=\"line number8 index7 alt1\">8<\/div>\n<div class=\"line number9 index8 alt2\">9<\/div>\n<div class=\"line number10 index9 alt1\">10<\/div>\n<div class=\"line number11 index10 alt2\">11<\/div>\n<div class=\"line number12 index11 alt1\">12<\/div>\n<div class=\"line number13 index12 alt2\">13<\/div>\n<div class=\"line number14 index13 alt1\">14<\/div>\n<div class=\"line number15 index14 alt2\">15<\/div>\n<div class=\"line number16 index15 alt1\">16<\/div>\n<div class=\"line number17 index16 alt2\">17<\/div>\n<div class=\"line number18 index17 alt1\">18<\/div>\n<div class=\"line number19 index18 alt2\">19<\/div>\n<div class=\"line number20 index19 alt1\">20<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"sql plain\">mysql&gt;<\/code><code class=\"sql keyword\">CREATE<\/code> <code class=\"sql keyword\">DATABASE<\/code> <code class=\"sql plain\">`tonnydb` <\/code><code class=\"sql keyword\">DEFAULT<\/code> <code class=\"sql keyword\">CHARACTER<\/code> <code class=\"sql keyword\">SET<\/code> <code class=\"sql plain\">utf8 <\/code><code class=\"sql keyword\">COLLATE<\/code> <code class=\"sql plain\">utf8_general_ci;<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"sql plain\">Query OK, 1 row affected (0.01 sec)<\/code><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"sql plain\">mysql&gt; show databases;<\/code><\/div>\n<div class=\"line number4 index3 alt1\"><code class=\"sql plain\">+<\/code><code class=\"sql comments\">--------------------+<\/code><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"sql plain\">| <\/code><code class=\"sql keyword\">Database<\/code>\u00a0\u00a0 <code class=\"sql plain\">|<\/code><\/div>\n<div class=\"line number6 index5 alt1\"><code class=\"sql plain\">+<\/code><code class=\"sql comments\">--------------------+<\/code><\/div>\n<div class=\"line number7 index6 alt2\"><code class=\"sql plain\">| information_schema |<\/code><\/div>\n<div class=\"line number8 index7 alt1\"><code class=\"sql plain\">| mysql\u00a0\u00a0\u00a0 |<\/code><\/div>\n<div class=\"line number9 index8 alt2\"><code class=\"sql plain\">| performance_schema |<\/code><\/div>\n<div class=\"line number10 index9 alt1\"><code class=\"sql plain\">| sys\u00a0\u00a0\u00a0 |<\/code><\/div>\n<div class=\"line number11 index10 alt2\"><code class=\"sql plain\">| tonnydb\u00a0\u00a0 |<\/code><\/div>\n<div class=\"line number12 index11 alt1\"><code class=\"sql plain\">+<\/code><code class=\"sql comments\">--------------------+<\/code><\/div>\n<div class=\"line number13 index12 alt2\"><code class=\"sql plain\">5 <\/code><code class=\"sql keyword\">rows<\/code> <code class=\"sql color1\">in<\/code> <code class=\"sql keyword\">set<\/code> <code class=\"sql plain\">(0.00 sec)<\/code><\/div>\n<div class=\"line number14 index13 alt1\"><code class=\"sql plain\">mysql&gt; <\/code><code class=\"sql keyword\">grant<\/code> <code class=\"sql color1\">all<\/code> <code class=\"sql keyword\">privileges<\/code> <code class=\"sql keyword\">on<\/code> <code class=\"sql plain\">tonnydb.* <\/code><code class=\"sql keyword\">to<\/code> <code class=\"sql string\">'tonny@%'<\/code> <code class=\"sql plain\">identified <\/code><code class=\"sql keyword\">by<\/code> <code class=\"sql string\">'Hi.Tonny@888'<\/code><code class=\"sql plain\">;<\/code><\/div>\n<div class=\"line number15 index14 alt2\"><code class=\"sql plain\">Query OK, 0 <\/code><code class=\"sql keyword\">rows<\/code> <code class=\"sql plain\">affected, 1 warning (0.00 sec)<\/code><\/div>\n<div class=\"line number16 index15 alt1\"><\/div>\n<div class=\"line number17 index16 alt2\"><code class=\"sql plain\">mysql&gt; flush <\/code><code class=\"sql keyword\">privileges<\/code><code class=\"sql plain\">;<\/code><\/div>\n<div class=\"line number18 index17 alt1\"><code class=\"sql plain\">Query OK, 0 <\/code><code class=\"sql keyword\">rows<\/code> <code class=\"sql plain\">affected (0.01 sec)<\/code><\/div>\n<div class=\"line number19 index18 alt2\"><\/div>\n<div class=\"line number20 index19 alt1\"><code class=\"sql plain\">mysql&gt; exit<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<p>\u4ee5\u4e0a\u5c31\u662f\u672c\u6587\u7684\u5168\u90e8\u5185\u5bb9\uff0c\u5e0c\u671b\u5bf9\u5927\u5bb6\u7684\u5b66\u4e60\u6709\u6240\u5e2e\u52a9\uff0c\u4e5f\u5e0c\u671b\u5927\u5bb6\u591a\u591a\u652f\u6301\u811a\u672c\u4e4b\u5bb6\u3002<\/p>\n<p>\u539f\u6587\u94fe\u63a5\uff1ahttp:\/\/www.jianshu.com\/p\/95a103add722<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u4f5c\u8005\uff1a\u6280\u672f\u5b66\u4e60 \u5b57\u4f53\uff1a[\u589e\u52a0\u00a0\u51cf\u5c0f] \u7c7b<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"colormag_page_container_layout":"default_layout","colormag_page_sidebar_layout":"default_layout","footnotes":""},"categories":[],"tags":[117],"class_list":["post-753","post","type-post","status-publish","format-standard","hentry","tag-01-linux"],"_links":{"self":[{"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/posts\/753","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/comments?post=753"}],"version-history":[{"count":0,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/posts\/753\/revisions"}],"wp:attachment":[{"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/media?parent=753"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/categories?post=753"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/tags?post=753"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}