{"id":4181,"date":"2023-03-29T15:16:19","date_gmt":"2023-03-29T07:16:19","guid":{"rendered":"https:\/\/www.zeroheart.xyz\/wordpress\/?p=4181"},"modified":"2023-06-08T11:17:55","modified_gmt":"2023-06-08T03:17:55","slug":"mysql-%e6%96%b0%e7%94%a8%e6%88%b7%e6%8e%88%e6%9d%83%e5%8d%95%e5%ba%93","status":"publish","type":"post","link":"https:\/\/www.zeroheart.xyz\/wordpress\/?p=4181","title":{"rendered":"mysql \u65b0\u7528\u6237\u6388\u6743\u5355\u5e93"},"content":{"rendered":"\n

CREATE USER ‘xxx’@’%’ IDENTIFIED BY ‘xxx’;<\/p>\n\n\n\n


CREATE DATABASE new_database;
<\/p>\n\n\n\n

GRANT ALL PRIVILEGES ON new_database.* TO ‘xxx’@’%’;
<\/p>\n\n\n\n

FLUSH PRIVILEGES;<\/p>\n\n\n\n

\u5220\u9664\u6743\u9650<\/p>\n\n\n\n

REVOKE ALL PRIVILEGES, GRANT OPTION FROM ‘xxx’@’%’;<\/p>\n\n\n\n

\u5220\u9664\u7528\u6237<\/p>\n\n\n\n

DROP USER ‘username’@’hostname1’, ‘username’@’hostname2’, …;<\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

CREATE USER ‘xxx’@’%’ IDENTIFIE […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[62],"_links":{"self":[{"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4181"}],"collection":[{"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4181"}],"version-history":[{"count":5,"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4181\/revisions"}],"predecessor-version":[{"id":4189,"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4181\/revisions\/4189"}],"wp:attachment":[{"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4181"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4181"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4181"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}