{"id":2773,"date":"2017-10-14T08:14:43","date_gmt":"2017-10-14T00:14:43","guid":{"rendered":"http:\/\/cn.hostease.com\/xueyuan\/?p=2773"},"modified":"2017-10-14T08:14:43","modified_gmt":"2017-10-14T00:14:43","slug":"mysql%e7%94%a8%e6%88%b7%e7%ae%a1%e7%90%86","status":"publish","type":"post","link":"https:\/\/cn.hostease.com\/xueyuan\/jishu\/shujuku\/mysql%e7%94%a8%e6%88%b7%e7%ae%a1%e7%90%86\/","title":{"rendered":"mysql\u7528\u6237\u7ba1\u7406"},"content":{"rendered":"

\u5feb\u901f\u521b\u5efa\u7528\u6237<\/p>\n

grant all on *.* \u00a0 to ‘mvpbang’@’localhost’ \u00a0identified by ‘123123’;<\/p>\n

grant all on *.* \u00a0 to ‘mvpbang’@’%’ \u00a0identified by ‘123123’;test<\/p>\n

00\u3001\u521b\u5efa\u7528\u6237<\/p>\n

create user ‘mvpbang’@’localhost’ \u00a0identified by ‘123123’;
\ncreate user ‘mvpbang’@’%’ \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0identified by ‘d123123’;<\/p>\n

01\u3001\u7528\u6237\u6388\u6743<\/p>\n

grant all on *.* to ‘user1’@’localhost’;<\/p>\n

grant select on *.* \u00a0to ‘mvpbang’@’localhost’;<\/p>\n

grant select on *.* \u00a0to \u00a0szcx;<\/p>\n","protected":false},"excerpt":{"rendered":"

\u5feb\u901f\u521b\u5efa\u7528\u6237 grant all on *.* \u00a0 to ‘mvpbang’@&#82 … \u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[49,10],"tags":[],"class_list":["post-2773","post","type-post","status-publish","format-standard","hentry","category-linux","category-shujuku"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/2773","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/comments?post=2773"}],"version-history":[{"count":1,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/2773\/revisions"}],"predecessor-version":[{"id":2774,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/2773\/revisions\/2774"}],"wp:attachment":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/media?parent=2773"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/categories?post=2773"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/tags?post=2773"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}