查询所有数据库

1.查看显示所有数据库

mysql> show databases;
±-------------------+
| Database |
±-------------------+
| information_schema |
| mysql |
| performance_schema |
| zabbix |
±-------------------+
4 rows in set (0.00 sec)

2：查看当前使用的数据库

mysql> select database();
±-----------+
| database() |
±-----------+
| NULL |
±-----------+
1 row in set (0.00 sec)

3：查看数据库使用端口

mysql> show variables like ‘port’;
±--------------±------+
| Variable_name | Value |
±--------------±------+
| port | 3306 |
±--------------±------+
1 row in set (0.01 sec)

4：查看数据库编码

mysql> show variables like ‘character%’;
±-------------------------±---------------------------+
| Variable_name | Value |
±-------------------------±---------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
±-------------------------±---------------------------+
8 rows in set (0.00 sec)

5：查看数据库的所有用户信息

mysql> select distinct concat (‘user: ‘’’,user,’’’@’’’,host,’’’;’)as qurey from mysql.user;
±------------------------------+
| qurey |
±------------------------------+
| user: ‘root’@‘127.0.0.1’; |
| user: ‘root’@’::1’; |
| user: ‘’@‘localhost’; |
| user: ‘root’@‘localhost’; |
| user: ‘zabbix’@‘localhost’; |
| user: ‘’@‘zabbix.qh.com’; |
| user: ‘root’@‘zabbix.qh.com’; |
±------------------------------+
7 rows in set (0.00 sec)

6：查看数据文件存放路径

mysql> show variables like ‘%datadir%’;
±--------------±----------------+
| Variable_name | Value |
±--------------±----------------+
| datadir | /var/lib/mysql/ |
±--------------±----------------+
1 row in set (0.01 sec)

参考连接https://www.cnblogs.com/wanglijun/p/8883875.html