{"id":112,"date":"2025-04-24T00:46:17","date_gmt":"2025-04-23T16:46:17","guid":{"rendered":"https:\/\/518958.xyz\/?p=112"},"modified":"2025-04-24T00:46:17","modified_gmt":"2025-04-23T16:46:17","slug":"mysql8%e5%85%81%e8%ae%b8%e6%8c%87%e5%ae%9a%e7%94%a8%e6%88%b7%e4%bb%8e%e5%a4%96%e9%83%a8%e8%ae%bf%e9%97%ae","status":"publish","type":"post","link":"https:\/\/518958.xyz\/?p=112","title":{"rendered":"MySQL8\u5141\u8bb8\u6307\u5b9a\u7528\u6237\u4ece\u5916\u90e8\u8bbf\u95ee"},"content":{"rendered":"<p>SSH\u8fde\u63a5\u5230\u6570\u636e\u5e93\u670d\u52a1\u5668<\/p>\n<p>#\u8fdb\u5165MySQL\u6570\u636e\u5e93<br \/>\n<code>mysql -uroot -p<\/code><\/p>\n<p>#\u8f93\u5165MySQL\u7684root\u5bc6\u7801<\/p>\n<p>#\u521b\u5efa\u6570\u636e\u5e93\u7528\u6237username\uff0c\u5bc6\u7801password\uff0c\u5141\u8bb8\u4ece\u6240\u6709\u4e3b\u673a\u8fde\u63a5<br \/>\n<code>CREATE USER 'username'@'%' IDENTIFIED BY 'password';<\/code><\/p>\n<p>#\u6388\u4e88username\u7528\u6237\u5bf9\u6570\u636e\u5e93custom_database\u7684\u8bbf\u95ee\u6743\u9650<br \/>\n<code>GRANT ALL PRIVILEGES ON `custom_database`.* TO 'username'@'%';<\/code><\/p>\n<p>#\u4f7f\u6743\u9650\u751f\u6548<br \/>\n<code>FLUSH PRIVILEGES;<\/code><\/p>\n<p>#\u9632\u706b\u5899\u5f00\u653e3306\u7aef\u53e3<br \/>\n<code>sudo firewall-cmd --permanent --add-port=3306\/tcp<\/code><\/p>\n<p>#\u91cd\u8f7d\u9632\u706b\u5899\u89c4\u5219<br \/>\n<code>sudo firewall-cmd --reload<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>SSH\u8fde\u63a5\u5230\u6570\u636e\u5e93\u670d\u52a1\u5668 #\u8fdb\u5165MySQL\u6570\u636e\u5e93 mysql -uroot -p #\u8f93\u5165MySQL\u7684root\u5bc6\u7801 #\u521b\u5efa\u6570\u636e\u5e93\u7528\u6237username\uff0c\u5bc6\u7801password\uff0c\u5141\u8bb8\u4ece\u6240\u6709\u4e3b\u673a\u8fde\u63a5 CREATE USER &#8216;username&#8217;@&#8217;%&#8217; IDENTIFIED BY &#8216;password&#8217;; #\u6388\u4e88username\u7528\u6237\u5bf9\u6570\u636e\u5e93custom_database\u7684\u8bbf\u95ee\u6743\u9650 GRANT ALL PRIV [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":113,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[8],"tags":[],"class_list":["post-112","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-operation"],"_links":{"self":[{"href":"https:\/\/518958.xyz\/index.php?rest_route=\/wp\/v2\/posts\/112","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/518958.xyz\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/518958.xyz\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/518958.xyz\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/518958.xyz\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=112"}],"version-history":[{"count":1,"href":"https:\/\/518958.xyz\/index.php?rest_route=\/wp\/v2\/posts\/112\/revisions"}],"predecessor-version":[{"id":114,"href":"https:\/\/518958.xyz\/index.php?rest_route=\/wp\/v2\/posts\/112\/revisions\/114"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/518958.xyz\/index.php?rest_route=\/wp\/v2\/media\/113"}],"wp:attachment":[{"href":"https:\/\/518958.xyz\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=112"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/518958.xyz\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=112"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/518958.xyz\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=112"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}