mysql shell 查看所有用户的授权列表

[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 166476Server version: 5.6.25 MySQL Commun

youcharming

11044人浏览 · 2016-04-29 11:54:52

youcharming · 2016-04-29 11:54:52 发布

[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>

一门面向 Data 和 AI 的低代码、云原生的开源编程语言

无需安装部署，在线快速体验 Byzer

更多推荐

byzer plugin install log

Byzer 白泽

函数实现越通用越好？来看看 Byzer-LLM 的 Function Implementation 带来的编程思想大变化...

前言Function Calling 是 OpenAI 首先提出来的一个非常有用的功能，实现了大模型对函数的调用能力。Byzer-LLM 给开源模型也带来了 Function Calling 实现。在这个基础上，我们还拓展了 Respond With Class 功能，允许大模型输出标准的Python对象，进步控制了大模型的输出能力。这两个能力参看：给开源大模型带来Function Callin.