mysql> select version();
+------------+
| version() |
+------------+
| 5.7.38-log |
+------------+
1 row in set (9.99 sec)
2.数据库端口
mysql> show global variables like 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port | 11110 |
+---------------+-------+
1 row in set (0.63 sec)
3.查询数据库
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema | |
| mdmdatafix |
| mdmquery |
| mysql |
| percona |
| performance_schema | |
| sys |
+--------------------+
9 rows in set (0.07 sec)
4.数据库用户信息
mysql> use mysql;
Database changed
mysql> select user,host from user;
+-----------------+--------------+
| user | host |
+-----------------+--------------+
| mdmdatafixer | 10% |
| aiuap | 10.% |
+-----------------+--------------+