How to get list of databases quickly

You can use mysqlshow to do your job.

Here are few samples
1) When you want to list dbs in local server


$./mysqlshow -u user -p


2) When you want to list dbs in a remote server.


$./mysqlshow -h -u user -p