Create database, table and managing MySQL database using phpMyAdmin

phpMyAdmin is a tool for managing MySQL database and free of charge, it's a web base tool. This tutorial you'll learn how to create database, create table include export(backup) MySQL database.

phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges,export data into various formats.

If you install Wamp, Xammp or EasyPHP, phpMyAdmin is included in the package. If you manually installed Apache, PHP and MySQL, you can download phpMyAdmin at their officail site. (Click here to download)

phpMyAdmin

1: Create database using phpMyAdmin

1. To create new database use this form, type database name then click "Create" button. In this example I create database name "test_create_DB".

2: Create table

Create table form

1. After created database. this form'll be display. Enter the name of table and number of field. In this example, I create table name "web_members" for store my web members and it have 4 fields (id, name, lastname, email)