{"id":359,"date":"2019-06-25T15:59:23","date_gmt":"2019-06-25T07:59:23","guid":{"rendered":"http:\/\/www.inhhh.com\/blog\/?p=359"},"modified":"2020-11-30T13:48:40","modified_gmt":"2020-11-30T05:48:40","slug":"centos-mysql-5-6-34-%e7%bc%96%e8%af%91%e5%ae%89%e8%a3%85","status":"publish","type":"post","link":"http:\/\/www.inhhh.com\/blog\/?p=359","title":{"rendered":"\u6811\u8393\u6d3e\u670d\u52a1\u5668\uff08\u7b2c\u5341\u7ae0\uff1a mysql-5.6.34 \u7f16\u8bd1\u5b89\u88c5\uff09"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<p>centos mysql-5.6.34 \u7f16\u8bd1\u5b89\u88c5\uff1a<\/p>\n\n\n\n<p>\u51c6\u5907\u5de5\u4f5c\uff1a<br>\nyum install gcc gcc-c++ ncurses-devel perl<\/p>\n\n\n\n<p>\u5b89\u88c5cmake:<br>\nyum install cmake<br>\n\u6216\u6e90\u7801\u5b89\u88c5\uff1a<br>\nwget http:\/\/www.cmake.org\/files\/v2.8\/cmake-2.8.10.2.tar.gz &nbsp;&nbsp;<br>\ntar -xzvf cmake-2.8.10.2.tar.gz &nbsp;&nbsp;<br>\ncd cmake-2.8.10.2 &nbsp;&nbsp;<br>\n.\/bootstrap ; make ; make install &nbsp;&nbsp;<br>\ncd ~ &nbsp;<\/p>\n\n\n\n<p>\u65b0\u589emysql\u7528\u6237\u7ec4\uff1a<br>\ngroupadd mysql &nbsp;<br>\n\u65b0\u589emysql\u7528\u6237\uff1a<br>\nuseradd -r -g mysql mysql<br>\n\u65b0\u5efamysql\u5b89\u88c5\u76ee\u5f55\uff1a<br>\nmkdir -p \/usr\/local\/mysql &nbsp;<br>\n\u65b0\u5efamysql\u6570\u636e\u5e93\u6570\u636e\u6587\u4ef6\u76ee\u5f55\uff1a<br>\nmkdir -p \/data\/mysqldb &nbsp;<\/p>\n\n\n\n<p>&nbsp;wget http:\/\/dev.mysql.com\/get\/Downloads\/MySQL-5.6\/mysql-5.6.34.tar.gz<br>\n&nbsp;tar -zxvf mysql-5.6.34.tar.gz<br>\n&nbsp;cd mysql-5.6.34<\/p>\n\n\n\n<p>\u4ecemysql5.5\u8d77\uff0cmysql\u6e90\u7801\u5b89\u88c5\u5f00\u59cb\u4f7f\u7528cmake\u4e86\uff0c\u8bbe\u7f6e\u6e90\u7801\u7f16\u8bd1\u914d\u7f6e\u811a\u672c\uff1a<br>\ncmake -DCMAKE_INSTALL_PREFIX=\/usr\/local\/mysql -DMYSQL_UNIX_ADDR=\/usr\/local\/mysql\/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DMYSQL_DATADIR=\/data1\/mysqldb -DMYSQL_TCP_PORT=3306 -DENABLE_DOWNLOADS=1<\/p>\n\n\n\n<p>make -j4<\/p>\n\n\n\n<p>make install<\/p>\n\n\n\n<p>\u4fee\u6539mysql\u76ee\u5f55\u6240\u6709\u8005\u548c\u7ec4:<br> cd \/usr\/local\/mysql \u00a0\u00a0<br> chown -R mysql:mysql .\/\u00a0<\/p>\n\n\n\n<p>cd \/data\/mysqldb \u00a0<br> chown -R mysql:mysql .\/ \u00a0<\/p>\n\n\n\n<p>\u521d\u59cb\u5316mysql\u6570\u636e\u5e93:<br> cd \/usr\/local\/mysql \u00a0\u00a0<br> scripts\/mysql_install_db &#8211;user=mysql &#8211;datadir=\/data\/mysqldb<\/p>\n\n\n\n<p>\u590d\u5236mysql\u670d\u52a1\u542f\u52a8\u914d\u7f6e\u6587\u4ef6\uff1a<br>\ncp \/usr\/local\/mysql\/support-files\/my-default.cnf \/etc\/my.cnf &nbsp;<\/p>\n\n\n\n<p>giedt \/etc\/my.cnf<\/p>\n\n\n<p>[client]<\/p>\n\n\n\n<p>\nport &nbsp; &nbsp;= 3306<br>\nsocket = \/var\/lib\/mysql\/mysql.sock\n<\/p>\n\n\n<p>[mysqld]<\/p>\n\n\n\n<p> user \u00a0 \u00a0= mysql<br> port \u00a0 \u00a0= 3306<br> socket = \/var\/lib\/mysql\/mysql.sock<br> basedir = \/usr\/local\/mysql<br> datadir = \/data1\/mysqldb<br> log-error = \/data\/mysqldb\/mysql_error.log<br> pid-file = \/data\/mysqldb\/mysql.pid <\/p>\n\n\n\n<p>\u590d\u5236mysql\u670d\u52a1\u542f\u52a8\u811a\u672c\u53ca\u52a0\u5165PATH\u8def\u5f84\uff1a<br>\ncp support-files\/mysql.server \/etc\/init.d\/mysqld&nbsp;<\/p>\n\n\n\n<p>vim \/etc\/profile&nbsp;<\/p>\n\n\n\n<p>&nbsp; &nbsp; &nbsp; PATH=\/usr\/local\/mysql\/bin:\/usr\/local\/mysql\/lib:$PATH<\/p>\n\n\n\n<p>&nbsp; &nbsp; &nbsp; export PATH<\/p>\n\n\n\n<p>source \/etc\/profile &nbsp;<\/p>\n\n\n\n<p>\u542f\u52a8mysql\u670d\u52a1\u5e76\u52a0\u5165\u5f00\u673a\u81ea\u542f\u52a8(\u53ef\u9009\u8fd9\u4e2a\u6b65\u9aa4\uff0c\u4ee5\u540e\u53ef\u4ee5\u81ea\u5df1\u542f\u52a8\u7684)\uff1a<br>\nservice mysqld start&nbsp;<br>\nchkconfig &#8211;level 35 mysqld on<\/p>\n\n\n\n<p>\u68c0\u67e5mysql\u670d\u52a1\u662f\u5426\u542f\u52a8\uff1a<br>\nnetstat -tulnp | grep 3306 &nbsp;&nbsp;<br>\nmysql -u root -p &nbsp;&nbsp;<\/p>\n\n\n\n<p>\u4fee\u6539MySQL\u7528\u6237root\u7684\u5bc6\u7801\uff1a<br>\nmysqladmin -u root password &#8216;123456&#8217;<\/p>\n\n\n\n<p>\u6ce8\uff1a\u4e5f\u53ef\u8fd0\u884c\u5b89\u5168\u8bbe\u7f6e\u811a\u672c\uff0c\u4fee\u6539MySQL\u7528\u6237root\u7684\u5bc6\u7801\uff0c\u540c\u65f6\u53ef\u7981\u6b62root\u8fdc\u7a0b\u8fde\u63a5\uff0c\u79fb\u9664test\u6570\u636e\u5e93\u548c\u533f\u540d\u7528\u6237\uff1a<br>\n\/usr\/local\/mysql\/bin\/mysql_secure_installation &nbsp;<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p>MySQL\u95ee\u9898\u89e3\u51b3\uff1a-bash:mysql:command not found &nbsp;<br>\n\u56e0\u4e3amysql\u547d\u4ee4\u7684\u8def\u5f84\u5728\/usr\/local\/mysql\/bin\u4e0b\u9762,\u6240\u4ee5\u4f60\u76f4\u63a5\u4f7f\u7528mysql\u547d\u4ee4\u65f6, &nbsp;<br>\n\u7cfb\u7edf\u5728\/usr\/bin\u4e0b\u9762\u67e5\u6b64\u547d\u4ee4,\u6240\u4ee5\u627e\u4e0d\u5230\u4e86 &nbsp;&nbsp;<br>\n&nbsp; &nbsp;\u89e3\u51b3\u529e\u6cd5\u662f\uff1a &nbsp;<br>\n&nbsp;ln -s \/usr\/local\/mysql\/bin\/mysql \/usr\/bin\u3000\u505a\u4e2a\u94fe\u63a5\u5373\u53ef&nbsp;<\/p>\n\n\n\n<p>ERROR 2002 (HY000): Can&#8217;t connect to local MySQL server through socket &#8216;\/usr\/local\/mysql\/mysql.sock&#8217; (2)<br>\n1\u3001\u5148\u67e5\u770b \/etc\/rc.d\/init.d\/mysqld status \u770b\u770bmysql\u670d\u52a1\u662f\u5426\u5df2\u7ecf\u542f\u52a8.<br>\n\u53e6\u5916\u770b\u770b\u662f\u4e0d\u662f\u6743\u9650\u95ee\u9898.<br>\n$service mysqld start<br>\n\u6216<br>\n$service mysql start<br>\n&#8211;\u6211\u5f00\u59cb\u9047\u5230\u7684\u5c31\u662f\u56e0\u4e3a\u670d\u52a1\u6ca1\u542f\u52a8\uff0c\u56e0\u4e3a\u7b2c\u4e00\u6b21\u73a9mysql\u4e0d\u662f\u5f88\u719f\u6089\uff0c\u5475\u5475\u3002<\/p>\n\n\n\n<p>2\u3001\u786e\u5b9a\u4f60\u7684mysql.sock\u662f\u4e0d\u662f\u5728\u90a3\u4e2a\u4f4d\u7f6e\uff0c<br>\nmysql -u \u4f60\u7684mysql\u7528\u6237\u540d -p -S \/var\/lib\/mysql\/mysql.sock<\/p>\n\n\n\n<p>\u5982\u679c\u9519\u5566\uff0c\u5c31\u4fee\u6539\/etc\/my.cnf:<br>\n<\/p>\n\n\n<p>[client]<\/p>\n\n\n\n<p>\nsocket = \/var\/lib\/mysql\/mysql.sock\n<\/p>\n\n\n<p>[mysqld]<\/p>\n\n\n\n<p>\nsocket = \/var\/lib\/mysql\/mysql.sock\n<\/p>\n\n\n\n<p>3\u3001\u5982\u679c\u662f\u6743\u9650\u95ee\u9898\uff0c\u5219\u5148\u6539\u53d8\u6743\u9650 #chown -R mysql:mysql \/var\/lib\/mysql<\/p>\n\n\n<p>[root@localhost ~]<\/p>\n\n\n\n<p># \/etc\/init.d\/mysqld start<br>\n\u542f\u52a8 MySQL\uff1a [ \u786e\u5b9a ]<br><\/p>\n\n\n<p>[root@localhost ~]<\/p>\n\n\n\n<p># mysql -uroot -p\n<\/p>\n\n\n\n<p>ERROR 2002 (HY000): Can&#8217;t connect to local MySQL server through socket &#8216;\/var\/lib\/mysql\/mysql.sock&#8217; (2)<br>\n\u539f\u56e0\u662f\uff0c\/var\/lib\/mysql \u7684\u8bbf\u95ee\u6743\u9650\u95ee\u9898\u3002<\/p>\n\n\n\n<p>shell&gt; chown -R mysql:mysql \/var\/lib\/mysql<\/p>\n\n\n\n<p>\u63a5\u7740\u542f\u52a8\u670d\u52a1\u5668<\/p>\n\n\n\n<p>shell&gt; \/etc\/init.d\/mysql start<\/p>\n\n\n\n<p>\u670d\u52a1\u5668\u6b63\u5e38\u542f\u52a8\u540e\u5bdf\u770b \/var\/lib\/mysql \u81ea\u52a8\u751f\u6210mysql.sock\u6587\u4ef6\u3002<\/p>\n\n\n\n<p>4\u3001\u4fee\u6539\/etc\/my.conf:<br>\n<\/p>\n\n\n<p>[mysqld]<\/p>\n\n\n\n<p>\ndatadir=\/usr\/local\/mysql\/data<br>\nsocket=\/var\/lib\/mysql\/mysql.sock\n<\/p>\n\n\n<p>[mysql.server]<\/p>\n\n\n\n<p>\nuser=mysql<br>\nbasedir=\/usr\/local\/mysql\n<\/p>\n\n\n\n<p>If there is not currently a section called [client], add one at the bottom of the file and copy the socket= line under the [mysqld] section such as:<\/p>\n\n\n<p>[client]<\/p>\n\n\n\n<p>\nsocket=\/var\/lib\/mysql\/mysql.sock\n<\/p>\n\n\n\n<p>\u5982\u679c\u53d1\u73b0\u95ee\u9898\u4f9d\u65e7\uff0c\u5c1d\u8bd5\u8fd0\u884c\/etc\/init.d\/mysql start\u62a5\u9519\uff1aStarting MySQLCouldn&#8217;t find MySQL manager or server<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u5982\u662fmysqld\u670d\u52a1\u6ca1\u542f\uff0c\u8fd0\u884c\/usr\/local\/mysql\/bin\/mysqld_safe &amp;<\/h2>\n\n\n\n<p>\u4f5c\u8005\uff1a\u5154\u5b50ming_ <br>\n\u6765\u6e90\uff1aCSDN <br>\n\u539f\u6587\uff1ahttps:\/\/blog.csdn.net\/hxmcnu\/article\/details\/53269102 <br>\n\u7248\u6743\u58f0\u660e\uff1a\u672c\u6587\u4e3a\u535a\u4e3b\u539f\u521b\u6587\u7ae0\uff0c\u8f6c\u8f7d\u8bf7\u9644\u4e0a\u535a\u6587\u94fe\u63a5\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"<p>centos mysql-5.6.34 \u7f16\u8bd1\u5b89\u88c5\uff1a \u51c6\u5907\u5de5\u4f5c\uff1a yum install gcc gcc-c++<\/p>\n<div class=\"more-link\">\n\t\t\t\t <a href=\"http:\/\/www.inhhh.com\/blog\/?p=359\" class=\"link-btn theme-btn\"><span>Read More <\/span> <i class=\"fa fa-caret-right\"><\/i><\/a>\n\t\t\t<\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-359","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/359","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=359"}],"version-history":[{"count":3,"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/359\/revisions"}],"predecessor-version":[{"id":638,"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/359\/revisions\/638"}],"wp:attachment":[{"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=359"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=359"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=359"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}