Monday, December 27, 2021

How to view the database name in MySQL?

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