{"id":441,"date":"2020-12-19T23:20:32","date_gmt":"2020-12-19T15:20:32","guid":{"rendered":"http:\/\/moyisuiying.com\/?p=441"},"modified":"2020-12-20T10:38:56","modified_gmt":"2020-12-20T02:38:56","slug":"mysql%e5%ad%a6%e4%b9%a0%e4%b8%8e%e6%95%b0%e6%8d%ae%e5%ba%93%e7%bb%bc%e5%90%88%e5%ae%9e%e9%aa%8c%ef%bc%88%e5%8d%81%ef%bc%89-%e8%87%aa%e4%b8%bb%e5%ad%98%e5%8f%96%e6%8e%a7%e5%88%b6","status":"publish","type":"post","link":"http:\/\/moyisuiying.com\/index.php\/experiment\/mysqlexperiment\/441.html","title":{"rendered":"MYSQL\u5b66\u4e60\u4e0e\u6570\u636e\u5e93\u7efc\u5408\u5b9e\u9a8c\uff08\u5341\u4e8c\uff09\u2014\u2014\u81ea\u4e3b\u5b58\u53d6\u63a7\u5236\u5b9e\u9a8c\uff08\u57fa\u4e8eUbuntu18.04\u4e2dDocker\u5b89\u88c5\u7684MySQL8\u5b9e\u9a8c\uff09"},"content":{"rendered":"\n<h3>12.1MySQL\u7684\u6743\u9650<\/h3>\n\n\n\n<p>\u7528\u6237\u8fde\u63a5\u5230MySQL\uff0c\u53ef\u4ee5\u505a\u5404\u79cd\u67e5\u8be2\uff0c\u8fd9\u90fd\u662fMySQL\u7528\u6237\u4e0e\u6743\u9650\u529f\u80fd\u5728\u80cc\u540e\u7ef4\u6301\u7740\u64cd\u4f5c\u3002<\/p>\n\n\n\n<p>\u7528\u6237\u4e0e\u6570\u636e\u5e93\u670d\u52a1\u5668\u4ea4\u4e92\u6570\u636e\uff0c\u5206\u4e3a\u4e24\u4e2a\u9636\u6bb5\uff1a<\/p>\n\n\n\n<p>\uff081\uff09\u4f60\u6709\u6ca1\u6709\u6743\u8fde\u63a5\u4e0a\u6765<br>\uff082\uff09\u4f60\u6709\u6ca1\u6709\u6743\u6267\u884c\u672c\u64cd\u4f5c<\/p>\n\n\n\n<h4>12.1.1\u4f60\u6709\u6ca1\u6709\u6743\u8fde\u63a5\u4e0a\u6765<\/h4>\n\n\n\n<p>\u670d\u52a1\u5668\u5982\u4f55\u5224\u65ad\u7528\u6237\u6709\u6ca1\u6709\u6743\u8fde\u63a5\u4e0a\u6765\uff1f<\/p>\n\n\n\n<p>\u4f9d\u636e\uff1a<\/p>\n\n\n\n<p>1\uff09\u4f60\u4ece\u54ea\u91cc\u6765\uff1fhost<br>2\uff09\u4f60\u662f\u8c01\uff1fuser<br>3\uff09\u4f60\u7684\u5bc6\u7801\u662f\u591a\u5c11\uff1fpassword<\/p>\n\n\n\n<p>\u7528\u6237\u7684\u8fd9\u4e09\u4e2a\u4fe1\u606f\uff0c\u5b58\u50a8\u5728mysql\u5e93\u4e2d\u7684user\u8868\u4e2d\u3002<\/p>\n\n\n\n<p>\u4fee\u6539host\u57df\uff0c\u4f7fIP\u53ef\u4ee5\u8fde\u63a5<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql>``update` `user` `set` `host=``'192.168.137.123'` `where` `user` `= ``'root'``;``mysql>flush ``privileges``; ``--\u51b2\u5237\u6743\u9650<\/code><\/pre>\n\n\n\n<p>\u4fee\u6539\u7528\u6237\u5bc6\u7801<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql>``update` `user` `set` `password``=``password``(``'11111111'``) ``where` `xxx;``mysql>flush ``privileges``; ``--\u51b2\u5237\u6743\u9650<\/code><\/pre>\n\n\n\n<h4>12.1.2\u4f60\u6709\u6ca1\u6709\u6743\u6267\u884c\u672c\u64cd\u4f5c<\/h4>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>\u5728mysql\u4e2d\uff0c\u6709\u4e00\u4e2a\u5e93\u662fmysql\u5e93\uff0c\u5728\u8fd9\u4e2a\u5e93\u4e2d\u6709\u4e09\u4e2a\u8868\uff0c\u4e00\u4e2a\u662fuser\u8868\uff0cuser\u8868\u4e2d\u5b58\u50a8\u4e86\u6240\u6709\u7528\u6237\u7684\u6743\u9650\u4fe1\u606f\u3002\u4e00\u4e2a\u662fdb\u8868\uff0cdb\u8868\u5b58\u50a8\u7684\u662f\u6240\u6709\u7528\u6237\u5728\u6570\u636e\u5e93\u5c42\u7684\u6743\u9650\u4fe1\u606f\u3002\u4e00\u4e2a\u662ftables_priv\u8868\uff0ctables_priv\u8868\u5b58\u50a8\u7684\u662f\u6240\u6709\u7528\u6237\u5728\u8868\u5c42\u7684\u6743\u9650\u4fe1\u606f\u3002<\/p><\/blockquote>\n\n\n\n<p>\u7528\u6237\u767b\u5f55\uff0cuser\u8868\u9996\u5148\u80fd\u9650\u5236\u7528\u6237\u767b\u5f55\uff0c\u5176\u6b21\u8fd8\u4fdd\u5b58\u4e86\u8be5\u7528\u6237\u7684\u5168\u5c40\u6743\u9650\uff0c\u5982\u679c\u8be5\u7528\u6237\u6ca1\u6709\u4efb\u4f55\u6743\u9650\uff0c\u90a3\u4e48\u5c06\u4ecedb\u8868\u4e2d\u67e5\u627e\u8be5\u7528\u6237\u662f\u5426\u6709\u67d0\u4e2a\u6570\u636e\u5e93\u7684\u64cd\u4f5c\u6743\u9650\uff0c\u5982\u679c\u90fd\u6ca1\u6709\uff0c\u5c06\u4ecetable_priv\u8868\u4e2d\u67e5\u627e\u8be5\u7528\u6237\u662f\u5426\u6709\u67d0\u4e2a\u8868\u7684\u64cd\u4f5c\u6743\u9650\uff0c\u5982\u679c\u6709\uff0c\u5219\u8be5\u7528\u6237\u53ef\u4ee5\u6309\u7167\u5df2\u6709\u7684\u6743\u9650\u6765\u64cd\u4f5c\u8be5\u8868\u3002<\/p>\n\n\n\n<h3>12.2\u521b\u5efaMySQL\u7684\u7528\u6237<\/h3>\n\n\n\n<p><strong>\u547d\u4ee4:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE USER 'username'@'host' IDENTIFIED BY 'password';<\/code><\/pre>\n\n\n\n<p>\u8bf4\u660e\uff1a<\/p>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>username\uff1a\u4f60\u5c06\u521b\u5efa\u7684\u7528\u6237\u540d.<\/p><p>host\uff1a\u6307\u5b9a\u8be5\u7528\u6237\u5728\u54ea\u4e2a\u4e3b\u673a\u4e0a\u53ef\u4ee5\u767b\u9646\uff0c\u5982\u679c\u662f\u672c\u5730\u7528\u6237\u53ef\u7528localhost\uff0c\u5982\u679c\u60f3\u8ba9\u8be5\u7528\u6237\u53ef\u4ee5\u4ece\u4efb\u610f\u8fdc\u7a0b\u4e3b\u673a\u767b\u9646\uff0c\u53ef\u4ee5\u4f7f\u7528\u901a\u914d\u7b26%\u4ee3\u66ffhost\u3002<\/p><p>password\uff1a\u8be5\u7528\u6237\u7684\u767b\u9646\u5bc6\u7801\uff0c\u5bc6\u7801\u53ef\u4ee5\u4e3a\u7a7a\uff0c\u5982\u679c\u4e3a\u7a7a\u5219\u8be5\u7528\u6237\u53ef\u4ee5\u4e0d\u9700\u8981\u5bc6\u7801\u767b\u9646\u670d\u52a1\u5668\u3002<\/p><\/blockquote>\n\n\n\n<p><strong>\u5173\u4e8e\u521b\u5efa\u7528\u6237\u65f6\u63d0\u793a\u201cOperation CREATE USER failed for XXX\u201d\u7684\u89e3\u51b3\u529e\u6cd5<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img   class=\"lazyload\" data-src=\"https:\/\/img-blog.csdnimg.cn\/20201219222710185.png\" src=\"https:\/\/cdn.jsdelivr.net\/gh\/moezx\/cdn@3.0.2\/img\/svg\/loader\/trans.ajax-spinner-preloader.svg\" onerror=\"imgError(this)\"  alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure >\n<noscript><img src=\"https:\/\/img-blog.csdnimg.cn\/20201219222710185.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure><\/noscript>\n\n\n\n<p>\u51fa\u73b0\u8be5\u539f\u56e0\u7684\u7ed3\u679c\u6709\u53ef\u80fd\u662f\u4f60\u4f7f\u7528\u4e86<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>delete  from  mysql.user  where user ='user_1';<\/code><\/pre>\n\n\n\n<p>\u7684\u8bed\u53e5\u5220\u9664\u7528\u6237\uff0c\u5373\u4f7f\u4f60\u5237\u65b0\u4e86 flush privileges\uff1b\u4e5f\u6ca1\u7528\u3002<\/p>\n\n\n\n<p>\u5220\u9664\u7528\u6237\u9700\u8981\u4f7f\u7528<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>drop user   \u7528\u6237<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img   class=\"lazyload\" data-src=\"https:\/\/img-blog.csdnimg.cn\/20201219222659809.png\" src=\"https:\/\/cdn.jsdelivr.net\/gh\/moezx\/cdn@3.0.2\/img\/svg\/loader\/trans.ajax-spinner-preloader.svg\" onerror=\"imgError(this)\"  alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure >\n<noscript><img src=\"https:\/\/img-blog.csdnimg.cn\/20201219222659809.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure><\/noscript>\n\n\n\n<p>\u7136\u540e\u91cd\u65b0\u8fdb\u884c\u521b\u5efa\u5c31\u597d\u4e86\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>create user 'user_1'@'%' identified by '123456';<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img   class=\"lazyload\" data-src=\"https:\/\/img-blog.csdnimg.cn\/20201219222723856.png\" src=\"https:\/\/cdn.jsdelivr.net\/gh\/moezx\/cdn@3.0.2\/img\/svg\/loader\/trans.ajax-spinner-preloader.svg\" onerror=\"imgError(this)\"  alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure >\n<noscript><img src=\"https:\/\/img-blog.csdnimg.cn\/20201219222723856.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure><\/noscript>\n\n\n\n<h3>12.3\u7528\u6237\u6388\u6743<\/h3>\n\n\n\n<figure class=\"wp-block-image\"><img   class=\"lazyload\" data-src=\"https:\/\/img-blog.csdnimg.cn\/20201219222737701.png?x-oss-process=image\/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTE4NzAwMjI=,size_16,color_FFFFFF,t_70\" src=\"https:\/\/cdn.jsdelivr.net\/gh\/moezx\/cdn@3.0.2\/img\/svg\/loader\/trans.ajax-spinner-preloader.svg\" onerror=\"imgError(this)\"  alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure >\n<noscript><img src=\"https:\/\/img-blog.csdnimg.cn\/20201219222737701.png?x-oss-process=image\/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTE4NzAwMjI=,size_16,color_FFFFFF,t_70\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure><\/noscript>\n\n\n\n<h4>12.3.1\u6388\u6743\u547d\u4ee4\u683c\u5f0f<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT privileges ON databasename.tablename TO 'username'@'host';<\/code><\/pre>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>privileges\uff1a\u7528\u6237\u7684\u64cd\u4f5c\u6743\u9650\uff0c\u5982SELECT\uff0cINSERT\uff0cUPDATE\u7b49\uff0c\u5982\u679c\u8981\u6388\u4e88\u6240\u7684\u6743\u9650\u5219\u4f7f\u7528ALL;<\/p><p>databasename\uff1a\u6570\u636e\u5e93\u540d;<\/p><p>tablename\uff1a\u8868\u540d\uff0c\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<em>\u8868\u793a\uff0c\u5982<\/em>.*;<\/p><\/blockquote>\n\n\n\n<p>\u4f8b\u5b50:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT SELECT, INSERT ON test.user TO 'user_1'@'%';\nGRANT ALL ON *.* TO 'user_1'@'%';\nGRANT ALL ON maindataplus.* TO 'user_1'@'%';<\/code><\/pre>\n\n\n\n<p><strong>\u6ce8\u610f:<\/strong><\/p>\n\n\n\n<p>\u7528\u4ee5\u4e0a\u547d\u4ee4\u6388\u6743\u7684\u7528\u6237\u4e0d\u80fd\u7ed9\u5176\u5b83\u7528\u6237\u6388\u6743\uff0c\u5982\u679c\u60f3\u8ba9\u8be5\u7528\u6237\u53ef\u4ee5\u6388\u6743\uff0c\u7528\u4ee5\u4e0b\u547d\u4ee4:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT privileges ON databasename.tablename TO 'username'@'host' WITH GRANT OPTION;<\/code><\/pre>\n\n\n\n<h4>12.3.2\u4f7f\u7528REVOKE\u547d\u4ee4\u53ef\u4ee5\u56de\u6536\u6388\u4e88\u7684\u6743\u9650\uff0c\u8bed\u6cd5\u683c\u5f0f\u5982\u4e0b\uff1a<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>REVOKE priv_type ON {\u8868\u540d|\u6570\u636e\u5e93\u540d} FROM \u7528\u6237;<\/code><\/pre>\n\n\n\n<p><strong>\u6ce8\uff1a\u53ea\u6709\u62e5\u6709\u5f53\u524d\u6570\u636e\u5e93\u5168\u5c40CREATE\u6216\u8005UPDATE\u6743\u9650\u7684\u7528\u6237\u624d\u80fd\u4f7f\u7528REVOKE\u547d\u4ee4\u3002<\/strong><\/p>\n\n\n\n<h4>12.3.3\u5168\u5c40\u6388\u6743\u548c\u6536\u56de<\/h4>\n\n\n\n<p>\u5168\u5c40\u6388\u6743\u683c\u5f0f\uff08\u4f7f\u7528\u901a\u914d\u7b26*\uff09\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>grant` `&#91;\u6743\u96501,\u6743\u96502,\u6743\u96503] ``on` `*.* ``to` `user``@``'host'` `identified ``by` `'password'<\/code><\/pre>\n\n\n\n<p>\u5e38\u7528\u6743\u9650\uff1aall\u3001create\u3001drop\u3001select\u3001insert\u3001delete\u3001update<\/p>\n\n\n\n<p>\u6388\u6743\uff1a<\/p>\n\n\n\n<p>\u521b\u5efalisi\u7528\u6237\uff0chost\u4e3a192.168.191.%\uff0c%\u901a\u914d\u7b26\u8868\u793a192.168.191.xxx\u7ed3\u5c3e\u7684\u4e3b\u673a\u90fd\u53ef\u4ee5\u8fde\u63a5\uff0c\u5bc6\u7801\u4e3a12345678\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>grant` `all` `on` `*.* ``to` `lisi@``'192.168.191.%'` `identified ``by` `'12345678'``;<\/code><\/pre>\n\n\n\n<p>\u6536\u56de\u6743\u9650\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>revoke` `all` `on` `*.* ``from` `lisi@``'192.168.191.%'``;<\/code><\/pre>\n\n\n\n<h4>12.3.4\u6570\u636e\u5e93\u7ea7\u6388\u6743\u548c\u6536\u56de<\/h4>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>\u9700\u6c42\uff1a\u8ba9lisi\u7528\u6237\u62e5\u6709mysqlmaster\u6570\u636e\u5e93\u7684\u6240\u6709\u64cd\u4f5c\u6743\u9650<\/p><\/blockquote>\n\n\n\n<p>\u6388\u6743\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>grant` `all` `on` `mysqlmaster.* ``to` `lisi@``'192.168.191.%'` `identified ``by` `'12345678'``;<\/code><\/pre>\n\n\n\n<p>\u6536\u56de\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>revoke` `all` `on` `mysqlmaster.* ``from` `lisi@``'192.168.191.%'``;<\/code><\/pre>\n\n\n\n<h4>12.3.5\u8868\u7ea7\u6388\u6743\u548c\u6536\u56de<\/h4>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>\u9700\u6c42\uff1a\u8ba9lisi\u7528\u6237\u5177\u6709mysqlmaster\u6570\u636e\u5e93\u4e0b\u7684goods\u8868\u7684insert\u3001update\u3001select\u4e09\u4e2a\u64cd\u4f5c\u7684\u6743\u9650\u3002<\/p><\/blockquote>\n\n\n\n<p>\u6388\u6743\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>grant` `insert``,``update``,``select` `on` `mysqlmaster.goods ``to` `lisi@``'192.168.191.%'` `identified ``by` `'12345678'``;<\/code><\/pre>\n\n\n\n<p>\u6536\u56de\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>revoke` `insert``,``update``,``select` `on` `mysqlmaster.goods ``from` `lisi@``'192.168.191.%'``;<\/code><\/pre>\n\n\n\n<h3>12.4\u66f4\u65b0\u7528\u6237\u8bed\u6cd5\u683c\u5f0f\u5982\u4e0b\uff1a<\/h3>\n\n\n\n<h4>12.4.1\u5982\u679c\u662f\u4fee\u6539\u5f53\u524d\u767b\u5f55\u7528\u6237\u5bc6\u7801\u8bed\u6cd5\uff1a<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>SET PASSWORD FOR \u7528\u6237=PASSWORD(\u2018\u65b0\u5bc6\u7801\u2019);<\/code><\/pre>\n\n\n\n<h4>12.4.2\u901a\u8fc7\u4fee\u6539mysql\u6570\u636e\u5e93\u4e0b\u7684user\u8868\u4e2d\u7684\u6765\u4fee\u6539\uff08\u4e0d\u53ef\u53d6\uff09<\/h4>\n\n\n\n<p>\u547d\u4ee4\u548cupdate\u666e\u901a\u8868\u4e00\u6837\uff0c\u8bed\u6cd5\u683c\u5f0f\u5982\u4e0b\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>UPDATE MYSQL.USER SET \u5c5e\u6027\u540d= \u65b0\u5c5e\u6027\u503c  WHERE  \u6761\u4ef6;<\/code><\/pre>\n\n\n\n<p>\u6bd4\u5982\uff0c\u4fee\u6539User\u7684\u7528\u6237\u540d\u4e3a\u201cuser_1\u201d\u5c06\u5176\u7528\u6237\u540d\u6539\u4e3a\u201cuser_3\u201d,\u5bc6\u7801\u6539\u4e3a\u201c1234\u201d\u3002<\/p>\n\n\n\n<blockquote class=\"wp-block-quote\"><p><strong>\u6ce8\u610f\uff1aMySQL8\u4e4b\u524d\u4fee\u6539\u5bc6\u7801\u662f set password= password(\"\u65b0\u5bc6\u7801\");\u800cMySQL8\u662f set authentication_string = \"\u65b0\u5bc6\u7801\".\u4e5f\u5c31\u662fMySQL8\u7684\u5bc6\u7801\u5b57\u6bb5\u4e3aauthentication_string \u3002<\/strong><\/p><\/blockquote>\n\n\n\n<pre class=\"wp-block-code\"><code>update mysql.user set user =\"user_3\" ,authentication_string =\"1234\" where user =\"user_1\";<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img   class=\"lazyload\" data-src=\"https:\/\/img-blog.csdnimg.cn\/20201219222828962.png?x-oss-process=image\/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTE4NzAwMjI=,size_16,color_FFFFFF,t_70\" src=\"https:\/\/cdn.jsdelivr.net\/gh\/moezx\/cdn@3.0.2\/img\/svg\/loader\/trans.ajax-spinner-preloader.svg\" onerror=\"imgError(this)\"  alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure >\n<noscript><img src=\"https:\/\/img-blog.csdnimg.cn\/20201219222828962.png?x-oss-process=image\/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTE4NzAwMjI=,size_16,color_FFFFFF,t_70\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure><\/noscript>\n\n\n\n<p>\u53ef\u4ee5\u53d1\u73b0\u5982\u679c\u76f4\u63a5\u4f7f\u7528 set authentication_string ='\u65b0\u5bc6\u7801',\u90a3\u4e48\u8be5\u5bc6\u7801\u76f4\u63a5\u88ab\u586b\u5145\u5230\u7528\u6237\u4e2d\u800c\u6ca1\u6709\u7ecf\u8fc7\u52a0\u5bc6\u3002\u800c\u6211\u4eec\u77e5\u9053\uff0cMySQL\u7684\u5bc6\u7801\u662f\u7ecf\u8fc7\u52a0\u5bc6\u7684\uff0c\u56e0\u6b64\u8fd9\u6837\u5b50\u4f7f\u7528update\u4fee\u6539\u5bc6\u7801\u662f\u6709\u95ee\u9898\u7684\uff0c\u5728\u4f60\u767b\u5f55\u65f6\u5019\u867d\u7136\u7528\u6237\u540d\u548c\u5bc6\u7801\u90fd\u6b63\u786e\uff0c\u4f46\u662f\u5374\u6ca1\u6cd5\u8fdb\u884c\u767b\u5f55\uff0c\u4f1a\u63d0\u793a\u201c Access denied for user 'user_3'@'117.154.88.249' (using password: YES)\u201d\u3002<\/p>\n\n\n\n<p>\u200b MySQL8.0\u540e\u8bf7\u4f7f\u7528alter\u4fee\u6539\u7528\u6237\u5bc6\u7801\uff0c\u56e0\u4e3a\u5728MySQL8.0\u4ee5\u540e\u7684\u52a0\u5bc6\u65b9\u5f0f\u4e3acaching_sha2_password\uff0c\u5982\u679c\u4f7f\u7528update\u4fee\u6539\u5bc6\u7801\u4f1a\u7ed9user\u8868\u4e2droot\u7528\u6237\u7684authentication_string\u5b57\u6bb5\u4e0b\u8bbe\u7f6enewpassowrd\u503c\uff0c\u5f53\u518d\u4f7f\u7528alter user 'root'@'localhost' identified by 'newpassword'\u4fee\u6539\u5bc6\u7801\u65f6\u4f1a\u4e00\u76f4\u62a5\u9519\uff0c<strong>\u5fc5\u987b\u6e05\u7a7a\u540e\u518d\u4fee\u6539<\/strong>\uff08\u5982\u679c\u4e0d\u9996\u5148\u6e05\u7a7a\u8fd9\u4e2aauthentication_string\uff0c\u5728\u4f7f\u7528alter user \u8fdb\u884c\u4fee\u6539\u65f6\u4f1a\u53d1\u751f\u201cOperation ALTER USER failed for XXX\u201d\u7684\u63d0\u793a\uff09<br><img   class=\"lazyload\" data-src=\"https:\/\/img-blog.csdnimg.cn\/20201219222902234.png?x-oss-process=image\/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTE4NzAwMjI=,size_16,color_FFFFFF,t_70\" src=\"https:\/\/cdn.jsdelivr.net\/gh\/moezx\/cdn@3.0.2\/img\/svg\/loader\/trans.ajax-spinner-preloader.svg\" onerror=\"imgError(this)\"  alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"><\/p >\n<noscript><img src=\"https:\/\/img-blog.csdnimg.cn\/20201219222902234.png?x-oss-process=image\/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTE4NzAwMjI=,size_16,color_FFFFFF,t_70\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"><\/p><\/noscript>\n\n\n\n<p><strong>\u56e0\u4e3aauthentication_string\u5b57\u6bb5\u4e0b\u53ea\u80fd\u662fMySQL\u52a0\u5bc6\u540e\u768443\u4f4d\u5b57\u7b26\u4e32\u5bc6\u7801\uff0c\u5176\u4ed6\u7684\u4f1a\u62a5\u683c\u5f0f\u9519\u8bef\uff0c\u6240\u4ee5\u5728MySQL8.0\u4ee5\u540e\u80fd\u4fee\u6539\u5bc6\u7801\u7684\u65b9\u6cd5\u53ea\u80fd\u662f\u4f7f\u7528alter\u6765\u4fee\u6539\uff1a<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER USER   \u7528\u6237   IDENTIFIED  WITH mysql_native_password BY '\u65b0\u5bc6\u7801';\n#\u6216\u8005\u662f\nALTER USER \u7528\u6237 IDENTIFIED BY \u2018\u65b0\u5bc6\u7801\u2019;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img   class=\"lazyload\" data-src=\"https:\/\/img-blog.csdnimg.cn\/20201219222919528.png?x-oss-process=image\/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTE4NzAwMjI=,size_16,color_FFFFFF,t_70\" src=\"https:\/\/cdn.jsdelivr.net\/gh\/moezx\/cdn@3.0.2\/img\/svg\/loader\/trans.ajax-spinner-preloader.svg\" onerror=\"imgError(this)\"  alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure >\n<noscript><img src=\"https:\/\/img-blog.csdnimg.cn\/20201219222919528.png?x-oss-process=image\/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTE4NzAwMjI=,size_16,color_FFFFFF,t_70\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure><\/noscript>\n\n\n\n<p>\u6bd4\u5982\uff1a\u5c06\u7528\u6237 \u2018user_1\u2019@\u2018%\u2019 \u7684\u5bc6\u7801\u6539\u4e3a\u201c1234\u201d<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER USER \u2018user_1\u2019@\u2018%\u2019 IDENTIFIED BY \u20181234\u2019;\n#\u6216\u8005\nALTER USER   \u2018user_1\u2019@\u2018%\u2019    IDENTIFIED  WITH mysql_native_password BY '1234';<\/code><\/pre>\n\n\n\n<p>\u6700\u540e\u5237\u65b0\u4e00\u5b9a\u8981\u5237\u65b0\u4e0b<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>flush privileges;<\/code><\/pre>\n\n\n\n<h3>12.5\u67e5\u8be2\u67d0\u4e2a\u7528\u6237\u6743\u9650<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>show grants for  \u7528\u6237;<\/code><\/pre>\n\n\n\n<p>\u6bd4\u5982\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>show grants for 'user_1'@'%';<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img   class=\"lazyload\" data-src=\"https:\/\/img-blog.csdnimg.cn\/20201219222934436.png?x-oss-process=image\/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTE4NzAwMjI=,size_16,color_FFFFFF,t_70\" src=\"https:\/\/cdn.jsdelivr.net\/gh\/moezx\/cdn@3.0.2\/img\/svg\/loader\/trans.ajax-spinner-preloader.svg\" onerror=\"imgError(this)\"  alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure >\n<noscript><img src=\"https:\/\/img-blog.csdnimg.cn\/20201219222934436.png?x-oss-process=image\/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTE4NzAwMjI=,size_16,color_FFFFFF,t_70\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure><\/noscript>\n\n\n\n<h3>12.6\u5220\u9664\u7528\u6237<\/h3>\n\n\n\n<h4>12.6.1\u4f7f\u7528drop\u547d\u4ee4<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>drop user \u7528\u6237;<\/code><\/pre>\n\n\n\n<p>\u6bd4\u5982\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>drop user  'user_1'@'%';<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img   class=\"lazyload\" data-src=\"https:\/\/img-blog.csdnimg.cn\/20201219222945417.png\" src=\"https:\/\/cdn.jsdelivr.net\/gh\/moezx\/cdn@3.0.2\/img\/svg\/loader\/trans.ajax-spinner-preloader.svg\" onerror=\"imgError(this)\"  alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure >\n<noscript><img src=\"https:\/\/img-blog.csdnimg.cn\/20201219222945417.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure><\/noscript>\n\n\n\n<p>\u5220\u9664\u7684\u662f \u7528\u6237 'user_1'@'%'\u3002<\/p>\n\n\n\n<h4>12.6.2\u4f7f\u7528delete\u547d\u4ee4<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>delete from  mysql.user  where  \u6761\u4ef6<\/code><\/pre>\n\n\n\n<p>\u6bd4\u5982\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>delete from  mysql.user where user='user_1' and host ='%';<\/code><\/pre>\n\n\n\n<p>\u5220\u9664\u7684\u662f \u7528\u6237 'user_1'@'%'\u3002<\/p>\n\n\n\n<h4>12.6.3\u4f7f\u7528drop\u548cdelete\u547d\u4ee4\u7684\u533a\u522b<\/h4>\n\n\n\n<h5>12.6.3.1drop user \u7528\u6237\u540d;<\/h5>\n\n\n\n<p>\u5220\u9664\u5df2\u7ecf\u5b58\u5728\u7684\u7528\u6237\uff0c\u4f8b\u5982\u8981\u5220\u9664\u2018user_1\u2019\u8fd9\u4e2a\u7528\u6237\uff0c(drop user 'user_1';)\u9ed8\u8ba4\u5220\u9664\u7684\u662fuser_1@\u201d%\u201d\u8fd9\u4e2a\u7528\u6237\uff0c\u5982\u679c\u8fd8\u6709\u5176\u4ed6\u7528\u6237\uff0c\u4f8b\u5982user_1@\u201dlocalhost\u201d,user_1@\u201dip\u201d,\u5219\u4e0d\u4f1a\u4e00\u8d77\u88ab\u5220\u9664\u3002\u5982\u679c\u53ea\u5b58\u5728\u4e00\u4e2a\u7528\u6237'user_1'@\u201dlocalhost\u201d,\u4f7f\u7528\u8bed\u53e5\uff08drop user 'user_1';\uff09\u4f1a\u62a5\u9519\uff0c\u5e94\u8be5\u7528\uff08drop user 'user_1'@\u201dlocalhost\u201d;\uff09\u5982\u679c\u4e0d\u80fd\u786e\u5b9a\uff08\u7528\u6237\u540d@\u673a\u5668\u540d\uff09\u4e2d\u7684\u673a\u5668\u540d\uff0c\u53ef\u4ee5\u5728mysql\u4e2d\u7684user\u8868\u4e2d\u8fdb\u884c\u67e5\u627e\uff0cuser\u5217\u5bf9\u5e94\u7684\u662f\u7528\u6237\u540d\uff0chost\u5217\u5bf9\u5e94\u7684\u662f\u673a\u5668\u540d\u3002<\/p>\n\n\n\n<h5>12.6.3.5 delete from user where user=\u201d\u7528\u6237\u540d\u201d and host=\u201dlocalhost\u201d;<\/h5>\n\n\n\n<p>delete\u4e5f\u662f\u5220\u9664\u7528\u6237\u7684\u65b9\u6cd5\uff0c\u4f8b\u5982\u8981\u5220\u9664'user_1'@\u201dlocalhost\u201d\u7528\u6237\uff0c\u5219\u53ef\u4ee5<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>delete from user where user=\u201duser_1\u201d and host=\u201dlocalhost\u201d;<\/code><\/pre>\n\n\n\n<p><strong>drop\u5220\u9664\u6389\u7684\u7528\u6237\u4e0d\u4ec5\u5c06user\u8868\u4e2d\u7684\u6570\u636e\u5220\u9664\uff0c\u8fd8\u4f1a\u5220\u9664\u8bf8\u5982db\u548c\u5176\u4ed6\u6743\u9650\u8868\u7684\u5185\u5bb9\u3002\u800c\uff08delete from mysql.user\uff09\u53ea\u662f\u5220\u9664\u4e86mysql\u6570\u636e\u5e93\u4e2duser\u8868\u7684\u5185\u5bb9\uff0c\u5176\u4ed6\u8868\u4e0d\u4f1a\u88ab\u5220\u9664\uff0c\u540e\u671f\u5982\u679c\u547d\u540d\u4e00\u4e2a\u548c\u5df2\u5220\u9664\u7528\u6237\u76f8\u540c\u7684\u540d\u5b57\uff0c\u6743\u9650\u5c31\u4f1a\u88ab\u7ee7\u627f\u3002<\/strong><\/p>\n\n\n\n<h3>12.7\u6d4b\u8bd5\u7528\u4f8b<\/h3>\n\n\n\n<h5>12.7.1.\u521b\u5efa\u7528\u6237user_1\u548cuser_2\uff0c\u5bc6\u7801\u90fd\u4e3a123456<\/h5>\n\n\n\n<pre class=\"wp-block-code\"><code> create user 'user_1'@'%' identified by \"123456\";\ncreate user 'user_2'@'%' identified by \"123456\";<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img   class=\"lazyload\" data-src=\"https:\/\/img-blog.csdnimg.cn\/20201219223013117.png?x-oss-process=image\/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTE4NzAwMjI=,size_16,color_FFFFFF,t_70\" src=\"https:\/\/cdn.jsdelivr.net\/gh\/moezx\/cdn@3.0.2\/img\/svg\/loader\/trans.ajax-spinner-preloader.svg\" onerror=\"imgError(this)\"  alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure >\n<noscript><img src=\"https:\/\/img-blog.csdnimg.cn\/20201219223013117.png?x-oss-process=image\/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTE4NzAwMjI=,size_16,color_FFFFFF,t_70\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure><\/noscript>\n\n\n\n<h5>12.7.2.\u5c06\u7528\u6237user_2\u7684\u540d\u79f0\u4fee\u6539\u4e3auser_3\uff0c\u5e76\u5c06\u5176\u5bc6\u7801\u4fee\u6539\u4e3a1234<\/h5>\n\n\n\n<figure class=\"wp-block-image\"><img   class=\"lazyload\" data-src=\"https:\/\/img-blog.csdnimg.cn\/20201219225514201.png?x-oss-process=image\/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTE4NzAwMjI=,size_16,color_FFFFFF,t_70\" src=\"https:\/\/cdn.jsdelivr.net\/gh\/moezx\/cdn@3.0.2\/img\/svg\/loader\/trans.ajax-spinner-preloader.svg\" onerror=\"imgError(this)\"  alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure >\n<noscript><img src=\"https:\/\/img-blog.csdnimg.cn\/20201219225514201.png?x-oss-process=image\/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTE4NzAwMjI=,size_16,color_FFFFFF,t_70\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure><\/noscript>\n\n\n\n<p>\u9996\u5148\u4f7f\u7528update mysql.user\u8bed\u53e5\u6765\u66f4\u65b0user_2\u4e2d\u7684\u7528\u6237\u540d<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>update  mysql.user set user ='user_3' where  user ='user_2' and host='%';<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img   class=\"lazyload\" data-src=\"https:\/\/img-blog.csdnimg.cn\/20201219225546215.png\" src=\"https:\/\/cdn.jsdelivr.net\/gh\/moezx\/cdn@3.0.2\/img\/svg\/loader\/trans.ajax-spinner-preloader.svg\" onerror=\"imgError(this)\"  alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure >\n<noscript><img src=\"https:\/\/img-blog.csdnimg.cn\/20201219225546215.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure><\/noscript>\n\n\n\n<p>\u7136\u540e\u4f7f\u7528alter\u547d\u4ee4\u4fee\u6539\u5bc6\u7801\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>alter user 'user_3'@'%' identified with mysql_native_password by '1234';<\/code><\/pre>\n\n\n\n<p><img   class=\"lazyload\" data-src=\"https:\/\/img-blog.csdnimg.cn\/20201219225616722.png\" src=\"https:\/\/cdn.jsdelivr.net\/gh\/moezx\/cdn@3.0.2\/img\/svg\/loader\/trans.ajax-spinner-preloader.svg\" onerror=\"imgError(this)\"  alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"><br>\u8fd9\u6837\u5c31\u80fd\u5b8c\u6210\u5c06user_2\u8868\u6539\u4e3auser_3\u8868\u5e76\u4e14\u4fee\u6539\u5bf9\u5e94\u7684\u7684\u4ee3\u7801\u4e86\u3002<\/p >\n<noscript><img src=\"https:\/\/img-blog.csdnimg.cn\/20201219225616722.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"><br>\u8fd9\u6837\u5c31\u80fd\u5b8c\u6210\u5c06user_2\u8868\u6539\u4e3auser_3\u8868\u5e76\u4e14\u4fee\u6539\u5bf9\u5e94\u7684\u7684\u4ee3\u7801\u4e86\u3002<\/p><\/noscript>\n\n\n\n<h5>12.7.3.\u4ee5user_1\u8eab\u4efd\u767b\u9646\u6570\u636e\u5e93<\/h5>\n\n\n\n<figure class=\"wp-block-image\"><img   class=\"lazyload\" data-src=\"https:\/\/img-blog.csdnimg.cn\/20201219225749378.png?x-oss-process=image\/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTE4NzAwMjI=,size_16,color_FFFFFF,t_70\" src=\"https:\/\/cdn.jsdelivr.net\/gh\/moezx\/cdn@3.0.2\/img\/svg\/loader\/trans.ajax-spinner-preloader.svg\" onerror=\"imgError(this)\"  alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure >\n<noscript><img src=\"https:\/\/img-blog.csdnimg.cn\/20201219225749378.png?x-oss-process=image\/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTE4NzAwMjI=,size_16,color_FFFFFF,t_70\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure><\/noscript>\n\n\n\n<p>\u4ece\u53ef\u4ee5\u53d1\u73b0\u53ef\u4ee5\u8fdc\u7a0b\u767b\u5f55\u4e86\u3002<\/p>\n\n\n\n<h5>12.7.4.\u6388\u4e88\u7528\u6237user_1\u5bf9DBEM\u6570\u636e\u5e93\u4e2demployee\u8868\u7684\u67e5\u8be2\u3001\u63d2\u5165\u3001\u4fee\u6539\u3001\u5220\u9664\u7b49\u6743\u9650\u3002<\/h5>\n\n\n\n<pre class=\"wp-block-code\"><code>grant insert,update,select,delete on dbms.employee to 'user_1'@'%';<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img   class=\"lazyload\" data-src=\"https:\/\/img-blog.csdnimg.cn\/20201219225830143.png\" src=\"https:\/\/cdn.jsdelivr.net\/gh\/moezx\/cdn@3.0.2\/img\/svg\/loader\/trans.ajax-spinner-preloader.svg\" onerror=\"imgError(this)\"  alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure >\n<noscript><img src=\"https:\/\/img-blog.csdnimg.cn\/20201219225830143.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure><\/noscript>\n\n\n\n<figure class=\"wp-block-image\"><img   class=\"lazyload\" data-src=\"https:\/\/img-blog.csdnimg.cn\/20201219225841379.png?x-oss-process=image\/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTE4NzAwMjI=,size_16,color_FFFFFF,t_70\" src=\"https:\/\/cdn.jsdelivr.net\/gh\/moezx\/cdn@3.0.2\/img\/svg\/loader\/trans.ajax-spinner-preloader.svg\" onerror=\"imgError(this)\"  alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure >\n<noscript><img src=\"https:\/\/img-blog.csdnimg.cn\/20201219225841379.png?x-oss-process=image\/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTE4NzAwMjI=,size_16,color_FFFFFF,t_70\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure><\/noscript>\n\n\n\n<h5>12.7.5.\u6388\u4e88\u7528\u6237user_1\u5bf9salary\u8868\u7684\u67e5\u8be2\u6743\u9650\uff0c\u5e76\u5141\u8bb8\u5176\u5c06\u6743\u9650\u6388\u4e88\u5176\u4ed6\u7528\u6237\uff0c\u7136\u540e\u7528user_1\u767b\u9646\u6570\u636e\u5e93\u5e76\u5c06salary\u8868\u7684\u67e5\u8be2\u6743\u9650\u6388\u4e88user_3\u3002<\/h5>\n\n\n\n<p>\u9996\u5148\u7ed9\u4e0euser_1\u5bf9salary\u8868\u7684\u67e5\u8be2\u6743\u9650\u5e76\u5141\u8bb8\u5176\u5c06\u6743\u9650\u6388\u4e88\u5176\u4ed6\u7528\u6237\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>grant select on dbms.salary to 'user_1'@'%' with grant option;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img   class=\"lazyload\" data-src=\"https:\/\/img-blog.csdnimg.cn\/20201219225900266.png\" src=\"https:\/\/cdn.jsdelivr.net\/gh\/moezx\/cdn@3.0.2\/img\/svg\/loader\/trans.ajax-spinner-preloader.svg\" onerror=\"imgError(this)\"  alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure >\n<noscript><img src=\"https:\/\/img-blog.csdnimg.cn\/20201219225900266.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure><\/noscript>\n\n\n\n<p>\u7136\u540e\u4f7f\u7528user_1\u7684\u7528\u6237\u540d\u548c\u5bc6\u7801\u767b\u5f55user_1\u8fdb\u5165\u6570\u636e\u5e93\u4e2d\uff0c\u5e76\u5c06\u5bf9salary\u8868\u7684\u67e5\u8be2\u6743\u9650\u7ed9user_3:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>grant select on dbms.salary to 'user_3'@'%';<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img   class=\"lazyload\" data-src=\"https:\/\/img-blog.csdnimg.cn\/20201219225920619.png?x-oss-process=image\/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTE4NzAwMjI=,size_16,color_FFFFFF,t_70\" src=\"https:\/\/cdn.jsdelivr.net\/gh\/moezx\/cdn@3.0.2\/img\/svg\/loader\/trans.ajax-spinner-preloader.svg\" onerror=\"imgError(this)\"  alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure >\n<noscript><img src=\"https:\/\/img-blog.csdnimg.cn\/20201219225920619.png?x-oss-process=image\/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTE4NzAwMjI=,size_16,color_FFFFFF,t_70\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure><\/noscript>\n\n\n\n<h5>12.7.7.\u56de\u6536user_1\u7684employee\u8868\u4e0a\u7684select\u6743<\/h5>\n\n\n\n<pre class=\"wp-block-code\"><code>revoke select on dbms.employee from 'user_1'@'%';<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img   class=\"lazyload\" data-src=\"https:\/\/img-blog.csdnimg.cn\/20201219225948569.png?x-oss-process=image\/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTE4NzAwMjI=,size_16,color_FFFFFF,t_70\" src=\"https:\/\/cdn.jsdelivr.net\/gh\/moezx\/cdn@3.0.2\/img\/svg\/loader\/trans.ajax-spinner-preloader.svg\" onerror=\"imgError(this)\"  alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure >\n<noscript><img src=\"https:\/\/img-blog.csdnimg.cn\/20201219225948569.png?x-oss-process=image\/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTE4NzAwMjI=,size_16,color_FFFFFF,t_70\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"\/><\/figure><\/noscript>\n\n\n\n<p>\u53ef\u4ee5\u53d1\u73b0\uff0cuser_1\u4e0a\u7684\u8868\u7684select\u6743\u9650\u5df2\u7ecf\u88ab\u6536\u56de\u4e86\u3002<\/p>\n\n\n\n<h3>12.8\u6574\u7406\u7b14\u8bb0\u4e0d\u6613\uff0c\u5982\u679c\u6709\u5e2e\u52a9\u5230\u4f60\uff0c\u8bf7\u7ed9\u4e2a\u4e00\u952e\u4e09\u8fde\u3002<\/h3>\n\n\n\n<h3>12.9\u8be6\u7ec6\u7684\u5b9e\u9a8c\u8d44\u6599\u4ee5\u53ca\u6307\u5bfcPPT\u8bf7\u8bbf\u95ee\u7b14\u8005GitHub\u5730\u5740\uff1a<a href=\"https:\/\/github.com\/LJF2402901363\/database_experiment.git\" target=\"_blank\"  rel=\"nofollow\" >https:\/\/github.com\/LJF2402901363\/database_experiment.git<\/a><\/h3>\n\n\n\n<h3><\/h3>\n","protected":false},"excerpt":{"rendered":"<p>12.1MySQL\u7684\u6743\u9650 \u7528\u6237\u8fde\u63a5\u5230MySQL\uff0c\u53ef\u4ee5\u505a\u5404\u79cd\u67e5\u8be2\uff0c\u8fd9\u90fd\u662fMySQL\u7528\u6237\u4e0e\u6743\u9650\u529f\u80fd\u5728\u80cc\u540e\u7ef4\u6301\u7740\u64cd\u4f5c\u3002 \u7528\u6237\u4e0e\u6570\u636e\u5e93\u670d\u52a1 &#8230;<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[120],"tags":[],"_links":{"self":[{"href":"http:\/\/moyisuiying.com\/index.php\/wp-json\/wp\/v2\/posts\/441"}],"collection":[{"href":"http:\/\/moyisuiying.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/moyisuiying.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/moyisuiying.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/moyisuiying.com\/index.php\/wp-json\/wp\/v2\/comments?post=441"}],"version-history":[{"count":3,"href":"http:\/\/moyisuiying.com\/index.php\/wp-json\/wp\/v2\/posts\/441\/revisions"}],"predecessor-version":[{"id":444,"href":"http:\/\/moyisuiying.com\/index.php\/wp-json\/wp\/v2\/posts\/441\/revisions\/444"}],"wp:attachment":[{"href":"http:\/\/moyisuiying.com\/index.php\/wp-json\/wp\/v2\/media?parent=441"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/moyisuiying.com\/index.php\/wp-json\/wp\/v2\/categories?post=441"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/moyisuiying.com\/index.php\/wp-json\/wp\/v2\/tags?post=441"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}