How to view the information about the database and tables

Answer

Use

show databases;

The above command will show the databases available in the server

Show tables - this will show the tables available in a database

Describe table_name - will show the structure of the table.