SQL – Create Database through MySQL Interface

Creating Database through MySQL interface is easy. For this we are going to use xampp. If you are not aware of xampp, and how to install it, then read following article.

HOW TO DOWNLOAD AND INSTALL XAMPP IN WINDOWS AND MAC OS X?

CREATING DATABASE THROUGH MYSQL INTERFACE:

Step 01:

Launch xampp. If you are not aware of how to launch xampp, then read following article.

How to start xampp in windows and Mac OS X?

Step 02:

Visit following url:

If using windows: http://localhost/phpmyadmin/

If using mac: http://localhost:8080/phpmyadmin/

A following similar page going to appear

Create Database MYSQL Interface

Step 03:

Look through left column, at the top list, there is link – ‘New’. Click on it. Then following screen appears.

Create Database MySQL Interface

Step 04:

See there is an input box to provide name for database. Provide a name. Any name you can provide. No space and special characters are allowed. If you want to use multiple names then use underscore. I am using ‘gyanol_db’. Then click on create.

Create database mysql interface

If you notice, in the above picture, below the filters button and containing the word, a list of database is there. Your might be appearing with one or two database name. My list is showing all the databases I have created previously. So no need to worry about it.

Once you click on create, a database with the provided name is created. It will ask to create table but we will learn creating table using mysql interface in next chapter.