If you want to show, how many databases in MySQL just simply run the following command.


Login to MySQL

login to your MySQL using username and password

C:\xampp\mysql\bin>mysql -u root -p


it will ask you password enter your password and login.



Show databases

it will return how many databases in MySQL

MariaDB [rathorji]> show databases;


Output:

+--------------------+
| Database           |
+--------------------+
| ci-tutorial        |
| information_schema |
| mysql              |
| performance_schema |
| php-ajax-tutorial  |
| php-tutorial       |
| phpmyadmin         |
| rathorji           |
+--------------------+


Use Database

There is list database but we you want to use it.

USE database_name;

if you want to use php-tutorial database then you can execute query like this.

USE php-tutorial;


Show tables

now you have chosen database but you want to see table list in your database.

 
SHOW TABLES;

 it will show you list of tables of selected database.



Are you facing problems in understanding this article?
You can watch the video. Watch it now