| 您的当前位置：首页 --> MYSQL教程 --> 浅析drop user与delete from mysql.user的区别 |
| MYSQL教程 浅析drop user与delete from mysql.user的区别 |
| 浏览次数:1181 关键词 （ ） |
| 查看使用该CPU的产品 查看CPU天梯 |
| CPU型号：浅析drop user与delete from mysql.user的区别 |
| 主频：Ghz |
| 睿频：Ghz |
| 核心数：个 |
| 不支持超核心 |
| 制作工艺： |
| 插槽类型： |
| 功耗：0W |
| L3缓存：0MB |
| 支持最大内存： 0GB |
| CPU详细参数 |
|
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) 权限和以前的一样。 |
| 下一个产品 SQL计算timestamp的差值的方法 上一个产品 基于mysql体系结构的深入解析 |
QQ:1668121212