Show databases

Here we will discuss how to show databases from command prompt.

Here is the syntax.

mysql> show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| mysql              |

| test               |

| wordpress          |

+--------------------+

4 rows in set (0.37 sec)

mysql>