{"id":18047,"date":"2013-09-30T12:22:17","date_gmt":"2013-09-30T04:22:17","guid":{"rendered":"https:\/\/2blog.ilc.edu.tw\/25793\/2013\/09\/30\/mysql-server-%e5%ae%89%e8%a3%9d%e5%be%8c%e7%9a%84%e8%a8%ad%e5%ae%9a\/"},"modified":"2013-09-30T12:22:17","modified_gmt":"2013-09-30T04:22:17","slug":"mysql-server-%e5%ae%89%e8%a3%9d%e5%be%8c%e7%9a%84%e8%a8%ad%e5%ae%9a","status":"publish","type":"post","link":"https:\/\/2blog.ilc.edu.tw\/25793\/2013\/09\/30\/mysql-server-%e5%ae%89%e8%a3%9d%e5%be%8c%e7%9a%84%e8%a8%ad%e5%ae%9a\/","title":{"rendered":"MySQL Server \u5b89\u88dd\u5f8c\u7684\u8a2d\u5b9a"},"content":{"rendered":"

MySQL Server\u00a0\u5b89\u88dd\u4e4b\u5f8c\uff0c\u9664\u4e86\u8981\u8a2d\u5b9a\u7ba1\u7406\u8005 root\u00a0\u7684\u5bc6\u78bc\u5916\uff0c\u6700\u597d\u4e5f\u8981\u628a\u4e00\u4e9b\u7528\u4e0d\u5230\u7684\u8cc7\u6599\u5eab \/\u00a0\u8868\u52a0\u4ee5\u79fb\u9664\uff0c\u4e26\u52a0\u4e0a\u4e00\u4e9b\u6b0a\u9650\u7684\u8a2d\u5b9a\uff0c\u9019\u4e9b\u7e41\u96dc\u7684\u8a2d\u5b9a\uff0c\u53ef\u4ee5\u4f7f\u7528 mysql_secure_installation\u00a0\u4f86\u89e3\u6c7a\u3002[@more@]# \/usr\/bin\/mysql_secure_installation<\/span><\/p>\n

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL<\/span>
\u00a0\u00a0\u00a0\u00a0\u00a0 SERVERS IN PRODUCTION USE!\u00a0 PLEASE READ EACH STEP CAREFULLY!<\/span><\/p>\n

In order to log into MySQL to secure it, we’ll need the current<\/span>
password for the root user.\u00a0 If you’ve just installed MySQL, and<\/span>
you haven’t set the root password yet, the password will be blank,<\/span>
so you should just press enter here.<\/span><\/p>\n

#\u00a0\u8f38\u5165 root\u00a0\u7684\u5bc6\u78bc\uff0c\u5982\u679c\u6c92\u6709\u8a2d\u5b9a\u904e\uff0c\u76f4\u63a5\u6309 Enter\u00a0\u9375\u5373\u53ef
Enter current password for root (enter for none):<\/span>
OK, successfully used password, moving on…<\/span><\/p>\n

Setting the root password ensures that nobody can log into the MySQL<\/span>
root user without the proper authorisation.<\/span><\/p>\n

#\u00a0\u8a2d\u5b9a root\u00a0\u7684\u5bc6\u78bc
Set root password? [Y\/n] y<\/span><\/span>
New password:<\/span>
Re-enter new password:<\/span>
Password updated successfully!<\/span>
Reloading privilege tables..<\/span>
\u00a0… Success!<\/span><\/p>\n

By default, a MySQL installation has an anonymous user, allowing anyone<\/span>
to log into MySQL without having to have a user account created for<\/span>
them.\u00a0 This is intended only for testing, and to make the installation<\/span>
go a bit smoother.\u00a0 You should remove them before moving into a<\/span>
production environment.<\/span><\/p>\n

#\u00a0\u79fb\u9664 anonymous\u00a0\u4f7f\u7528\u8005
Remove anonymous users? [Y\/n] y<\/span><\/span>
\u00a0… Success!<\/span><\/p>\n

Normally, root should only be allowed to connect from ‘localhost’.\u00a0 This<\/span>
ensures that someone cannot guess at the root password from the network.<\/span><\/p>\n

#\u00a0\u53d6\u6d88 root\u00a0\u9060\u7aef\u767b\u5165
Disallow root login remotely? [Y\/n] y<\/span><\/span>
\u00a0… Success!<\/span><\/p>\n

By default, MySQL comes with a database named ‘test’ that anyone can<\/span>
access.\u00a0 This is also intended only for testing, and should be removed<\/span>
before moving into a production environment.<\/span><\/p>\n

#\u00a0\u79fb\u9664 test\u00a0\u8cc7\u6599\u8868
Remove test database and access to it? [Y\/n] y<\/span><\/span>
\u00a0– Dropping test database…<\/span>
\u00a0… Success!<\/span>
\u00a0– Removing privileges on test database…<\/span>
\u00a0… Success!<\/span><\/p>\n

Reloading the privilege tables will ensure that all changes made so far<\/span>
will take effect immediately.<\/span><\/p>\n

#\u00a0\u91cd\u65b0\u8f09\u5165\u8cc7\u6599\u8868\u6b0a\u9650
Reload privilege tables now? [Y\/n] y<\/span><\/span>
\u00a0… Success!<\/span><\/p>\n

Cleaning up…<\/span><\/p>\n

All done!\u00a0 If you’ve completed all of the above steps, your MySQL<\/span>
installation should now be secure.<\/span><\/p>\n

Thanks for using MySQL!<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

MySQL Server\u00a0\u5b89\u88dd\u4e4b\u5f8c\uff0c\u9664\u4e86\u8981\u8a2d\u5b9a\u7ba1\u7406\u8005 root\u00a0\u7684\u5bc6\u78bc\u5916\uff0c\u6700\u597d\u4e5f\u8981\u628a\u4e00\u4e9b\u7528\u4e0d\u5230\u7684\u8cc7\u6599\u5eab \/\u00a0\u8868 … <\/p>\n

\u95b1\u8b80\u5168\u6587\u3008MySQL Server \u5b89\u88dd\u5f8c\u7684\u8a2d\u5b9a\u3009<\/span><\/a><\/p>\n","protected":false},"author":55,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[116],"tags":[],"class_list":["post-18047","post","type-post","status-publish","format-standard","hentry","category-c-78461"],"meta_key":{"_encloseme":["1"],"lt_post_id":["427683"]},"_links":{"self":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts\/18047"}],"collection":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/users\/55"}],"replies":[{"embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/comments?post=18047"}],"version-history":[{"count":0,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts\/18047\/revisions"}],"wp:attachment":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/media?parent=18047"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/categories?post=18047"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/tags?post=18047"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}