mysql shell 查看 所有用户的 授权列表
来源：互联网 发布：钱龙软件使用说明 编辑：程序博客网 时间：2024/05/18 19:19
[root@localhost ~]# mysql -h localhost -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 166476
Server version: 5.6.25 MySQL Community Server (GPL)
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> select * from information_schema.user_privileges;
+----------------------------+---------------+-------------------------+--------------+
| GRANTEE | TABLE_CATALOG | PRIVILEGE_TYPE | IS_GRANTABLE |
+----------------------------+---------------+-------------------------+--------------+
| 'root'@'localhost' | def | SELECT | YES |
| 'root'@'localhost' | def | INSERT | YES |
| 'root'@'localhost' | def | UPDATE | YES |
| 'root'@'localhost' | def | DELETE | YES |
| 'root'@'localhost' | def | CREATE | YES |
| 'root'@'localhost' | def | DROP | YES |
| 'root'@'localhost' | def | RELOAD | YES |
| 'root'@'localhost' | def | SHUTDOWN | YES |
| 'root'@'localhost' | def | PROCESS | YES |
| 'root'@'localhost' | def | FILE | YES |
| 'root'@'localhost' | def | REFERENCES | YES |
| 'root'@'localhost' | def | INDEX | YES |
| 'root'@'localhost' | def | ALTER | YES |
| 'root'@'localhost' | def | SHOW DATABASES | YES |
| 'root'@'localhost' | def | SUPER | YES |
| 'root'@'localhost' | def | CREATE TEMPORARY TABLES | YES |
| 'root'@'localhost' | def | LOCK TABLES | YES |
| 'root'@'localhost' | def | EXECUTE | YES |
| 'root'@'localhost' | def | REPLICATION SLAVE | YES |
| 'root'@'localhost' | def | REPLICATION CLIENT | YES |
| 'root'@'localhost' | def | CREATE VIEW | YES |
| 'root'@'localhost' | def | SHOW VIEW | YES |
| 'root'@'localhost' | def | CREATE ROUTINE | YES |
| 'root'@'localhost' | def | ALTER ROUTINE | YES |
| 'root'@'localhost' | def | CREATE USER | YES |
| 'root'@'localhost' | def | EVENT | YES |
| 'root'@'localhost' | def | TRIGGER | YES |
| 'root'@'localhost' | def | CREATE TABLESPACE | YES |
| 'hzshark'@'localhost' | def | USAGE | NO |
| 'hzshark'@'10.155.34.210' | def | SELECT | NO |
| 'hzshark'@'10.155.34.210' | def | INSERT | NO |
| 'hzshark'@'10.155.34.210' | def | UPDATE | NO |
| 'hzshark'@'10.155.34.210' | def | DELETE | NO |
| 'hzshark'@'10.155.34.210' | def | CREATE | NO |
| 'hzshark'@'10.155.34.210' | def | DROP | NO |
| 'hzshark'@'10.155.34.210' | def | RELOAD | NO |
| 'hzshark'@'10.155.34.210' | def | SHUTDOWN | NO |
| 'hzshark'@'10.155.34.210' | def | PROCESS | NO |
| 'hzshark'@'10.155.34.210' | def | FILE | NO |
| 'hzshark'@'10.155.34.210' | def | REFERENCES | NO |
| 'hzshark'@'10.155.34.210' | def | INDEX | NO |
| 'hzshark'@'10.155.34.210' | def | ALTER | NO |
| 'hzshark'@'10.155.34.210' | def | SHOW DATABASES | NO |
| 'hzshark'@'10.155.34.210' | def | SUPER | NO |
| 'hzshark'@'10.155.34.210' | def | CREATE TEMPORARY TABLES | NO |
| 'hzshark'@'10.155.34.210' | def | LOCK TABLES | NO |
| 'hzshark'@'10.155.34.210' | def | EXECUTE | NO |
| 'hzshark'@'10.155.34.210' | def | REPLICATION SLAVE | NO |
| 'hzshark'@'10.155.34.210' | def | REPLICATION CLIENT | NO |
| 'hzshark'@'10.155.34.210' | def | CREATE VIEW | NO |
| 'hzshark'@'10.155.34.210' | def | SHOW VIEW | NO |
| 'hzshark'@'10.155.34.210' | def | CREATE ROUTINE | NO |
| 'hzshark'@'10.155.34.210' | def | ALTER ROUTINE | NO |
| 'hzshark'@'10.155.34.210' | def | CREATE USER | NO |
| 'hzshark'@'10.155.34.210' | def | EVENT | NO |
| 'hzshark'@'10.155.34.210' | def | TRIGGER | NO |
| 'hzshark'@'10.155.34.210' | def | CREATE TABLESPACE | NO |
| 'testlink'@'10.155.40.231' | def | USAGE | NO |
| 'root'@'::1' | def | SELECT | YES |
| 'root'@'::1' | def | INSERT | YES |
| 'root'@'::1' | def | UPDATE | YES |
| 'root'@'::1' | def | DELETE | YES |
| 'root'@'::1' | def | CREATE | YES |
| 'root'@'::1' | def | DROP | YES |
| 'root'@'::1' | def | RELOAD | YES |
| 'root'@'::1' | def | SHUTDOWN | YES |
| 'root'@'::1' | def | PROCESS | YES |
| 'root'@'::1' | def | FILE | YES |
| 'root'@'::1' | def | REFERENCES | YES |
| 'root'@'::1' | def | INDEX | YES |
| 'root'@'::1' | def | ALTER | YES |
| 'root'@'::1' | def | SHOW DATABASES | YES |
| 'root'@'::1' | def | SUPER | YES |
| 'root'@'::1' | def | CREATE TEMPORARY TABLES | YES |
| 'root'@'::1' | def | LOCK TABLES | YES |
| 'root'@'::1' | def | EXECUTE | YES |
| 'root'@'::1' | def | REPLICATION SLAVE | YES |
| 'root'@'::1' | def | REPLICATION CLIENT | YES |
| 'root'@'::1' | def | CREATE VIEW | YES |
| 'root'@'::1' | def | SHOW VIEW | YES |
| 'root'@'::1' | def | CREATE ROUTINE | YES |
| 'root'@'::1' | def | ALTER ROUTINE | YES |
| 'root'@'::1' | def | CREATE USER | YES |
| 'root'@'::1' | def | EVENT | YES |
| 'root'@'::1' | def | TRIGGER | YES |
| 'root'@'::1' | def | CREATE TABLESPACE | YES |
| 'root'@'127.0.0.1' | def | SELECT | YES |
| 'root'@'127.0.0.1' | def | INSERT | YES |
| 'root'@'127.0.0.1' | def | UPDATE | YES |
| 'root'@'127.0.0.1' | def | DELETE | YES |
| 'root'@'127.0.0.1' | def | CREATE | YES |
| 'root'@'127.0.0.1' | def | DROP | YES |
| 'root'@'127.0.0.1' | def | RELOAD | YES |
| 'root'@'127.0.0.1' | def | SHUTDOWN | YES |
| 'root'@'127.0.0.1' | def | PROCESS | YES |
| 'root'@'127.0.0.1' | def | FILE | YES |
| 'root'@'127.0.0.1' | def | REFERENCES | YES |
| 'root'@'127.0.0.1' | def | INDEX | YES |
| 'root'@'127.0.0.1' | def | ALTER | YES |
| 'root'@'127.0.0.1' | def | SHOW DATABASES | YES |
| 'root'@'127.0.0.1' | def | SUPER | YES |
| 'root'@'127.0.0.1' | def | CREATE TEMPORARY TABLES | YES |
| 'root'@'127.0.0.1' | def | LOCK TABLES | YES |
| 'root'@'127.0.0.1' | def | EXECUTE | YES |
| 'root'@'127.0.0.1' | def | REPLICATION SLAVE | YES |
| 'root'@'127.0.0.1' | def | REPLICATION CLIENT | YES |
| 'root'@'127.0.0.1' | def | CREATE VIEW | YES |
| 'root'@'127.0.0.1' | def | SHOW VIEW | YES |
| 'root'@'127.0.0.1' | def | CREATE ROUTINE | YES |
| 'root'@'127.0.0.1' | def | ALTER ROUTINE | YES |
| 'root'@'127.0.0.1' | def | CREATE USER | YES |
| 'root'@'127.0.0.1' | def | EVENT | YES |
| 'root'@'127.0.0.1' | def | TRIGGER | YES |
| 'root'@'127.0.0.1' | def | CREATE TABLESPACE | YES |
| ''@'localhost' | def | USAGE | NO |
| 'hzshark'@'10.155.40.%' | def | SELECT | NO |
| 'hzshark'@'10.155.40.%' | def | INSERT | NO |
| 'hzshark'@'10.155.40.%' | def | UPDATE | NO |
| 'hzshark'@'10.155.40.%' | def | DELETE | NO |
| 'hzshark'@'10.155.40.%' | def | CREATE | NO |
| 'hzshark'@'10.155.40.%' | def | DROP | NO |
| 'hzshark'@'10.155.40.%' | def | RELOAD | NO |
| 'hzshark'@'10.155.40.%' | def | SHUTDOWN | NO |
| 'hzshark'@'10.155.40.%' | def | PROCESS | NO |
| 'hzshark'@'10.155.40.%' | def | FILE | NO |
| 'hzshark'@'10.155.40.%' | def | REFERENCES | NO |
| 'hzshark'@'10.155.40.%' | def | INDEX | NO |
| 'hzshark'@'10.155.40.%' | def | ALTER | NO |
| 'hzshark'@'10.155.40.%' | def | SHOW DATABASES | NO |
| 'hzshark'@'10.155.40.%' | def | SUPER | NO |
| 'hzshark'@'10.155.40.%' | def | CREATE TEMPORARY TABLES | NO |
| 'hzshark'@'10.155.40.%' | def | LOCK TABLES | NO |
| 'hzshark'@'10.155.40.%' | def | EXECUTE | NO |
| 'hzshark'@'10.155.40.%' | def | REPLICATION SLAVE | NO |
| 'hzshark'@'10.155.40.%' | def | REPLICATION CLIENT | NO |
| 'hzshark'@'10.155.40.%' | def | CREATE VIEW | NO |
| 'hzshark'@'10.155.40.%' | def | SHOW VIEW | NO |
| 'hzshark'@'10.155.40.%' | def | CREATE ROUTINE | NO |
| 'hzshark'@'10.155.40.%' | def | ALTER ROUTINE | NO |
| 'hzshark'@'10.155.40.%' | def | CREATE USER | NO |
| 'hzshark'@'10.155.40.%' | def | EVENT | NO |
| 'hzshark'@'10.155.40.%' | def | TRIGGER | NO |
| 'hzshark'@'10.155.40.%' | def | CREATE TABLESPACE | NO |
| 'hzshark'@'10.155.30.%' | def | SELECT | NO |
| 'hzshark'@'10.155.30.%' | def | INSERT | NO |
| 'hzshark'@'10.155.30.%' | def | UPDATE | NO |
| 'hzshark'@'10.155.30.%' | def | DELETE | NO |
| 'hzshark'@'10.155.30.%' | def | CREATE | NO |
| 'hzshark'@'10.155.30.%' | def | DROP | NO |
| 'hzshark'@'10.155.30.%' | def | RELOAD | NO |
| 'hzshark'@'10.155.30.%' | def | SHUTDOWN | NO |
| 'hzshark'@'10.155.30.%' | def | PROCESS | NO |
| 'hzshark'@'10.155.30.%' | def | FILE | NO |
| 'hzshark'@'10.155.30.%' | def | REFERENCES | NO |
| 'hzshark'@'10.155.30.%' | def | INDEX | NO |
| 'hzshark'@'10.155.30.%' | def | ALTER | NO |
| 'hzshark'@'10.155.30.%' | def | SHOW DATABASES | NO |
| 'hzshark'@'10.155.30.%' | def | SUPER | NO |
| 'hzshark'@'10.155.30.%' | def | CREATE TEMPORARY TABLES | NO |
| 'hzshark'@'10.155.30.%' | def | LOCK TABLES | NO |
| 'hzshark'@'10.155.30.%' | def | EXECUTE | NO |
| 'hzshark'@'10.155.30.%' | def | REPLICATION SLAVE | NO |
| 'hzshark'@'10.155.30.%' | def | REPLICATION CLIENT | NO |
| 'hzshark'@'10.155.30.%' | def | CREATE VIEW | NO |
| 'hzshark'@'10.155.30.%' | def | SHOW VIEW | NO |
| 'hzshark'@'10.155.30.%' | def | CREATE ROUTINE | NO |
| 'hzshark'@'10.155.30.%' | def | ALTER ROUTINE | NO |
| 'hzshark'@'10.155.30.%' | def | CREATE USER | NO |
| 'hzshark'@'10.155.30.%' | def | EVENT | NO |
| 'hzshark'@'10.155.30.%' | def | TRIGGER | NO |
| 'hzshark'@'10.155.30.%' | def | CREATE TABLESPACE | NO |
| 'hzshark'@'%' | def | USAGE | NO |
+----------------------------+---------------+-------------------------+--------------+
172 rows in set (0.00 sec)
mysql>
- mysql shell 查看 所有用户的 授权列表
- mysql shell 查看 所有用户的 授权列表
- 如何查看授权的所有用户
- MYSQL的创建用户，授权用户，删除用户，查看用户
- 查看oracle用户所有权限，并获取授权的DDL
- MySQL 查看所有用户
- 在Linux中查看所有用户的列表
- MYSQL创建、授权、撤销、查看、删除用户
- 【MYSQL】查看mysql的所有用户和权限
- MySQL的用户和授权
- 查看用户的所有视图
- 查看域中所有的用户
- Mysql的用户权限管理--查看,授权,回收
- mysql审计,可以了解用户对mysql的操作以及查看所有的sql语句
- Linux下查看所有用户（shell脚本获取）
- Mysql授权新的远程用户
- MySQL添加授权的用户命令实际操作
- mysql 对用户授权的操作
- Python爬虫实战：百度贴吧—妈妈吧
- java图片处理工具类
- Windows server 2012网络负载均衡NLB
- .dylib与.tbd
- Android——TabWidget（切换卡）
- mysql shell 查看 所有用户的 授权列表
- VR教程来了！谷歌设计师出品的VR设计入门指南
- swift瀑布流自定义布局实现
- CacheCloud-资源归档
- 金蝶K3数据库修复
- 使用IOC轻量级框架Ninject开发
- C++中的static关键字
- IOS 整体框架类图值得收藏
- 电脑上的windows键突然失灵了，肿么办
