How To Create Database and Tables Using PHP MyAdmin

Hello Guys Welcome to Coding Gurus Online Portal ...!

phpMyAdmin is a tool for managing MySQL database. It's an open source web base tool. Here in this tutorial you'll learn how to create databases, create tables, import (executing existing SQL File) and export (Taking 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 Waamp, Xammp or EasyPHP, phpMyAdmin is included in the package. You can also seperately install Apache, PHP and MySQL.

Create database using phpMyAdmin

In order to create a new database, in case you are using a IDE like xampp or waamp this can help you through. So, now open the localhost from your browser and select phpmyadmin at the right side and you will see an option to enter the name of database ,leave the next option as collation itself and hit create.That's it your database is created now.

Follow these steps below to create your own database. As in this example I create database name codinggurus.






Back Next