In this article, we will see how to get list of databases in MySQL. We can get list of databases in MySQL server using SHOW command. The SHOW SCHEMAS command is a synonym for SHOW DATABASES.
Syntax:
SHOW {DATABASES | SCHEMAS} [LIKE 'pattern' | WHERE expr];