How to See Database in MySQL?

Open the MySQL command-line client

Log in with your username and password

Run `SHOW DATABASES;`

View the list of databases displayed

To see a specific database, run `USE database_name;`

To view tables in the selected database, run `SHOW TABLES;`

To see database details, run `SELECT schema_name FROM information_schema.schemata;`

Suggested for You

Trending Today