How to create database on mysql

By | March 17, 2014

1) Run Xampp lite previous note. Click start for apache and mysql. And then open the web browser and type at the address bar 127.0.0.0.1. Click phpmyadmin at the left side.

How to create database on mysql 1

 

2) This below screen appear and create the name of database and CREATE NEW DATABASE. For example type “mydatabase” after that click create at the right side.

 

How to create database on mysql 2

 

3) Insert the name of table and number of field showed below. For example name table: ‘user’ and field is ‘2’ and then click ‘GO’.

How to create database on mysql 3

 

4) This form will appear. Fill in the form refer picture below.. after that click ‘SAVE’

 

How to create database on mysql 4

 

5) Click Insert to insert the data into the database.

How to create database on mysql 5

 

6) Fill the box (refer the picture below).After that click ‘GO’.

How to create database on mysql 6

 

7) Now you has been done create mysql database and insert the data into the data base. If u want to see the data inside the database click ‘browse’

How to create database on mysql 7

After click browse

How to create database on mysql 8

Facebook Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

*

code