Creating a MySQL database on PC?

I'am using XAMPP ( lite ) for PHP, My SQL and Apache server. How can i create a database on my PC?

 

install phpmyadmin on your server to easily manage your MySQL server!!

http://www.phpmyadmin.net/home_page/downloads.php

 

Its there in the XAMPP package so probably installed for my server as well, but how can i actually use it to create a database, help files are getting a lot confusing.

 

if you open up phpmyadmin, the main screen has "Create new database " in the middle. Also, the databases link towards the footer can also do that.

I'd recommend WAMPServer - beautiful solution : www.wampserver.com/en/

 

Ok, you've installed XAMPP package. that was basic requirement.
but to handle the MySQL Database , you need to have some frontend tool for which you need to install phpmyadmin

from which you can create new database, manage them, run query, backup the thing. means everything you need to do with MySQL can be done through phpmyadmin

 

XAMPP already have phpMyAdmin installed, i just wanted to know how to execute it on my server

 

simple open the phpmyadmin, you will find create database button , you need to give the name of the database you like to create!! that's all

 

I tried http://localhost/phpmyadmin and it executed the script. Thanks anyways

 

ohh great... I've just find out screenshot for the same

 

Its not the same as in windows, i just didn't know about the phpMyAdmin option in xampp's index.