{"id":151554,"date":"2019-07-25T09:14:49","date_gmt":"2019-07-25T01:14:49","guid":{"rendered":"https:\/\/lrxjmw.cn\/?p=151554"},"modified":"2019-07-23T09:16:14","modified_gmt":"2019-07-23T01:16:14","slug":"mysql-user-manage","status":"publish","type":"post","link":"https:\/\/lrxjmw.cn\/mysql-user-manage.html","title":{"rendered":"mysql \u7528\u6237\u7ba1\u7406"},"content":{"rendered":"<p data-source-line=\"1\">1\u3001\u67e5\u770bmysql\u6570\u636e\u5e93\u4e2d\u7684\u6240\u6709\u7528\u6237\uff1a<\/p>\n<pre data-source-line=\"2\"><code class=\"hljs\">mysql&gt;<span class=\"zh-hans\">\u00a0<\/span><span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-keyword\">DISTINCT<\/span> CONCAT(<span class=\"hljs-string\">'User: '''<\/span>,<span class=\"hljs-keyword\">user<\/span>,<span class=\"hljs-string\">'''@'''<\/span>,host,<span class=\"hljs-string\">''';'<\/span>) <span class=\"hljs-keyword\">AS<\/span> query <span class=\"hljs-keyword\">FROM<\/span> mysql.<span class=\"hljs-keyword\">user<\/span>;<span class=\"zh-hans\">\u00a0<\/span>\r\n<\/code><\/pre>\n<p data-source-line=\"5\">2\u3001\u67e5\u770b\u6570\u636e\u5e93\u4e2d\u5177\u4f53\u67d0\u4e2a\u7528\u6237\u7684\u6743\u9650:<\/p>\n<pre data-source-line=\"6\"><code class=\"hljs\">mysql&gt;<span class=\"zh-hans\">\u00a0<\/span><span class=\"hljs-keyword\">show<\/span> grants <span class=\"hljs-keyword\">for<\/span><span class=\"zh-hans\">\u00a0<\/span><span class=\"hljs-string\">'root'<\/span>@<span class=\"hljs-string\">'localhost'<\/span>;<span class=\"zh-hans\">\u00a0<\/span>\r\n<\/code><\/pre>\n<p data-source-line=\"9\">\u6216\u8005<\/p>\n<pre data-source-line=\"10\"><code class=\"hljs\">mysql&gt; <span class=\"hljs-keyword\">select<\/span> * <span class=\"hljs-keyword\">from<\/span> mysql.<span class=\"hljs-keyword\">user<\/span> <span class=\"hljs-keyword\">where<\/span> <span class=\"hljs-keyword\">user<\/span>=<span class=\"hljs-string\">'root'<\/span> \\G;<span class=\"zh-hans\">\u00a0<\/span>\r\n<\/code><\/pre>\n<p data-source-line=\"13\">3\u3001\u67e5\u770buser\u8868\u7684\u8868\u7ed3\u6784\u3002\u9700\u8981\u5177\u4f53\u7684\u9879\u53ef\u4ee5\u6839\u636e\u8868\u7684\u7ed3\u6784\u6765\u67e5\u8be2\u3002<\/p>\n<pre data-source-line=\"14\"><code class=\"hljs\">mysql&gt; <span class=\"hljs-keyword\">desc<\/span> mysql.<span class=\"hljs-keyword\">user<\/span>;<span class=\"zh-hans\">\u00a0<\/span>\r\n<\/code><\/pre>\n<p data-source-line=\"17\">4\u3001\u4fee\u6539\u7528\u6237\u6743\u9650\uff1a<\/p>\n<pre data-source-line=\"18\"><code class=\"hljs\">mysql&gt; <span class=\"hljs-keyword\">GRANT<\/span> <span class=\"hljs-keyword\">ALL<\/span> <span class=\"hljs-keyword\">ON<\/span> *.* <span class=\"hljs-keyword\">TO<\/span> `<span class=\"zh-hans\">\u7528\u6237\u540d<\/span>`@`<span class=\"hljs-number\">127.0<\/span><span class=\"hljs-number\">.0<\/span><span class=\"hljs-number\">.1<\/span>` <span class=\"hljs-keyword\">WITH<\/span> <span class=\"hljs-keyword\">GRANT<\/span> <span class=\"hljs-keyword\">OPTION<\/span>;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>1\u3001\u67e5\u770bmysql\u6570\u636e\u5e93\u4e2d\u7684\u6240\u6709\u7528\u6237\uff1a mysql&gt;\u00a0SELECT DISTINCT CONCAT(&#8216;U [&hellip;]<\/p>\n","protected":false},"author":1476,"featured_media":103595,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[55],"tags":[],"class_list":["post-151554","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thread"],"acf":[],"_links":{"self":[{"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/posts\/151554","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/users\/1476"}],"replies":[{"embeddable":true,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/comments?post=151554"}],"version-history":[{"count":2,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/posts\/151554\/revisions"}],"predecessor-version":[{"id":151641,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/posts\/151554\/revisions\/151641"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/media\/103595"}],"wp:attachment":[{"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/media?parent=151554"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/categories?post=151554"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lrxjmw.cn\/wp-json\/wp\/v2\/tags?post=151554"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}