{"id":108,"date":"2017-11-09T20:08:48","date_gmt":"2017-11-09T12:08:48","guid":{"rendered":"http:\/\/www.kejidana.com\/?p=108"},"modified":"2017-11-09T20:08:48","modified_gmt":"2017-11-09T12:08:48","slug":"mysql%e9%85%8d%e7%bd%ae","status":"publish","type":"post","link":"http:\/\/www.kejidana.com\/?p=108","title":{"rendered":"Mysql\u914d\u7f6e"},"content":{"rendered":"<p>[root@server1 ~]# mysql_secure_installation<br \/>\nNOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL<br \/>\nSERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!<br \/>\nIn order to log into MySQL to secure it, we&#8217;ll need the current<br \/>\npassword for the root user. If you&#8217;ve just installed MySQL, and<br \/>\nyou haven&#8217;t set the root password yet, the password will be blank,<br \/>\nso you should just press enter here.<br \/>\nEnter current password for root (enter for none):&lt;\u2013\u521d\u6b21\u8fd0\u884c\u76f4\u63a5\u56de\u8f66<br \/>\nOK, successfully used password, moving on\u2026<br \/>\nSetting the root password ensures that nobody can log into the MySQL<br \/>\nroot user without the proper authorisation.<br \/>\nSet root password? [Y\/n] &lt;\u2013 \u662f\u5426\u8bbe\u7f6eroot\u7528\u6237\u5bc6\u7801\uff0c\u8f93\u5165y\u5e76\u56de\u8f66\u6216\u76f4\u63a5\u56de\u8f66<br \/>\nNew password: &lt;\u2013 \u8bbe\u7f6eroot\u7528\u6237\u7684\u5bc6\u7801<br \/>\nRe-enter new password: &lt;\u2013 \u518d\u8f93\u5165\u4e00\u6b21\u4f60\u8bbe\u7f6e\u7684\u5bc6\u7801<br \/>\nPassword updated successfully!<br \/>\nReloading privilege tables..<br \/>\n\u2026 Success!<br \/>\nBy default, a MySQL installation has an anonymous user, allowing anyone<br \/>\nto log into MySQL without having to have a user account created for<br \/>\nthem. This is intended only for testing, and to make the installation<br \/>\ngo a bit smoother. You should remove them before moving into a<br \/>\nproduction environment.<br \/>\nRemove anonymous users? [Y\/n] &lt;\u2013 \u662f\u5426\u5220\u9664\u533f\u540d\u7528\u6237,\u751f\u4ea7\u73af\u5883\u5efa\u8bae\u5220\u9664\uff0c\u6240\u4ee5\u76f4\u63a5\u56de\u8f66<br \/>\n\u2026 Success!<br \/>\nNormally, root should only be allowed to connect from &#8216;localhost&#8217;. This<br \/>\nensures that someone cannot guess at the root password from the network.<br \/>\nDisallow root login remotely? [Y\/n] &lt;\u2013\u662f\u5426\u7981\u6b62root\u8fdc\u7a0b\u767b\u5f55,\u6839\u636e\u81ea\u5df1\u7684\u9700\u6c42\u9009\u62e9Y\/n\u5e76\u56de\u8f66,\u5efa\u8bae\u7981\u6b62<br \/>\n\u2026 Success!<br \/>\nBy default, MySQL comes with a database named &#8216;test&#8217; that anyone can<br \/>\naccess. This is also intended only for testing, and should be removed<br \/>\nbefore moving into a production environment.<br \/>\nRemove test database and access to it? [Y\/n] &lt;\u2013 \u662f\u5426\u5220\u9664test\u6570\u636e\u5e93,\u76f4\u63a5\u56de\u8f66<br \/>\n&#8211; Dropping test database\u2026<br \/>\n\u2026 Success!<br \/>\n&#8211; Removing privileges on test database\u2026<br \/>\n\u2026 Success!<br \/>\nReloading the privilege tables will ensure that all changes made so far<br \/>\nwill take effect immediately.<br \/>\nReload privilege tables now? [Y\/n] &lt;\u2013 \u662f\u5426\u91cd\u65b0\u52a0\u8f7d\u6743\u9650\u8868\uff0c\u76f4\u63a5\u56de\u8f66<br \/>\n\u2026 Success!<br \/>\nCleaning up\u2026<br \/>\nAll done! If you&#8217;ve completed all of the above steps, your MySQL<br \/>\ninstallation should now be secure.<br \/>\nThanks for using MySQL!<br \/>\n[root@server1 ~]#<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[root@server1 ~]# mysql_secure_installation NOTE:  [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14,16],"tags":[],"class_list":["post-108","post","type-post","status-publish","format-standard","hentry","category-linux","category-mysql"],"_links":{"self":[{"href":"http:\/\/www.kejidana.com\/index.php?rest_route=\/wp\/v2\/posts\/108","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.kejidana.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.kejidana.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.kejidana.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.kejidana.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=108"}],"version-history":[{"count":0,"href":"http:\/\/www.kejidana.com\/index.php?rest_route=\/wp\/v2\/posts\/108\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.kejidana.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=108"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.kejidana.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=108"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.kejidana.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=108"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}