MySQL List Databases

$ mysql -u USERNAME -h HOSTNAME -p
$ mysql -u root -p
At mysql prompt type the following command (show databases;):
mysql> show databases;
Sample output:

+--------------------+
| Database           |
+--------------------+
| information_schema | 
| mysql              | 
| wiki               | 
+--------------------+
3 rows in set (0.03 sec)

Of course your can use the following shell one liner to get the list of all databases too:

# Connect to the local server
mysql -u root -h localhost -p  -e 'show databases;'
 
# Connect to the remove mysql server
mysql -u root -h 192.168.1.250 -p  -e 'show databases;'

Sample outputs:

Fig.01: mysql command in action

mysql -u root -h localhost -p'MyPasswordHere'  -e 'show databases;' | awk '{ print $1 }' 
# OR store it in $DBS shell variable 
DBS=$(mysql -u root -h localhost -p'MyPasswordHere'  -e 'show databases;' | awk '{ print $1 }')
echo "List of database - $DBS"