{"id":132,"date":"2013-09-16T15:17:27","date_gmt":"2013-09-16T07:17:27","guid":{"rendered":"http:\/\/blog.sway.com.cn\/?p=132"},"modified":"2013-09-17T10:04:46","modified_gmt":"2013-09-17T02:04:46","slug":"centos%e4%b8%8byum%e5%ae%89%e8%a3%85mysql%e5%b9%b6%e5%bc%80%e5%90%af%e8%bf%9c%e7%a8%8b%e8%b4%a6%e6%88%b7","status":"publish","type":"post","link":"http:\/\/blog.sway.com.cn\/?p=132","title":{"rendered":"CentOS\u4e0byum\u5b89\u88c5mysql\u5e76\u5f00\u542f\u8fdc\u7a0b\u8d26\u6237"},"content":{"rendered":"<p>CentOS\u4e2d\u5b89\u88c5MySQL\u975e\u5e38\u7b80\u5355\uff0c\u76f4\u63a5yum\u5373\u53ef\uff1a<\/p>\n<pre class=\"lang:sh decode:true\"># yum install mysql mysql-server<\/pre>\n<p>\u5b89\u88c5\u8fc7\u7a0b\u4e2d\u9700\u8981\u8f93\u5165\u201cy\u201d\u4ee5\u786e\u8ba4\u3002<\/p>\n<p>\u5b8c\u6210\u540e\u542f\u52a8MySQL\uff1a<\/p>\n<pre class=\"lang:sh decode:true\">#\/etc\/init.d\/mysqld start<\/pre>\n<p>\u5b89\u88c5\u5b8cMySQL\u540e\uff0c\u9700\u8981\u7acb\u5373\u5bf9MySQL\u8fdb\u884c\u57fa\u672c\u7684\u5b89\u5168\u8bbe\u7f6e\uff0c\u4f7f\u7528<\/p>\n<pre class=\"lang:sh decode:true\"># mysql_secure_installation<\/pre>\n<p>\u6b64\u7a0b\u5e8f\u662fMySQL\u7684\u5b89\u5168\u8bbe\u7f6e\u5411\u5bfc\uff0c\u9996\u5148\u4f1a\u8be2\u95ee\u662f\u5426\u8bbe\u7f6eMySQL\u7684root\u5bc6\u7801\uff0c\u76f4\u63a5\u56de\u8f66\u8868\u793a\u786e\u8ba4\u8bbe\u7f6e\u3002\u6309\u7167\u63d0\u793a\u91cd\u65b0\u8f93\u5165\u4e00\u4e2a\u5bc6\u7801\u5373\u53ef\u3002\u968f\u540e\u4f1a\u63d0\u793a\uff1a<\/p>\n<pre class=\"lang:sh decode:true\">Remove anonymous users? [Y\/n]                      Enter\r\nDisallow root login remotely? [Y\/n]                    Enter\r\nRemove test database and access to it? [Y\/n]           Enter\r\nReload privilege tables now? [Y\/n]                     Enter<\/pre>\n<p>\u7b49\uff0c\u5747\u76f4\u63a5\u56de\u8f66\uff08Y\uff09\u3002<\/p>\n<p align=\"left\">\u6700\u540e\u4f7f\u7528\u5982\u4e0b\u547d\u4ee4\u4f7fMySQL\u5f00\u673a\u81ea\u52a8\u542f\u52a8\uff1a<\/p>\n<pre class=\"lang:sh decode:true\"># chkconfig --levels 235 mysqld on<\/pre>\n<p>\u81f3\u6b64\uff0cMySQL\u7ec4\u4ef6\u5df2\u7ecf\u5b89\u88c5\u6210\u529f\uff0c\u5e76\u4e14\u505a\u597d\u4e86\u57fa\u672c\u7684\u5b89\u5168\u8bbe\u7f6e\u3002<\/p>\n<p>\u4f7f\u7528 #mysql\u547d\u4ee4\u8fdb\u5165mysql\u5ba2\u6237\u7aef\uff0c\u5e76\u4f7f\u7528\u4ee5\u4e0b\u547d\u4ee4\u5efa\u7acb\u8fdc\u7a0b\u8d26\u6237\uff1a<\/p>\n<pre class=\"lang:mysql decode:true crayon-selected\">GRANT ALL PRIVILEGES ON *.* TO '\u8d26\u53f7'@'\u5141\u8bb8\u767b\u5f55\u7684\u57df' IDENTIFIED BY '\u5bc6\u7801' WITH GRANT OPTION;\r\nFLUSH PRIVILEGES;<\/pre>\n<p>\u91cd\u542fmysql\u670d\u52a1\u5668\u5373\u53ef\u3002<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>CentOS\u4e2d\u5b89\u88c5MySQL\u975e\u5e38\u7b80\u5355\uff0c\u76f4\u63a5yum\u5373\u53ef\uff1a # yum install mysql mysql-s [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-132","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"http:\/\/blog.sway.com.cn\/index.php?rest_route=\/wp\/v2\/posts\/132","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/blog.sway.com.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.sway.com.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.sway.com.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.sway.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=132"}],"version-history":[{"count":4,"href":"http:\/\/blog.sway.com.cn\/index.php?rest_route=\/wp\/v2\/posts\/132\/revisions"}],"predecessor-version":[{"id":146,"href":"http:\/\/blog.sway.com.cn\/index.php?rest_route=\/wp\/v2\/posts\/132\/revisions\/146"}],"wp:attachment":[{"href":"http:\/\/blog.sway.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=132"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.sway.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=132"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.sway.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=132"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}