How to Create a MySQL Database using PHPMyAdmin

MySQL Database in PHPMyAdmin

We can create MySQL database in different ways . Today I will show you how to create database using XAMPP control panel. To do it first install XAMPP in your computer. Be remember you should installed it D or E or F drive. Please do not install into in C drive. By default it installed in C drive. After installing Run the XAMPP. It will show a screen given below-

Step by Step Procedure (Graphical Mode)

·         Now click Start Button of Apache row XAMPP  which is shown in above picture. Without running apache we can not work in MySQL

·         Now click Start Button of MySQL row XAMPP  which is shown in above picture.

·         Now open a browser. I have installed Mozila Firefox. Just type a url for opening apahce and my MySQL  server.  The path is like this http://localhost/phpmyadmin/

·         Now click icon Database from the above screen.

·         Type a database name under Create database label of the screen. You can change Collation

·         Now just click Create Button . I have given my database name TPTS

·         After clicking Create button ,my database TPTS has been created successfully. And will show us a message Database TPTS has been crated.

Step by Step Procedure (Command Mode)

·         

At first go to SQL tab from PHPmyadmin

·         Then go to SQL tab

·         Now just type the command in text box  “   CREATE DATABASE MMIS;   ” the command should end with “  ;  ”

·         Finaly click Go button.

·         As a result your database will crate named as MMIS.

·         Enjoy!