{"id":2167,"date":"2016-02-03T20:37:12","date_gmt":"2016-02-03T12:37:12","guid":{"rendered":"http:\/\/192.168.50.160\/wordpress\/?p=2167"},"modified":"2016-02-03T23:47:57","modified_gmt":"2016-02-03T15:47:57","slug":"%e5%9c%a8centos6-7-%e5%ae%89%e8%a3%9d%e6%9c%80%e8%bf%91%e7%9a%84mysql-server","status":"publish","type":"post","link":"https:\/\/history.dowdot.idv.tw\/?p=2167","title":{"rendered":"\u5728CentOS6.7 \u5b89\u88dd\u6700\u8fd1\u7684MySQL Server"},"content":{"rendered":"<p>1.\u5148\u79fb\u9664\u7cfb\u7d71\u539f\u672c\u7684mysql-libs<br \/>\n<code>yum remove mysql-libs<\/code><\/p>\n<p>2.\u5230<a href=\"http:\/\/dev.mysql.com\/downloads\/repo\/yum\/\" target=\"_blank\">\u5b98\u7db2<\/a>\u4e0b\u8f09\u6700\u65b0\u7248\u672c\u7684rpm,\u4e26\u5b89\u88dd<br \/>\n<code>wget http:\/\/dev.mysql.com\/get\/mysql57-community-release-el6-7.noarch.rpm<br \/>\nrpm -Uvh mysql57-community-release-el6-7.noarch.rpm<br \/>\nyum install mysql-community-server<br \/>\n<\/code><\/p>\n<p>3.\u63a5\u8457\u5c31\u53ef\u4ee5\u555f\u7528\u670d\u52d9\u4e86<br \/>\n<code>service mysqld start<\/code><\/p>\n<p>4.\u7528\u9019\u7a2e\u65b9\u6cd5\u88dd\u597d\u7684mysql,\u5176\u9810\u8a2d\u7684root\u5bc6\u78bc\u662f\u85cf\u5728\/var\/log\/mysqld.log\u88e1\u7684<br \/>\n\u6240\u4ee5more\u4e00\u4e0b\u5c31\u53ef\u4ee5\u770b\u5230<br \/>\n<code>2016-02-03T08:11:46.993568Z 1 [Note] A temporary password is generated for root@localhost: ,F1WDenwkXBu<\/code><br \/>\n\u4e0a\u9762\u7684,F1WDenwkXBu\u5c31\u662f\u5bc6\u78bc,\u6bcf\u500b\u4eba\u5b89\u88dd\u5f8c\u7684\u81e8\u6642\u5bc6\u78bc\u4e26\u4e0d\u6703\u76f8\u540c<\/p>\n<p>5.\u5225\u5fd8\u4e86\u5229\u7528mysql_secure_installation\u5de5\u5177\u8a2d\u5b9aroot\u5bc6\u78bc,\u4e26\u5c07\u4e00\u4e9banonymous\u7684\u5e33\u865f\u53ca\u975elocalhost\u7684\u6b0a\u9650\u62ff\u6389,\u5c31\u5927\u529f\u544a\u6210\u56c9<\/p>\n<p>\u66f4\u8a73\u7d30\u7684\u5b89\u88dd\u65b9\u6cd5\u53ef\u4ee5\u53c3\u8003<a href=\"http:\/\/dev.mysql.com\/doc\/mysql-yum-repo-quick-guide\/en\/\">\u5b98\u7db2\u7684\u624b\u518a<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1.\u5148\u79fb\u9664\u7cfb\u7d71\u539f\u672c\u7684mysql-libs yum remove mysql-libs 2.\u5230\u5b98\u7db2\u4e0b\u8f09\u6700\u65b0\u7248\u672c\u7684rpm,\u4e26\u5b89\u88dd wget http:\/\/dev.mysql.com\/get\/mysql57-community-release-el6-7.noarch.rpm rpm -Uvh mysql&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":2171,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"ngg_post_thumbnail":0,"spay_email":""},"categories":[14],"tags":[],"jetpack_featured_media_url":"https:\/\/history.dowdot.idv.tw\/wp-content\/uploads\/2016\/02\/MySQL.jpg","jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5NCTI-yX","_links":{"self":[{"href":"https:\/\/history.dowdot.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/2167"}],"collection":[{"href":"https:\/\/history.dowdot.idv.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/history.dowdot.idv.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/history.dowdot.idv.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/history.dowdot.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2167"}],"version-history":[{"count":4,"href":"https:\/\/history.dowdot.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/2167\/revisions"}],"predecessor-version":[{"id":2174,"href":"https:\/\/history.dowdot.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/2167\/revisions\/2174"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/history.dowdot.idv.tw\/index.php?rest_route=\/wp\/v2\/media\/2171"}],"wp:attachment":[{"href":"https:\/\/history.dowdot.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2167"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/history.dowdot.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2167"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/history.dowdot.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2167"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}