{"id":108,"date":"2021-01-05T17:02:14","date_gmt":"2021-01-05T09:02:14","guid":{"rendered":"https:\/\/www.52dixiaowo.com\/database\/?p=108"},"modified":"2021-01-05T17:02:15","modified_gmt":"2021-01-05T09:02:15","slug":"dcl-%e7%94%a8%e6%88%b7%e4%b8%8e%e6%9d%83%e9%99%90%e7%ae%a1%e7%90%86","status":"publish","type":"post","link":"https:\/\/www.52dixiaowo.com\/db\/post-108.html","title":{"rendered":"DCL \u7528\u6237\u4e0e\u6743\u9650\u7ba1\u7406"},"content":{"rendered":"\n<p>DCL \u901a\u5e38\u662f DBA(\u6570\u636e\u5e93\u7ba1\u7406\u5458)\u4f7f\u7528\u7684\u8bed\u53e5\uff0c\u7ba1\u7406\u7528\u6237\u4e0e\u6570\u636e\u5e93\u6743\u9650\u7b49<\/p>\n\n\n\n<h4 class=\"has-text-align-center\">1.\u7528\u6237\u7ba1\u7406<\/h4>\n\n\n\n<h5>1.\u67e5\u8be2\u7528\u6237<\/h5>\n\n\n\n<p>\u5207\u6362\u5230\u7cfb\u7edf\u81ea\u5e26\u7684 mysql \u6570\u636e\u5e93<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>use mysql;<\/code><\/pre>\n\n\n\n<p>\u67e5\u8be2 user \u8868<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>select * from user;<\/code><\/pre>\n\n\n\n<p>( Host \u8868\u793a\u53ef\u8bbf\u95ee ip \uff0c\u5176\u4e2d \u201c%\u201d \u8868\u793a\u4efb\u610fip)<\/p>\n\n\n\n<h5>2.\u521b\u5efa\u7528\u6237<\/h5>\n\n\n\n<p>\u5fc5\u987b\u6307\u5b9a\u7528\u6237\u540d\uff0c\u4e3b\u673a\u540d\uff0c\u4e0e\u5bc6\u7801<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE USER '\u7528\u6237\u540d'@'\u4e3b\u673a\u540d' IDENTIFIED BY '\u5bc6\u7801';<\/code><\/pre>\n\n\n\n<h5>3.\u5220\u9664\u7528\u6237<\/h5>\n\n\n\n<p>\u5fc5\u987b\u6307\u5b9a\u7528\u6237\u540d\u548c\u4e3b\u673a\u540d<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DROP USER '\u7528\u6237\u540d'@'\u4e3b\u673a\u540d';<\/code><\/pre>\n\n\n\n<h5>4.\u4fee\u6539\u7528\u6237\u5bc6\u7801<\/h5>\n\n\n\n<p>\u4fee\u6539\u6307\u5b9a\u540d\u79f0\uff08\u53ef\u52a0\u4e3b\u673a\u540d\uff09\u7528\u6237\u7684\u5bc6\u7801\uff08\u901a\u7528 sql \u65b9\u5f0f\uff09<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>UPDATE USER SET PASSWORD = PASSWORD('\u65b0\u5bc6\u7801') WHERE USER = '\u7528\u6237\u540d';<\/code><\/pre>\n\n\n\n<p>\u4fee\u6539\u6307\u5b9a\u201c\u7528\u6237\u540d\u53ca\u4e3b\u673a\u540d\u201d\u7684\u7528\u6237\u5bc6\u7801\uff08 DCL \u7279\u6709\u7684\u65b9\u5f0f\uff09<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SET PASSWORD FOR '\u7528\u6237\u540d'@'\u4e3b\u673a\u540d' = PASSWORD('\u65b0\u5bc6\u7801');<\/code><\/pre>\n\n\n\n<p class=\"has-text-align-center\">\u5fd8\u8bb0\u4e86 root \u5bc6\u7801\uff1f<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\u5148\u5173\u95edmysql \u670d\u52a1  ->   \u4ee5\u7ba1\u7406\u5458\u8fd0\u884c cmd<\/code><\/pre>\n\n\n\n<p>\u5728\u6b64\u7a97\u53e3\u4e2d\uff0c\u8f93\u5165\u5982\u4e0b\u547d\u4ee4\uff0c\u8df3\u8fc7\u5bc6\u7801\u9a8c\u8bc1<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysqld --skip-grant-tables<\/code><\/pre>\n\n\n\n<p>\u7136\u540e\uff0c\u4e0d\u8981\u5173\u95ed\u6b64\u7a97\u53e3\uff0c\u65b0\u6253\u5f00\u4e00\u4e2a cmd\uff0c\u8f93\u5165\u4ee5\u4e0b\u547d\u4ee4\u53ef\u76f4\u63a5\u767b\u5f55<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql<\/code><\/pre>\n\n\n\n<p>\u6b64\u65f6\uff0c\u4f60\u5c31\u5df2\u7ecf\u4ee5\u65e0\u9a8c\u8bc1\u65b9\u5f0f\u767b\u5f55 mysql \uff0c\u6539\u5565\u90fd\u53ef\u4ee5\u3002\u4fee\u6539 root \u5bc6\u7801<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>update user set password = password('\u4f60\u7684\u65b0\u5bc6\u7801') where user = 'root';<\/code><\/pre>\n\n\n\n<p>\u5173\u95ed\u8fd9 2 \u4e2a\u5c0f\u7a97\u53e3\uff0c\u4f7f\u7528\u4efb\u52a1\u7ba1\u7406\u5668\u7ed3\u675f mysqld.exe \u8fdb\u7a0b<\/p>\n\n\n\n<p>\u91cd\u65b0\u542f\u52a8 mysql \u670d\u52a1\uff0c\u4f7f\u7528\u65b0\u5bc6\u7801\u767b\u5f55\u5373\u53ef\u3002<\/p>\n\n\n\n<h4 class=\"has-text-align-center\">2.\u7528\u6237\u6743\u9650\u7ba1\u7406<\/h4>\n\n\n\n<h5>1.\u67e5\u8be2\u7528\u6237\u6743\u9650<\/h5>\n\n\n\n<pre class=\"wp-block-code\"><code>SHOW GRANTS FOR '\u7528\u6237\u540d'@'\u4e3b\u673a\u540d';<\/code><\/pre>\n\n\n\n<h5>2.\u6388\u4e88\u7528\u6237\u6743\u9650<\/h5>\n\n\n\n<p>\u5982\u679c\u662f\u6240\u6709\u6743\u9650\uff0c\u4f7f\u7528 ALL \uff0c\u6240\u6709\u6570\u636e\u5e93\u6240\u6709\u8868\uff0c\u4f7f\u7528 *.*<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>grant \u6743\u9650\u5217\u8868 on \u6570\u636e\u5e93\u540d.\u8868\u540d to '\u7528\u6237\u540d'@'\u4e3b\u673a\u540d';<\/code><\/pre>\n\n\n\n<h5>3.\u64a4\u9500\u7528\u6237\u6743\u9650<\/h5>\n\n\n\n<pre class=\"wp-block-code\"><code>revoke \u6743\u9650\u5217\u8868 on \u6570\u636e\u5e93\u540d.\u8868\u540d from '\u7528\u6237\u540d'@'\u4e3b\u673a\u540d';<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>DCL \u901a\u5e38\u662f DBA(\u6570\u636e\u5e93\u7ba1\u7406\u5458)\u4f7f\u7528\u7684\u8bed\u53e5\uff0c\u7ba1\u7406\u7528\u6237\u4e0e\u6570\u636e\u5e93\u6743\u9650\u7b49 1.\u7528\u6237\u7ba1\u7406 1.\u67e5\u8be2\u7528\u6237 \u5207\u6362\u5230\u7cfb&hellip; <a href=\"https:\/\/www.52dixiaowo.com\/db\/post-108.html\" class=\"more-link\">\u7ee7\u7eed\u9605\u8bfb <span class=\"screen-reader-text\">DCL \u7528\u6237\u4e0e\u6743\u9650\u7ba1\u7406<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"_links":{"self":[{"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/posts\/108"}],"collection":[{"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/comments?post=108"}],"version-history":[{"count":1,"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/posts\/108\/revisions"}],"predecessor-version":[{"id":109,"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/posts\/108\/revisions\/109"}],"wp:attachment":[{"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/media?parent=108"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/categories?post=108"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.52dixiaowo.com\/db\/wp-json\/wp\/v2\/tags?post=108"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}