mysql中删除用户权限
来源:互联网 发布:编程培训机构哪个好 编辑:程序博客网 时间:2024/06/05 16:55
revoke:只删除了用户权限,但没有删除这个用户
mysql> select user,host from user;
+------------------+-----------+
| user | host |
+------------------+-----------+
| root | 127.0.0.1 |
| debian-sys-maint | localhost |
| root | localhost |
| xbb | localhost |
| root | wangxg |
+------------------+-----------+
mysql> revoke insert,update,delete,select ON *.* from 'xbb'@'localhost' IDENTIFIED BY '123';
mysql> select user,host from user;
+------------------+-----------+
| user | host |
+------------------+-----------+
| root | 127.0.0.1 |
| debian-sys-maint | localhost |
| root | localhost |
| xbb | localhost |
| root | wangxg |
+------------------+-----------+
5 rows in set (0.00 sec)
mysql> show grants for xbb@localhost;
+------------------------------------------------------------------------------------------------------------+
| Grants for xbb@localhost |
+------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'xbb'@'localhost' IDENTIFIED BY PASSWORD '*23AE809DDACAF96AF0FD78ED04B6A265E05AA257' |
+------------------------------------------------------------------------------------------------------------+
drop user:删除了整个用户及其权限(包括数据字典中的数据)
mysql> drop user 'xbb'@'localhost';
Query OK, 0 rows affected (0.00 sec)
mysql> select user,host from user;
+------------------+-----------+
| user | host |
+------------------+-----------+
| root | 127.0.0.1 |
| debian-sys-maint | localhost |
| root | localhost |
| root | wangxg |
+------------------+-----------+
4 rows in set (0.00 sec)
delete from user:删除了mysql库中某一用户,(但不能删除数据字典【information_schema】中相关的记录)
mysql> GRANT insert,update,delete,select ON *.* TO 'xbb'@'localhost' IDENTIFIED BY '123';
Query OK, 0 rows affected (0.00 sec)
mysql> select user,host from user;
+------------------+-----------+
| user | host |
+------------------+-----------+
| root | 127.0.0.1 |
| debian-sys-maint | localhost |
| root | localhost |
| xbb | localhost |
| root | wangxg |
+------------------+-----------+
5 rows in set (0.00 sec)
mysql> delect * from user where user ='xbb';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'delect * from user where user ='xbb'' at line 1
mysql> delete * from user where user ='xbb';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* from user where user ='xbb'' at line 1
mysql> delete from user where user ='xbb';
Query OK, 1 row affected (0.09 sec)
mysql> select user,host from user;
+------------------+-----------+
| user | host |
+------------------+-----------+
| root | 127.0.0.1 |
| debian-sys-maint | localhost |
| root | localhost |
| root | wangxg |
+------------------+-----------+
4 rows in set (0.00 sec)
- mysql中删除用户权限
- mysql中删除用户权限
- MySQL中删除用户权限
- mysql 创建用户删除用户增加用户权限
- Mysql创建、删除用户,更改用户权限命令
- MySQL中导出用户权限设置的脚本
- mysql中用户权限导出的脚本
- MySQL用户权限
- MySQL用户权限
- mysql用户权限
- MySql 用户权限
- Mysql 用户权限
- mysql 用户权限
- mysql 用户权限
- MySQL用户权限
- mysql 用户权限
- MySQL用户权限
- MySQL 用户权限
- 屏蔽网页右键,兼容IE6,IE7,IE8,FireFox,谷歌Chrome浏览器
- IOS 可变参数
- CSharp学习笔记之十二 委托与事件(续)
- 算法与计算复杂度
- Android通讯录开发之取得姓名首字母实现简拼搜索
- mysql中删除用户权限
- 安装linux jdk下出现的问题
- 2013-12-27一次关于子查询的优化
- java1-基本的doc命令
- SQL*Loader使用方法
- 细粒度 自定义注解 权限控制具体实现
- android应用版本自动更新
- Linux下makefile教程
- eclipse远程调试mapreduce程序