mysql> SELECT schema_name FROM information_schema.schemata;
--------------
SELECT schema_name FROM information_schema.schemata
--------------
+------------------------+
| SCHEMA_NAME |
+------------------------+
| mysql |
| information_schema |
| performance_schema |
| sys |
| aaabbbb_dba_management |
| aaabbbb_xxxxxxtdb |
| xxxxxxt |
| aaabbbb_xxxxxxtkdndb |
| test3 |
+------------------------+
9 rows in set (0.00 sec)
mysql> select db,user from mysql.db;
+------------------------+---------------+
| db | user |
+------------------------+---------------+
| aaabbbb_dba_management | aaadbadmin |
| performance_schema | mysql.session |
| sys | mysql.sys |
| aaabbbb_xxxxxxtdb | xxxxxxt_admin |
| aaabbbb_xxxxxxtkdndb | xxxxxxt_admin |
| xxxxxxt | xxxxxxt_admin |
+------------------------+---------------+
6 rows in set (0.00 sec)
mysql> show databases;
+------------------------+
| Database |
+------------------------+
| information_schema |
| aaabbbb_dba_management |
| aaabbbb_xxxxxxtdb |
| aaabbbb_xxxxxxtkdndb |
| mysql |
| performance_schema |
| sys |
| test3 |
| xxxxxxt |
+------------------------+
9 rows in set (0.00 sec)
No comments:
Post a Comment