List user created databases (schemas) in MySQL

The query below lists user databases (schemas) on MySQL instance.

Query

select schema_name as database_name
from information_schema.schemata
where schema_name not in('mysql','information_schema',
                         'performance_schema','sys')
order by schema_name;

Columns

  • database_name - database (schema) name

Rows

  • One row: represents one database (schema)
  • Scope of rows: all databases (schemas) on MySQL instance excluding system ones
  • Ordered by: database (schema) name

Sample results

Below is the sample results generated by query

0
There are no comments. Click here to write the first comment.