Create a Database and Add Tables to it in MySQL Command Line

MySQL is one of most basic database application language and is very easy to deal with. The applications of MySQL go in hand to hand with any scripting language.It is very much useful to deal with situations where data manipulation is to be specific and ordered.

Various commands are given below:

*Connecting to a database---mysql -u username -p password -h hostname It is by default mysql -u root -p -h 127.0.0.1;

*Seeing the different databases present---show databases;
*Creating a database---create database database name;
*Creating tables---create table table_name(parameters);