{"id":917,"date":"2020-12-02T18:58:49","date_gmt":"2020-12-02T10:58:49","guid":{"rendered":"http:\/\/prayerlaputa.com\/?p=917"},"modified":"2020-12-02T18:58:49","modified_gmt":"2020-12-02T10:58:49","slug":"centos%e4%b8%8b%e5%a6%82%e4%bd%95%e5%90%af%e5%8a%a8mysql%e5%a4%9a%e5%ae%9e%e4%be%8b","status":"publish","type":"post","link":"http:\/\/prayerlaputa.com\/?p=917","title":{"rendered":"centos\u4e0b\u5982\u4f55\u542f\u52a8mysql\u591a\u5b9e\u4f8b"},"content":{"rendered":"<p class=\"md-end-block md-p\"><span class=\"md-plain md-expand\">mysql\u5b89\u88c5\u6709\u591a\u79cd\u65b9\u5f0f\uff1a<\/span><\/p>\n<blockquote>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u5177\u4f53\u8be6\u7ec6\u53c2\u8003\u5b98\u7f51 \uff08<\/span><span class=\"md-link md-pair-s\" spellcheck=\"false\"><a href=\"https:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/installing.html\">https:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/installing.html<\/a><\/span><span class=\"md-plain\">\uff09<\/span><\/p>\n<ul class=\"ul-list\" data-mark=\"-\">\n<li class=\"md-list-item\">\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">mysql\u7684\u5b89\u88c5\u65b9\u6cd5\u6709\u591a\u79cd\uff0c\u5982\u4e8c\u8fdb\u5236\u5b89\u88c5\u3001\u6e90\u7801\u7f16\u8bd1\u5b89\u88c5\u3001yum\u5b89\u88c5;<\/span><\/p>\n<\/li>\n<li class=\"md-list-item\">\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">yum\u5b89\u88c5\u90fd\u662f\u9ed8\u8ba4\u8def\u5f84\uff0c\u4e0d\u5229\u4e8e\u540e\u671f\u7ef4\u62a4\uff0c\u5b89\u88c5\u76f8\u5bf9\u7b80\u5355\uff1b<\/span><\/p>\n<\/li>\n<li class=\"md-list-item\">\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u6e90\u7801\u5b89\u88c5\u7f16\u8bd1\u7684\u8fc7\u7a0b\u6bd4\u8f83\u957f\uff0c\u82e5\u6ca1\u6709\u5bf9\u6e90\u7801\u8fdb\u884c\u4fee\u6539\u4e14\u8981\u6c42\u4f7f\u7528mysql\u8f83\u9ad8\u7248\u672c\uff1b<\/span><\/p>\n<\/li>\n<\/ul>\n<\/blockquote>\n<p><!--more--><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u5efa\u8bae\u4f7f\u7528\u4e8c\u8fdb\u5236\u5b89\u88c5\uff0c\u6bd4\u8f83\u65b9\u4fbf\u540e\u671f\u7ef4\u62a4\u3002\u672c\u6587\u5c31\u662f\u91c7\u7528\u8fd9\u79cd\u65b9\u5f0f\u542f\u52a8\u591a\u4e2a\u5b9e\u4f8b\u3002<\/span><\/p>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u672c\u6587\u5728centos 7.5\u4e0b\u8fdb\u884c\u64cd\u4f5c\u3002<\/span><\/p>\n<h2 class=\"md-end-block md-heading\"><span class=\"md-plain\">\u51c6\u5907\u5de5\u4f5c<\/span><\/h2>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e0b\u8f7dmysql \u538b\u7f29\u5305\uff0c\u6ce8\u610f\u9700\u8981\u4e0b\u8f7d\u4e8c\u8fdb\u5236\u5305\u3002\u4e0b\u8f7d\u5730\u5740<\/span><\/p>\n<ul class=\"ul-list\" data-mark=\"-\">\n<li class=\"md-list-item\">\n<p class=\"md-end-block md-p\"><span class=\"md-link md-pair-s\" spellcheck=\"false\"><a href=\"https:\/\/dev.mysql.com\/downloads\/mysql\/\">https:\/\/dev.mysql.com\/downloads\/mysql\/<\/a><\/span><span class=\"md-plain\"> \u76ee\u524d\u53ea\u63d0\u4f9bmysql 8\u7684\u4e0b\u8f7d<\/span><\/p>\n<\/li>\n<li class=\"md-list-item md-focus-container\">\n<p class=\"md-end-block md-p md-focus\"><span class=\"md-link md-pair-s md-expand\" spellcheck=\"false\"><a href=\"https:\/\/downloads.mysql.com\/archives\/community\/\">https:\/\/downloads.mysql.com\/archives\/community\/<\/a><\/span><span class=\"md-plain\"> mysql\u5386\u53f2\u7248\u672c\u4e0b\u8f7d\uff0c\u5982\u679c\u6ca1\u6709\u5386\u53f2\u5305\u88b1\uff0c\u5f53\u7136\u9009\u75288\u6700\u597d\uff0c\u4f46\u6c42\u7a33\u7684\u8bdd\u5efa\u8bae\u5148\u4f7f\u7528mysql 5.7\uff0c\u5730\u5740\uff1a<\/span><span class=\"md-link md-pair-s\" spellcheck=\"false\"><a href=\"https:\/\/cdn.mysql.com\/\/Downloads\/MySQL-5.7\/mysql-5.7.32-el7-x86_64.tar.gz\">https:\/\/cdn.mysql.com\/\/Downloads\/MySQL-5.7\/mysql-5.7.32-el7-x86_64.tar.gz<\/a><\/span><\/p>\n<\/li>\n<\/ul>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">centos \u4e0b\u53ef\u4ee5\u4f7f\u7528\u5982\u4e0b\u547d\u4ee4\uff1a<\/span><\/p>\n<pre class=\"md-fences md-end-block ty-contain-cm modeLoaded\" lang=\"shell\" spellcheck=\"false\"><span role=\"presentation\"><span class=\"cm-builtin\">wget<\/span> https:\/\/cdn.mysql.com\/\/Downloads\/MySQL-5.7\/mysql-5.7.32-el7-x86_64.tar.gz<\/span><\/pre>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u89e3\u538b\uff0c\u79fb\u52a8\u5230\/usr\/local\/\u6587\u4ef6\u5939\u4e0b\uff1a<\/span><\/p>\n<pre class=\"md-fences md-end-block ty-contain-cm modeLoaded\" lang=\"shell\" spellcheck=\"false\"><span role=\"presentation\">tar <span class=\"cm-attribute\">-zxvf<\/span> mysql-5.7.32-el7-x86_64.tar.gz<\/span>\r\n<span role=\"presentation\"><span class=\"cm-comment\"># \u53ef\u4ee5\u987a\u624b\u7ed9\u6587\u4ef6\u5939\u6539\u4e2a\u540d\u5b57,\u6bd4\u5982\u6211\u5c31\u5df2\u7ecf\u6539\u6210\u4e86mysql\uff0c\u6240\u4ee5\u4e0b\u9762\u5927\u5bb6\u4f1a\u770b\u5230\u6211\u7684\u76ee\u5f55\u662f\/usr\/local\/mysql<\/span><\/span>\r\n<span role=\"presentation\"><span class=\"cm-builtin\">mv<\/span> mysql-5.7.32-el7-x86_64 \/usr\/local\/<\/span><\/pre>\n<h2 class=\"md-end-block md-heading\"><span class=\"md-plain\">\u521d\u59cb\u5316\u7528\u6237\u7ec4\u4ee5\u53ca\u7528\u6237<\/span><\/h2>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u521b\u5efa\u4e00\u4e2amysql\u7528\u6237\u7ec4\u53ca\u7528\u6237\uff0c\u4e14\u8fd9\u4e2a\u7528\u6237\u662f\u4e0d\u53ef\u767b\u5f55\u7684<\/span> <span class=\"md-plain\">\u521b\u5efa\u7528\u6237\u7ec4\uff1agroupadd mysql<\/span> <span class=\"md-plain\">\u521b\u5efa\u4e0d\u53ef\u767b\u5f55\u7528\u6237\uff1auseradd -g mysql -s \/sbin\/nologin -d \/opt\/mysql mysql<\/span> <span class=\"md-plain\">\u67e5\u770b\u4e0b\u521b\u5efa\u540e\u7684\u7528\u6237\u4fe1\u606f\uff1aid msyql<\/span><\/p>\n<pre class=\"md-fences md-end-block ty-contain-cm modeLoaded\" lang=\"text\" spellcheck=\"false\"><span role=\"presentation\">id mysql<\/span>\r\n<span role=\"presentation\">uid=501(mysql) gid=501(mysql) groups=501(mysql)<\/span><\/pre>\n<h2 class=\"md-end-block md-heading\"><span class=\"md-plain\">\u521b\u5efa\u76f8\u5173\u76ee\u5f55<\/span><\/h2>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u6b64\u5904\u6211\u9009\u62e9\u4f7f\u7528\u5728\/data\/mysql\u6587\u4ef6\u5939\u4e0b\u4fdd\u5b58\u6570\u636e\u3001\u65e5\u5fd7\uff0c\u56e0\u6b64\u6309\u5982\u4e0b\u7ed3\u6784\u521b\u5efa\u76ee\u5f55\uff08\u6211\u6253\u7b97\u542f\u52a82\u4e2a\u5b9e\u4f8b\uff09\uff0c\u547d\u4ee4\u7565\u53bb\uff1a<\/span><\/p>\n<pre class=\"md-fences md-end-block ty-contain-cm modeLoaded\" lang=\"text\" spellcheck=\"false\"><span role=\"presentation\">-data<\/span>\r\n<span role=\"presentation\">-- mysql<\/span>\r\n<span role=\"presentation\"> \u00a0  |-- mysql_3307<\/span>\r\n<span role=\"presentation\"> \u00a0 \u00a0 \u00a0  |-- data<\/span>\r\n<span role=\"presentation\"> \u00a0 \u00a0 \u00a0  |-- log<\/span>\r\n<span role=\"presentation\"> \u00a0 \u00a0 \u00a0  `-- tmp<\/span>\r\n<span role=\"presentation\"> \u00a0  `-- mysql_3308<\/span>\r\n<span role=\"presentation\"> \u00a0 \u00a0 \u00a0  |-- data<\/span>\r\n<span role=\"presentation\"> \u00a0 \u00a0 \u00a0  |-- log<\/span>\r\n<span role=\"presentation\"> \u00a0 \u00a0 \u00a0  `-- tmp<\/span>\r\n<span role=\"presentation\">\u200b<\/span><\/pre>\n<p class=\"md-end-block md-p\">\n<h2 class=\"md-end-block md-heading\"><span class=\"md-plain\">\u66f4\u6539\u76ee\u5f55\u6743\u9650<\/span><\/h2>\n<pre class=\"md-fences md-end-block ty-contain-cm modeLoaded\" lang=\"shell\" spellcheck=\"false\"><span role=\"presentation\"><span class=\"cm-builtin\">chown<\/span> <span class=\"cm-attribute\">-R<\/span> mysql:mysql \/data\/mysql\/ \u00a0<\/span>\r\n<span role=\"presentation\"><span class=\"cm-builtin\">chown<\/span> <span class=\"cm-attribute\">-R<\/span> mysql:mysql \/usr\/local\/mysql\/ \u00a0<\/span><\/pre>\n<h2 class=\"md-end-block md-heading\"><span class=\"md-plain\">\u6dfb\u52a0\u73af\u5883\u53d8\u91cf<\/span><\/h2>\n<pre class=\"md-fences md-end-block ty-contain-cm modeLoaded\" lang=\"shell\" spellcheck=\"false\"><span role=\"presentation\"><span class=\"cm-builtin\">echo<\/span> <span class=\"cm-string\">'export PATH=$PATH:\/usr\/local\/mysql\/bin'<\/span> &gt;&gt;  \/etc\/profile \u00a0<\/span>\r\n<span role=\"presentation\"><span class=\"cm-builtin\">source<\/span> \/etc\/profile \u00a0 <\/span><\/pre>\n<h2 class=\"md-end-block md-heading\"><span class=\"md-plain\">\u6dfb\u52a0\u914d\u7f6e\u6587\u4ef6<\/span><\/h2>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u627e\u4e00\u4e2amysql\u914d\u7f6e\u6587\u4ef6my.cnf\uff0c\u5982\u679c\u6ca1\u6709\u53ef\u4ee5\u624b\u5de5\u521b\u5efa\uff0c\u4f4d\u7f6e\u653e\u5728\uff1a<\/span><\/p>\n<pre class=\"md-fences md-end-block ty-contain-cm modeLoaded\" lang=\"shell\" spellcheck=\"false\"><span role=\"presentation\">\/etc\/my_3307.cnf<\/span><\/pre>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u4e0b\u9762\u7ed9\u51fa\u4e00\u4e2amysql\u914d\u7f6e\u6587\u4ef6\u53c2\u8003\uff0c\u8bf7\u6309\u9700\u4fee\u6539\uff1a<\/span><\/p>\n<pre class=\"md-fences md-end-block ty-contain-cm modeLoaded\" lang=\"text\" spellcheck=\"false\"><span role=\"presentation\"># my_3307.cnf<\/span>\r\n<span role=\"presentation\"># For advice on how to change settings please see<\/span>\r\n<span role=\"presentation\"># http:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/server-configuration-defaults.html<\/span>\r\n<span role=\"presentation\">\u200b<\/span>\r\n<span role=\"presentation\">[mysqld]<\/span>\r\n<span role=\"presentation\">#<\/span>\r\n<span role=\"presentation\"># Remove leading # and set to the amount of RAM for the most important data<\/span>\r\n<span role=\"presentation\"># cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.<\/span>\r\n<span role=\"presentation\"># innodb_buffer_pool_size = 128M<\/span>\r\n<span role=\"presentation\">#<\/span>\r\n<span role=\"presentation\"># Remove leading # to turn on a very important data integrity option: logging<\/span>\r\n<span role=\"presentation\"># changes to the binary log between backups.<\/span>\r\n<span role=\"presentation\"># log_bin<\/span>\r\n<span role=\"presentation\">#<\/span>\r\n<span role=\"presentation\"># Remove leading # to set options mainly useful for reporting servers.<\/span>\r\n<span role=\"presentation\"># The server defaults are faster for transactions and fast SELECTs.<\/span>\r\n<span role=\"presentation\"># Adjust sizes as needed, experiment to find the optimal values.<\/span>\r\n<span role=\"presentation\"># join_buffer_size = 128M<\/span>\r\n<span role=\"presentation\"># sort_buffer_size = 2M<\/span>\r\n<span role=\"presentation\"># read_rnd_buffer_size = 2M<\/span>\r\n<span role=\"presentation\">port=3307<\/span>\r\n<span role=\"presentation\">basedir=\/usr\/local\/mysql-5.7.32<\/span>\r\n<span role=\"presentation\">datadir=\/data\/mysql\/mysql_3307\/data<\/span>\r\n<span role=\"presentation\">socket=\/data\/mysql\/mysql_3307\/mysql.sock<\/span>\r\n<span role=\"presentation\">server_id=3307<\/span>\r\n<span role=\"presentation\">\u200b<\/span>\r\n<span role=\"presentation\">sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES<\/span>\r\n<span role=\"presentation\">\u200b<\/span>\r\n<span role=\"presentation\"># Disabling symbolic-links is recommended to prevent assorted security risks<\/span>\r\n<span role=\"presentation\">symbolic-links=0<\/span>\r\n<span role=\"presentation\">log-output=file<\/span>\r\n<span role=\"presentation\">slow_query_log=1<\/span>\r\n<span role=\"presentation\">long_query_time=1<\/span>\r\n<span role=\"presentation\">slow_query_log_file = \/data\/mysql\/mysql_3307\/log\/slow.log<\/span>\r\n<span role=\"presentation\">log-error=\/data\/mysql\/mysql_3307\/log\/mysqld.log<\/span>\r\n<span role=\"presentation\">log-bin = \/data\/mysql\/mysql_3307\/log\/mysql3307_bin<\/span>\r\n<span role=\"presentation\">binlog-format=Row<\/span>\r\n<span role=\"presentation\">pid-file=\/var\/run\/mysqld\/mysqld-3307.pid<\/span>\r\n<span role=\"presentation\">collation-server = utf8_unicode_ci<\/span>\r\n<span role=\"presentation\">init-connect='SET NAMES utf8'<\/span>\r\n<span role=\"presentation\">character-set-server = utf8<\/span>\r\n<span role=\"presentation\">language =\/usr\/local\/mysql-5.7.32\/share\/english<\/span>\r\n<span role=\"presentation\">\u200b<\/span>\r\n<span role=\"presentation\">[client]<\/span>\r\n<span role=\"presentation\">default-character-set=utf8<\/span>\r\n<span role=\"presentation\">\u200b<\/span>\r\n<span role=\"presentation\">[mysql]<\/span>\r\n<span role=\"presentation\">default-character-set=utf8<\/span>\r\n<span role=\"presentation\">\u200b<\/span><\/pre>\n<p class=\"md-end-block md-p\">\n<h2 class=\"md-end-block md-heading\"><span class=\"md-plain\">\u542f\u52a8mysql<\/span><\/h2>\n<pre class=\"md-fences mock-cm md-end-block\" lang=\"shell\" spellcheck=\"false\">cd \/usr\/local\/mysql\/\r\n# \u6ce8\u610f\u6b64\u5904\u6307\u5b9a\u914d\u7f6e\u6587\u4ef6\u662f\u5fc5\u987b\u7684\uff0c--initialize-insecure\u662f\u5728\u521d\u59cb\u5316\u65f6\u4e0d\u7ed9root\u8bbe\u7f6e\u5bc6\u7801\uff0c\u65b9\u4fbf\u64cd\u4f5c\uff1b\u4f7f\u7528.\/bin\/mysqld --defaults-file=\/etc\/my_3307.cnf --user=mysql --initialize\u4e5f\u53ef\u4ee5\u521d\u59cb\u5316\uff0c\u6b64\u65f6\u7684\u5bc6\u7801\u4f1a\u4fdd\u5b58\u5728mysqld.log\u4e2d\r\n.\/bin\/mysqld --defaults-file=\/etc\/my_3307.cnf --user=mysql --initialize-insecure\r\n.\/bin\/mysqld --defaults-file=\/etc\/my_3307.cnf --user=mysql &amp;\r\n# \u6ce8\u610f\uff0c\u521a\u521d\u59cb\u5316\u3001\u542f\u52a8\u65f6\uff0c\u5982\u679c\u4e0d\u6307\u5b9ahost\u6216\u662f-hlocalhost\uff0c\u65e0\u6cd5\u8fde\u63a5\uff0c\u5fc5\u987b\u6307\u5b9a\u4e3a-h127.0.0.1\u624d\u80fd\u8fde\u63a5\u3002\u5e76\u4e14\u6b64\u5904\u6ce8\u610f\u4f7f\u7528-P\u6307\u5b9a\u7aef\u53e3\uff0c\u6bd5\u7adf\u6211\u4eec\u662f\u8981\u542f\u52a8\u591a\u4e2a\u5b9e\u4f8b\uff0c\u7aef\u53e3\u522b\u5f04\u4e71\u3002\r\nmysql -P3307 -uroot -h127.0.0.1<\/pre>\n<h2 class=\"md-end-block md-heading\"><span class=\"md-plain\">\u8bbe\u7f6e\u8fdc\u7a0b\u8fde\u63a5mysql<\/span><\/h2>\n<pre class=\"md-fences mock-cm md-end-block\" lang=\"mysql\" spellcheck=\"false\">GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;\r\n\r\nFLUSH PRIVILEGES;<\/pre>\n<p class=\"md-end-block md-p\"><span class=\"md-plain\">\u8fd9\u6837\u5c31\u80fd\u6210\u529f\u542f\u52a8\u4e00\u4e2a\u5b9e\u4f8b\uff0c\u63a5\u4e0b\u6765\u540c\u6837\u7684\u64cd\u4f5c\uff0c\u5373\u53ef\u542f\u52a8\u591a\u4e2a\u5b9e\u4f8b\u3002<\/span><\/p>\n<p class=\"md-end-block md-p\">\n<h2 class=\"md-end-block md-heading\"><span class=\"md-plain\">\u53c2\u8003\u8d44\u6599<\/span><\/h2>\n<ul class=\"ul-list\" data-mark=\"-\">\n<li class=\"md-list-item\">\n<p class=\"md-end-block md-p\"><span class=\"md-link md-pair-s\" spellcheck=\"false\"><a href=\"https:\/\/blog.51cto.com\/13799042\/2126621\">https:\/\/blog.51cto.com\/13799042\/2126621<\/a><\/span><\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>mysql\u5b89\u88c5\u6709\u591a\u79cd\u65b9\u5f0f\uff1a \u5177\u4f53\u8be6\u7ec6\u53c2\u8003\u5b98\u7f51 \uff08https:\/\/dev.mysql.com\/doc\/refma <a href='http:\/\/prayerlaputa.com\/?p=917' class='excerpt-more'>[&#8230;]<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[63],"tags":[64,113],"_links":{"self":[{"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/posts\/917"}],"collection":[{"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=917"}],"version-history":[{"count":1,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/posts\/917\/revisions"}],"predecessor-version":[{"id":918,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/posts\/917\/revisions\/918"}],"wp:attachment":[{"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=917"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=917"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=917"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}