How to Show Databases in MySQL

Last updated July 25, 2026 · By the SaturnSQL team

SHOW DATABASES lists every database your user is allowed to see; add LIKE to filter by pattern. Query information_schema.schemata when you also need the default charset and collation.

SHOW DATABASES;
SHOW DATABASES LIKE 'shop%';

SELECT schema_name, default_character_set_name, default_collation_name
FROM information_schema.schemata
ORDER BY schema_name;