List Databases

(2023-05-02)

The most common way to get a list of the MySQL databases is by using the mysql client to connect to the MySQL server and run the SHOW DATABASES command.

$ mysql -u me -p [-h remotehost]
mysql> show databases
    -> ;
+--------------------+
| Database           |
+--------------------+
| information_schema |
[...]