{"id":8559,"date":"2018-11-12T10:37:21","date_gmt":"2018-11-12T02:37:21","guid":{"rendered":"https:\/\/4563.org\/?p=8559"},"modified":"2018-11-12T10:37:40","modified_gmt":"2018-11-12T02:37:40","slug":"centos-7-x-6-x-64%e4%bd%8d-32%e4%bd%8d%e7%b3%bb%e7%bb%9f%e5%ae%89%e8%a3%85mysql%e6%95%b0%e6%8d%ae%e5%ba%93","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=8559","title":{"rendered":"centos 7.x\/6.x 64\u4f4d\/32\u4f4d\u7cfb\u7edf\u5b89\u88c5mysql\u6570\u636e\u5e93"},"content":{"rendered":"<article class=\"article-content\">\u559c\u6b22\u6298\u817e\u5b89\u88c5mysql\u6570\u636e\u5e93\u7684\u53ef\u4ee5\u770b\u770b<\/p>\n<p>\u7b2c\u4e00\u6b65\u3000\u3000\u83b7\u53d6\u5b89\u88c5\u6587\u4ef6<\/p>\n<p>wget -i -c http:\/\/dev.mysql.com\/get\/mysql57-community-release-el7-10.noarch.rpm<\/p>\n<p>\u7b2c\u4e8c\u6b65\u3000\u3000\u76f4\u63a5\u5b89\u88c5<\/p>\n<p>yum -y install mysql57-community-release-el7-10.noarch.rpm<\/p>\n<p>yum -y install mysql-community-server<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-11438\" title=\"centos 7.x\/6.x  64\u4f4d\/32\u4f4d\u7cfb\u7edf \u5982\u4f55\u5b89\u88c5mysql\u6570\u636e\u5e93\" src=\"https:\/\/4563.org\/wp-content\/uploads\/2018\/11\/845074-20180206161357795-898894867.png\" sizes=\"(max-width: 1280px) 100vw, 1280px\" srcset=\"https:\/\/4563.org\/wp-content\/uploads\/2018\/11\/845074-20180206161357795-898894867.png 1280w, https:\/\/www.xqblog.com\/wp-content\/uploads\/2018\/11\/845074-20180206161357795-898894867-300x32.png 300w, https:\/\/www.xqblog.com\/wp-content\/uploads\/2018\/11\/845074-20180206161357795-898894867-1024x108.png 1024w\" alt=\"centos 7.x\/6.x  64\u4f4d\/32\u4f4d\u7cfb\u7edf \u5982\u4f55\u5b89\u88c5mysql\u6570\u636e\u5e93\" width=\"1280\" height=\"135\" data-tag=\"bdshare\" \/><\/p>\n<p>\u5b89\u88c5\u5c06\u4f1a\u82b1\u8d39\u4e00\u5b9a\u7684\u65f6\u95f4\uff0c\u5177\u4f53\u770b\u6240\u4f7f\u7528\u670d\u52a1\u5668\u7684\u7f51\u7edc\u8d28\u91cf\u3001CPU\u8fd0\u884c\u901f\u5ea6\u4ee5\u53caIO\u6027\u80fd\u5747\u6709\u5f88\u5927\u7684\u5173\u7cfb\uff0c\u6240\u4ee5\u65f6\u95f4\u957f\u77ed\u4e0d\u4e00\uff1b<\/p>\n<p>\u7b2c\u4e09\u6b65\u3000\u3000\u542f\u52a8mysql<\/p>\n<p>\u542f\u52a8\uff1asystemctl start\u00a0 mysqld.service<\/p>\n<p>\u67e5\u770b\uff1asystemctl status mysqld.service<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-11439\" title=\"centos 7.x\/6.x  64\u4f4d\/32\u4f4d\u7cfb\u7edf \u5982\u4f55\u5b89\u88c5mysql\u6570\u636e\u5e93\" src=\"https:\/\/4563.org\/wp-content\/uploads\/2018\/11\/845074-20180206161645466-882332378.png\" sizes=\"(max-width: 1280px) 100vw, 1280px\" srcset=\"https:\/\/4563.org\/wp-content\/uploads\/2018\/11\/845074-20180206161645466-882332378.png 1280w, https:\/\/www.xqblog.com\/wp-content\/uploads\/2018\/11\/845074-20180206161645466-882332378-300x41.png 300w, https:\/\/www.xqblog.com\/wp-content\/uploads\/2018\/11\/845074-20180206161645466-882332378-1024x139.png 1024w\" alt=\"centos 7.x\/6.x  64\u4f4d\/32\u4f4d\u7cfb\u7edf \u5982\u4f55\u5b89\u88c5mysql\u6570\u636e\u5e93\" width=\"1280\" height=\"174\" data-tag=\"bdshare\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>\u7b2c\u56db\u6b65\u3000\u3000\u8bbe\u7f6e\u5bc6\u7801<\/p>\n<p>\u67e5\u8be2\u521d\u59cb\u5bc6\u7801\uff1agrep \u201cpassword\u201d \/var\/log\/mysqld.log<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-11440\" title=\"centos 7.x\/6.x  64\u4f4d\/32\u4f4d\u7cfb\u7edf \u5982\u4f55\u5b89\u88c5mysql\u6570\u636e\u5e93\" src=\"https:\/\/4563.org\/wp-content\/uploads\/2018\/11\/845074-20180206161937029-1870059279.png\" sizes=\"(max-width: 1106px) 100vw, 1106px\" srcset=\"https:\/\/4563.org\/wp-content\/uploads\/2018\/11\/845074-20180206161937029-1870059279.png 1106w, https:\/\/www.xqblog.com\/wp-content\/uploads\/2018\/11\/845074-20180206161937029-1870059279-300x12.png 300w, https:\/\/www.xqblog.com\/wp-content\/uploads\/2018\/11\/845074-20180206161937029-1870059279-1024x43.png 1024w\" alt=\"centos 7.x\/6.x  64\u4f4d\/32\u4f4d\u7cfb\u7edf \u5982\u4f55\u5b89\u88c5mysql\u6570\u636e\u5e93\" width=\"1106\" height=\"46\" data-tag=\"bdshare\" \/><\/p>\n<p>\u767b\u5f55\uff1amysql -uroot -p<\/p>\n<p>\u8f93\u5165\u521d\u59cb\u5bc6\u7801\u5c31\u53ef\u4ee5\u767b\u5f55\u3002<\/p>\n<p>\u4fee\u6539\u5bc6\u7801\u751f\u6210\u89c4\u5219\uff0c\u5141\u8bb8\u751f\u6210\u7b80\u5355\u5bc6\u7801\uff1a<\/p>\n<p>set global validate_password_policy=0;<\/p>\n<p>set global validate_password_length=1;<\/p>\n<p>\u5982\u4e0b\u6267\u884c\uff1a<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-11441\" title=\"centos 7.x\/6.x  64\u4f4d\/32\u4f4d\u7cfb\u7edf \u5982\u4f55\u5b89\u88c5mysql\u6570\u636e\u5e93\" src=\"https:\/\/4563.org\/wp-content\/uploads\/2018\/11\/845074-20180206162138966-819910774.png\" sizes=\"(max-width: 463px) 100vw, 463px\" srcset=\"https:\/\/4563.org\/wp-content\/uploads\/2018\/11\/845074-20180206162138966-819910774.png 463w, https:\/\/www.xqblog.com\/wp-content\/uploads\/2018\/11\/845074-20180206162138966-819910774-300x77.png 300w\" alt=\"centos 7.x\/6.x  64\u4f4d\/32\u4f4d\u7cfb\u7edf \u5982\u4f55\u5b89\u88c5mysql\u6570\u636e\u5e93\" width=\"463\" height=\"119\" data-tag=\"bdshare\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>\u8bbe\u7f6eroot\u7528\u6237\u5bc6\u7801\uff1a<\/p>\n<p>ALTER USER \u2018root\u2019@\u2019localhost\u2019 IDENTIFIED BY \u2018root\u2019;<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-11442\" title=\"centos 7.x\/6.x  64\u4f4d\/32\u4f4d\u7cfb\u7edf \u5982\u4f55\u5b89\u88c5mysql\u6570\u636e\u5e93\" src=\"https:\/\/4563.org\/wp-content\/uploads\/2018\/11\/845074-20180206162244170-1255364475.png\" sizes=\"(max-width: 569px) 100vw, 569px\" srcset=\"https:\/\/4563.org\/wp-content\/uploads\/2018\/11\/845074-20180206162244170-1255364475.png 569w, https:\/\/www.xqblog.com\/wp-content\/uploads\/2018\/11\/845074-20180206162244170-1255364475-300x35.png 300w\" alt=\"centos 7.x\/6.x  64\u4f4d\/32\u4f4d\u7cfb\u7edf \u5982\u4f55\u5b89\u88c5mysql\u6570\u636e\u5e93\" width=\"569\" height=\"66\" data-tag=\"bdshare\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>\u5141\u8bb8\u5176\u4ed6\u670d\u52a1\u5668\u8bbf\u95ee\uff1a<\/p>\n<p>\u5207\u6362\u6570\u636e\u5e93\uff1ause mysql<\/p>\n<p>\u8bbe\u7f6e\u5141\u8bb8\u8bbf\u95ee\uff1aupdate user set host=\u2019%\u2019 where host=\u2019localhost\u2019 and user=\u2019root\u2019;<\/p>\n<p>\u5237\u65b0\uff1aflush privileges;<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-11443\" title=\"centos 7.x\/6.x  64\u4f4d\/32\u4f4d\u7cfb\u7edf \u5982\u4f55\u5b89\u88c5mysql\u6570\u636e\u5e93\" src=\"https:\/\/4563.org\/wp-content\/uploads\/2018\/11\/845074-20180206180029357-932549660.png\" sizes=\"(max-width: 1280px) 100vw, 1280px\" srcset=\"https:\/\/4563.org\/wp-content\/uploads\/2018\/11\/845074-20180206180029357-932549660.png 1280w, https:\/\/www.xqblog.com\/wp-content\/uploads\/2018\/11\/845074-20180206180029357-932549660-300x91.png 300w, https:\/\/www.xqblog.com\/wp-content\/uploads\/2018\/11\/845074-20180206180029357-932549660-1024x310.png 1024w\" alt=\"centos 7.x\/6.x  64\u4f4d\/32\u4f4d\u7cfb\u7edf \u5982\u4f55\u5b89\u88c5mysql\u6570\u636e\u5e93\" width=\"1280\" height=\"388\" data-tag=\"bdshare\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>\u8fd8\u662f\u6bd4\u8f83\u5bb9\u6613\u7684\uff0c\u559c\u6b22\u7684\u7528\u6237\u53ef\u4ee5\u5c1d\u8bd5\u4e00\u4e0b\u5427\u3002<\/p>\n<\/article>\n","protected":false},"excerpt":{"rendered":"<p>\u559c\u6b22\u6298\u817e\u5b89\u88c5mysql\u6570\u636e\u5e93\u7684\u53ef\u4ee5&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"_links":{"self":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/8559"}],"collection":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8559"}],"version-history":[{"count":1,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/8559\/revisions"}],"predecessor-version":[{"id":8566,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/8559\/revisions\/8566"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8559"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8559"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8559"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}