{"id":54,"date":"2020-01-03T01:35:17","date_gmt":"2020-01-02T17:35:17","guid":{"rendered":"http:\/\/juyingnetwork.com.cn\/?p=54"},"modified":"2022-05-21T12:55:54","modified_gmt":"2022-05-21T04:55:54","slug":"centos-7-4-%e5%ae%89%e8%a3%85mysql-5-7-19-%e7%a4%be%e5%8c%ba%e7%89%88","status":"publish","type":"post","link":"https:\/\/www.juyingnetwork.com.cn\/?p=54","title":{"rendered":"Centos 7.4 \u5b89\u88c5mysql 5.7.19 \u793e\u533a\u7248"},"content":{"rendered":"\r\n

\u56e0centos7 \u7248\u672c\u81ea\u5e26mariadb\uff0c\u53ef\u63d0\u524d\u5378\u8f7d\u3002<\/p>\r\n\r\n\r\n\r\n

1\u3001\u5b89\u88c5\u7ec4\u4ef6<\/p>\r\n\r\n\r\n

yum -y install gcc gcc-c++ gcc-g77 autoconf automake zlib* fiex* libxml* ncurses-devel libmcrypt* libtool-ltdl-devel* make libnuma1 numactl libaio<\/code> ——\u4e3b\u8981\u8981\u6709gcc\u53cagcc-c++<\/p>\n\r\n\r\n\r\n

2\u3001\u6dfb\u52a0\u7528\u6237\u7ec4\u53ca\u7528\u6237<\/p>\r\n\r\n\r\n

groupadd mysql useradd -r -g mysql -s \/bin\/false mysql<\/code><\/p>\n\r\n\r\n\r\n

3\u3001\u89e3\u538b\u4ece\u5b98\u7f51\u4e0b\u8f7d\u7684\u6700\u65b0\u7684\u7248\u672c\uff08\u672c\u4f8b\u6d89\u53ca\u7248\u672c\u4e3a\uff1amysql-5.7.19-linux-glibc2.12-x86_64.tar.gz\uff09<\/p>\r\n\r\n\r\n\r\n

 <\/p>\r\n\r\n\r\n

tar -xvf mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz -C \/usr\/local\/mysql<\/code><\/p>\n\r\n\r\n\r\n

4\u3001\u521b\u5efa\u6570\u636e\u8def\u5f84\u5e76\u7ed9\u6570\u636e\u8def\u5f84\u8bbe\u7f6e\u6743\u9650\uff08\u53ef\u6839\u636e\u81ea\u5df1\u5b89\u88c5\u60c5\u51b5\u8bbe\u7f6e\u8def\u7ecf\uff09<\/p>\r\n\r\n\r\n

mkdir -p \/home\/mysql\/data <\/code><\/p>\n

chown -R mysql mysql \/home\/mysql\/data <\/code><\/p>\n

chgrp -R mysql mysql \/home\/mysql\/data<\/code><\/p>\n\r\n\r\n\r\n

 <\/p>\r\n\r\n\r\n\r\n

5\u3001\u521d\u59cb\u5316\u6570\u636e\u5e93\u3001\u5728\/usr\/local\/mysql\u76ee\u5f55\u4e0b\u6267\u884c\uff0c\u6ce8\u610f\u4f1a\u5f97\u5230\u4e00\u4e2aroot\u7684\u521d\u59cb\u5bc6\u7801\uff0c\u8bb0\u5f55\u4e0b\u6765\u518d\u540e\u8fb9\u7528\u5230\u3002<\/p>\r\n\r\n\r\n

bin\/mysqld --initialize --basedir=\/usr\/local\/mysql --datadir=\/home\/mysql\/data --user=mysql<\/code><\/p>\n\r\n\r\n\r\n

6\u3001\u6d89\u53ca\u5b89\u5168\/usr\/local\/mysql\u76ee\u5f55\u53ef\u4ee5\u53d8\u66f4\u6743\u9650\u3002\u4e5f\u53ef\u7565\u8fc7\u3002<\/p>\r\n\r\n\r\n\r\n

7\u3001\u63a5\u4e0b\u6765\u8fdb\u5165\/usr\/local\/mysql\/support-files\/\u76ee\u5f55\u4e0b
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u67e5\u770b\u662f\u5426\u5b58\u5728my-default.cnf\u6587\u4ef6\uff0c\u5982\u679c\u5b58\u5728\u76f4\u63a5copy\u5230\/etc\/my.cnf\u6587\u4ef6\u4e2d
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\r\n\r\n\r\n

# cp -a .\/support-files\/my-default.cnf\/etc\/my.cnf<\/code><\/p>\n\r\n\r\n\r\n


\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u5982\u679c\u4e0d\u5b58\u5728my-default.cnf\u6587\u4ef6
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u5219\u5728\/etc\/\u76ee\u5f55\u4e0b\u521b\u5efamy.cnf<\/p>\r\n\r\n\r\n\r\n

\u53ef\u53c2\u8003\uff1a<\/p>\r\n\r\n\r\n

port=35060 ————-\u53d8\u9ed8\u8ba43306\u7aef\u53e3 datadir=\/home\/mysql\/data<\/p>\n

basedir=\/usr\/local\/mysql<\/p>\n

socket=\/home\/mysql\/mysql.sock<\/p>\n

symbolic-links=0<\/p>\n

explicit_defaults_for_timestamp=true ———–\u52a0\u6b64\u53ef\u89e3\u51b3timestamp\u62a5\u9519<\/p>\n

binlog-ignore-db =mysql binlog-ignore-db =information_schema binlog_format =ROW sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES interactive_timeout=31536000 ————\u52a0\u6b64\u89e3\u51b38\u5c0f\u65f6\u65e0\u6570\u636e\u65ad\u5f00\u8fde\u63a5 wait_timeout=31536000<\/p>\n

log-bin=\/home\/mysql\/data\/mysql-bin ———–\u5f00\u65e5\u5fd7\u53ef\u505a\u589e\u91cf\u5907\u4efd<\/p>\n

log-bin-index =\/home\/mysql\/data\/mysql-bin.index binlog_cache_size=32m max_binlog_cache_size=512m max_binlog_size=512m server-id=101 socket = \/home\/mysql\/mysql.sock log-error=\/var\/log\/mysql\/mysql.log pid-file=\/tmp\/mysql.pid<\/p>\n\r\n\r\n\r\n

 <\/p>\r\n\r\n\r\n\r\n

8\u3001\u5efa\u65e5\u5fd7\u6587\u4ef6\u53ca\u8def\u5f84<\/p>\r\n\r\n\r\n

touch \/var\/log\/mysql\/mysql.log <\/code><\/p>\n

chown -R mysql:mysql \/var\/log\/mysql\/mysql.log<\/code><\/p>\n\r\n\r\n\r\n

9\u3001\u5efa\u670d\u52a1\u5e76\u52a0\u5f00\u673a\u542f\u52a8<\/p>\r\n\r\n\r\n

cp \/support-files\/mysql.server \/etc\/rc.d\/init.d\/mysql <\/code><\/p>\n

chkconfig --level 35 mysql on<\/code><\/p>\n\r\n\r\n\r\n

10\u3001\u542f\u52a8<\/p>\r\n\r\n\r\n\r\n

systemctl start\u00a0 mysqld.service<\/code><\/p>\r\n\r\n\r\n\r\n

\u6216\/etc\/init.d\/mysql start<\/p>\r\n\r\n\r\n\r\n

11\u3001\u6539\u9ed8\u8ba4\u5bc6\u7801<\/p>\r\n\r\n\r\n\r\n

.\/mysql -u root -p<\/code>
Enter password:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ————\u4e3a\u521d\u59cb\u5316\u65f6\u4ea7\u751f\uff0c\u82e5\u5fd8\u8bb0\u5728\u6b64\u5904\u627e\uff1a\/root\/.mysql_secret<\/p>\r\n\r\n\r\n

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';<\/code><\/p>\n

mysql> flush privileges; mysql> quit;<\/code><\/p>\n\r\n\r\n\r\n

12\u3001\u9632\u706b\u5899\u76f8\u5173
firewall-cmd --zone=public --add-port=3306\/tcp --permanent<\/code>
firewall-cmd --reload<\/code><\/p>\r\n\r\n\r\n\r\n

\u6ce8\uff1a\u6d89\u53ca\u73af\u5883\u53d8\u91cf\uff1a
# echo \"export PATH=$PATH:\/usr\/local\/mysql\/bin\" >> \/etc\/profile<\/code>
source \/etc\/profile<\/code><\/p>\r\n","protected":false},"excerpt":{"rendered":"

\u56e0centos7 \u7248\u672c\u81ea\u5e26mariadb\uff0c\u53ef\u63d0\u524d\u5378\u8f7d\u3002 1\u3001\u5b89\u88c5\u7ec4\u4ef6 2\u3001\u6dfb\u52a0\u7528\u6237\u7ec4\u53ca\u7528\u6237 3\u3001\u89e3\u538b\u4ece\u5b98\u7f51\u4e0b\u8f7d… \u7ee7\u7eed\u9605\u8bfbCentos 7.4 \u5b89\u88c5mysql 5.7.19 \u793e\u533a\u7248<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[8],"tags":[13],"_links":{"self":[{"href":"https:\/\/www.juyingnetwork.com.cn\/index.php?rest_route=\/wp\/v2\/posts\/54"}],"collection":[{"href":"https:\/\/www.juyingnetwork.com.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.juyingnetwork.com.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.juyingnetwork.com.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.juyingnetwork.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=54"}],"version-history":[{"count":4,"href":"https:\/\/www.juyingnetwork.com.cn\/index.php?rest_route=\/wp\/v2\/posts\/54\/revisions"}],"predecessor-version":[{"id":297,"href":"https:\/\/www.juyingnetwork.com.cn\/index.php?rest_route=\/wp\/v2\/posts\/54\/revisions\/297"}],"wp:attachment":[{"href":"https:\/\/www.juyingnetwork.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=54"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.juyingnetwork.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=54"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.juyingnetwork.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=54"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}