{"id":156,"date":"2016-11-03T17:53:40","date_gmt":"2016-11-03T09:53:40","guid":{"rendered":"http:\/\/www.secondsend.com\/wordpress\/?p=156"},"modified":"2016-11-03T17:53:40","modified_gmt":"2016-11-03T09:53:40","slug":"mysql%e5%91%bd%e4%bb%a4%e8%a1%8c%e5%88%9b%e5%bb%ba%e7%94%a8%e6%88%b7%e4%b8%8e%e6%8e%88%e6%9d%83","status":"publish","type":"post","link":"http:\/\/www.homconnect.cn\/?p=156","title":{"rendered":"MySQL\u547d\u4ee4\u884c\u521b\u5efa\u7528\u6237\u4e0e\u6388\u6743"},"content":{"rendered":"<p>1. \u521b\u5efa\u7528\u6237:<\/p>\n<p>\u547d\u4ee4:<strong>CREATE USER &#8216;username&#8217; IDENTIFIED BY &#8216;password&#8217;;<\/strong><\/p>\n<p>\u8bf4\u660e:username -&gt;\u4f60\u5c06\u521b\u5efa\u7684\u7528\u6237\u540d, password\u00a0-&gt;\u8be5\u7528\u6237\u7684\u767b\u9646\u5bc6\u7801,\u5bc6\u7801\u53ef\u4ee5\u4e3a\u7a7a,\u5982\u679c\u4e3a\u7a7a\u5219\u8be5\u7528\u6237\u53ef\u4ee5\u4e0d\u9700\u8981\u5bc6\u7801\u767b\u9646\u670d\u52a1\u5668.<\/p>\n<p><span class=\"keyword\">\u4e3e\u4e2a\u6817\u5b50\uff1aCREATE<\/span>\u00a0<span class=\"func\">USER<\/span>\u00a0wordpress\u00a0IDENTIFIED\u00a0<span class=\"keyword\">BY<\/span>\u00a0\u2018wordpresspwd\u2019;<!--more--><\/p>\n<p>2.\u6388\u6743:<\/p>\n<p>\u547d\u4ee4:<strong>GRANT privileges ON databasename.tablename TO username;<\/strong><\/p>\n<p>\u8bf4\u660e:privileges\u00a0-&gt;\u7528\u6237\u7684\u64cd\u4f5c\u6743\u9650,\u5982SELECT , INSERT , UPDATE \u7b49\uff0c\u5982\u679c\u8981\u6388\u4e88\u6240\u6709\u7684\u6743\u9650\u5219\u4f7f\u7528ALL.;databasename\u00a0-&gt;\u6570\u636e\u5e93\u540d\uff1btablename\u00a0-&gt;\u8868\u540d,\u5982\u679c\u8981\u6388\u4e88\u8be5\u7528\u6237\u5bf9\u6240\u6709\u6570\u636e\u5e93\u548c\u8868\u7684\u76f8\u5e94\u64cd\u4f5c\u6743\u9650\u5219\u53ef\u7528*\u8868\u793a, \u5982 *.* \u3002<\/p>\n<p>\u4e3e\u4e2a\u6817\u5b50\uff1a<\/p>\n<p><span class=\"keyword\">GRANT<\/span>\u00a0<span class=\"keyword\">SELECT<\/span>,\u00a0<span class=\"keyword\">INSERT<\/span>,<span class=\"keyword\">UPDATE<\/span>\u00a0<span class=\"keyword\">ON<\/span>\u00a0wordpress.<span class=\"func\">user<\/span>\u00a0<span class=\"keyword\">TO<\/span>\u00a0wordpress;<\/p>\n<p><span class=\"keyword\">GRANT<\/span>\u00a0<span class=\"op\">ALL<\/span>\u00a0<span class=\"keyword\">ON<\/span>\u00a0*.*\u00a0<span class=\"keyword\">TO\u00a0<\/span>\u00a0wordpress;<\/p>\n<p>\u6ce8\u610f:\u7528\u4ee5\u4e0a\u547d\u4ee4\u6388\u6743\u7684\u7528\u6237\u4e0d\u80fd\u7ed9\u5176\u5b83\u7528\u6237\u6388\u6743,\u5982\u679c\u60f3\u8ba9\u8be5\u7528\u6237\u53ef\u4ee5\u6388\u6743,\u7528\u4ee5\u4e0b\u547d\u4ee4:<\/p>\n<p><strong> GRANT privileges ON databasename.tablename TO username WITH GRANT OPTION;<\/strong><\/p>\n<p>\u6388\u6743\u540e\u8fd8\u8981\u5237\u65b0\u7cfb\u7edf\u6743\u9650\u8868\uff1a<\/p>\n<p>flush\u00a0<span class=\"keyword\">privileges<\/span>;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. \u521b\u5efa\u7528\u6237: \u547d\u4ee4:CREATE USER &#8216;username&#8217; IDENTIFI &hellip; <a href=\"http:\/\/www.homconnect.cn\/?p=156\" class=\"more-link\">\u7ee7\u7eed\u9605\u8bfb<span class=\"screen-reader-text\">\u201cMySQL\u547d\u4ee4\u884c\u521b\u5efa\u7528\u6237\u4e0e\u6388\u6743\u201d<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[9],"_links":{"self":[{"href":"http:\/\/www.homconnect.cn\/index.php?rest_route=\/wp\/v2\/posts\/156"}],"collection":[{"href":"http:\/\/www.homconnect.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.homconnect.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.homconnect.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.homconnect.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=156"}],"version-history":[{"count":1,"href":"http:\/\/www.homconnect.cn\/index.php?rest_route=\/wp\/v2\/posts\/156\/revisions"}],"predecessor-version":[{"id":157,"href":"http:\/\/www.homconnect.cn\/index.php?rest_route=\/wp\/v2\/posts\/156\/revisions\/157"}],"wp:attachment":[{"href":"http:\/\/www.homconnect.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=156"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.homconnect.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=156"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.homconnect.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=156"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}