How to setup mySQL from Scratch in debian based (UBUNTU, Mint) System

Please put below commands sequencially and let me know in comments if you face any problems.

• sudo apt-get install mysql-server -y
• it will require you to enter password.
• mysql -u root -p
• it will require you to enter the same password as entered in previous step.

At the starting you will have no database to connect, So we will create new database for testing

• CREATE DATABASE testdb;
• SHOW DATABASES;
• select testdb;
• create Table Mov1( id int, mov_name varchar(255), genere varchar(255));
• create Table Mov2( id int, mov_name varchar(255), genere varchar(255));
• show tables;
• Desc table Mov1;

So these are the basic steps to create and connect for MySql Database.