How to get list of all MySQL Databases - MySQL Developer Tutorial

How to get list of all MySQL Databases

Often as MySQL DBAs or MySQL developers we need to get the current list of Databases which exits on MySQL Server. You can use below query that uses system tables to get the list of MySQL Databases.

You can use

show databases;

Or you can use below

Select schema_name from information_schema.schemata;

Get list of all MySQL Database | Get All databases names from MariaDB