《Mysql學習淺析drop user與delete from mysql.user的區別》要點：
本文介紹了Mysql學習淺析drop user與delete from mysql.user的區別，希望對您有用。如果有疑問，可以聯系我們。

drop? user 會將該用戶的信息全部刪掉,而 delete? 只會清除user表,其他的比如db表中的信息還是存在.
如果delete 后,再創建一個最小權限的用戶,那么他會重用以前的權限.
grant all on test.* to 'test'@'%' identified by 'test';
delete? from user? where? user =test;
差看db 表
mysql> select * from db;
+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+------------------+----------------+---------------------+--------------------+--------------+------------+--------------+
| Host | Db????? | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Execute_priv | Event_priv | Trigger_priv |
+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+------------------+----------------+---------------------+--------------------+--------------+------------+--------------+
| %??? | test??? |????? | Y?????????? | Y?????????? | Y?????????? | Y?????????? | Y?????????? | Y???????? | N????????? | Y?????????????? | Y????????? | Y????????? | Y???????????????????? | Y??????????????? | Y??????????????? | Y????????????? | Y?????????????????? | N????????????????? | N??????????? | Y????????? | Y??????????? |
| %??? | test\_% |????? | Y?????????? | Y?????????? | Y?????????? | Y?????????? | Y?????????? | Y???????? | N????????? | Y?????????????? | Y????????? | Y????????? | Y???????????????????? | Y??????????????? | Y??????????????? | Y????????????? | Y?????????????????? | N????????????????? | N??????????? | Y????????? | Y??????????? |
| %??? | test??? | test | Y?????????? | Y?????????? | Y?????????? | Y?????????? | Y?????????? | Y???????? | N????????? | Y?????????????? | Y????????? | Y????????? | Y???????????????????? | Y??????????????? | Y??????????????? | Y????????????? | Y?????????????????? | Y????????????????? | Y??????????? | Y????????? | Y??????????? |
+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+------------------+----------------+---------------------+--------------------+--------------+------------+--------------+
3 rows in set (0.00 sec)
test? 的權限依然存在
創建一個只有select 的 用戶test
grant select? on test.* to 'test'@'%' identified by 'test';
mysql> select * from db;
+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+------------------+----------------+---------------------+--------------------+--------------+------------+--------------+
| Host | Db????? | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Execute_priv | Event_priv | Trigger_priv |
+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+------------------+----------------+---------------------+--------------------+--------------+------------+--------------+
| %??? | test??? |????? | Y?????????? | Y?????????? | Y?????????? | Y?????????? | Y?????????? | Y???????? | N????????? | Y?????????????? | Y????????? | Y????????? | Y???????????????????? | Y??????????????? | Y??????????????? | Y????????????? | Y?????????????????? | N????????????????? | N??????????? | Y????????? | Y??????????? |
| %??? | test\_% |????? | Y?????????? | Y?????????? | Y?????????? | Y?????????? | Y?????????? | Y???????? | N????????? | Y?????????????? | Y????????? | Y????????? | Y???????????????????? | Y??????????????? | Y??????????????? | Y????????????? | Y?????????????????? | N????????????????? | N??????????? | Y????????? | Y??????????? |
| %??? | test??? | test | Y?????????? | Y?????????? | Y?????????? | Y?????????? | Y?????????? | Y???????? | N????????? | Y?????????????? | Y????????? | Y????????? | Y???????????????????? | Y??????????????? | Y??????????????? | Y????????????? | Y?????????????????? | Y????????????????? | Y??????????? | Y????????? | Y??????????? |
+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+------------------+----------------+---------------------+--------------------+--------------+------------+--------------+
3 rows in set (0.00 sec)
權限和以前的一樣.

轉載請注明本頁網址：
http://www.snjht.com/jiaocheng/3381.html