{"id":805,"date":"2021-09-06T16:16:08","date_gmt":"2021-09-06T08:16:08","guid":{"rendered":"http:\/\/www.wccass.com\/?p=805"},"modified":"2021-09-06T16:18:01","modified_gmt":"2021-09-06T08:18:01","slug":"mysql-8-0-%e8%b5%8b%e4%ba%88root-%e7%94%a8%e6%88%b7%e4%bb%bb%e6%84%8f%e5%9c%b0%e5%9d%80%e7%9a%84%e8%ae%bf%e9%97%ae%e6%9d%83%e9%99%90","status":"publish","type":"post","link":"https:\/\/blog.tongyunli.top\/?p=805","title":{"rendered":"Mysql 8.0 \u8d4b\u4e88root \u7528\u6237\u4efb\u610f\u5730\u5740\u7684\u8bbf\u95ee\u6743\u9650"},"content":{"rendered":"\n<p>\u4eceMySQL 8\u5f00\u59cb,\u60a8\u4e0d\u518d\u53ef\u4ee5(\u9690\u5f0f)\u4f7f\u7528GRANT\u547d\u4ee4\u521b\u5efa\u7528\u6237.\u8bf7\u6539\u7528CREATE USER,\u7136\u540e\u4f7f\u7528GRANT \u58f0\u660e\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql&gt; CREATE USER 'root'@'%' IDENTIFIED BY 'root';\nmysql&gt; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION\nmysql&gt; flush privileges;<\/code><\/pre>\n\n\n\n<p>\u4f46\u662f\u4e2a\u4eba\u89c9\u5f97\u8fd9\u6837\u5f88\u9ebb\u70e6 \u800c\u4e14\u4e0d\u597d\u8bb0\u5fc6 \uff0c \u6240\u4ee5\u63a8\u8350\u4f7f\u7528\u4e0b\u9762\u7684\u65b9\u6cd5<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql&gt; use mysql;\nmysql&gt; update user set Host='%' where User='root' and Host='localhost';\nmysql&gt; flush privileges; <\/code><\/pre>\n\n\n\n<p>\u8fd9\u6837\u76f4\u63a5\u4fee\u6539 MYSQL \u5185\u7f6e\u7684 \u6743\u9650\u8868\u5c31\u884c\u4e86<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4eceMySQL 8\u5f00\u59cb,\u60a8\u4e0d\u518d\u53ef\u4ee5(\u9690\u5f0f)\u4f7f\u7528GRANT\u547d\u4ee4\u521b\u5efa\u7528\u6237.\u8bf7\u6539\u7528CREATE USER,\u7136\u540e\u4f7f\u7528GR [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[22],"class_list":["post-805","post","type-post","status-publish","format-standard","hentry","tag-projk"],"_links":{"self":[{"href":"https:\/\/blog.tongyunli.top\/index.php?rest_route=\/wp\/v2\/posts\/805","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.tongyunli.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.tongyunli.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.tongyunli.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.tongyunli.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=805"}],"version-history":[{"count":1,"href":"https:\/\/blog.tongyunli.top\/index.php?rest_route=\/wp\/v2\/posts\/805\/revisions"}],"predecessor-version":[{"id":807,"href":"https:\/\/blog.tongyunli.top\/index.php?rest_route=\/wp\/v2\/posts\/805\/revisions\/807"}],"wp:attachment":[{"href":"https:\/\/blog.tongyunli.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=805"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.tongyunli.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=805"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.tongyunli.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=805"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}