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.
Launch xampp. If you are not aware of how to launch xampp, then read following article.
Visit following url:
If using windows: http://localhost/phpmyadmin/
If using mac: http://localhost:8080/phpmyadmin/
A following similar page going to appear
Look through left column, at the top list, there is link – ‘New’. Click on it. Then following screen appears.
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.
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.