TECHNIG
Gateway for IT Experts and Tech Geeks

How to Create Database Inside phpMyAdmin?

Working with database in MySQL server trough phpMyAdmin is the graphical way and easier than command line interface for beginners. To create database inside phpMyAdmin just simply follow this step by step MySQL guide.

The phpMyAdmin is a free open source web software intended to manage and administrate MySQL Server. You can do all needed task such as create, delete, or modifying the existing database with a simple graphical interface. The other functions are working with tables, fields, rows and executing all SQL standard queries which can perform by command line.

Here we try to show you, How to create, delete or modify MySQL database with phpMyAdmin trough interface of a web browser. To perform the task you need to run the web server on local web server. For online website try to create database inside phpMyAdmin through website Cpanel.

How to Create Database Inside phpMyAdmin?

First open phpMyAdmin with your internet web browser by typing localhost/phpmyadmin in address bar. I have installed on my local computer with WAMP Server and maybe your case would be an online website. For online website try to create database inside phpMyAdmin through website Cpanel.

phpMyAdmin on Localhost - Create Database Inside phpMyAdmin
phpMyAdmin on Localhost – Create Database Inside phpMyAdmin

2. Enter as root user, type root in Username and let the Password empty. In online you must enter the root password.

phpMyAdmin interface
phpMyAdmin interface

3. So you can see phpMyadmin page with all needed information about web server, database server and phpMyAdmin. To create a new database click Database tab on the main page.

Create MySQL Database
Create MySQL Database

4. In this page simply type the name of your new database and click Create button in order to create a new database.

Create MySQL Database
New Database

The new database has been created successfully. The database need a user to manage and  manipulate it. By default the root user has the full privilege for all database.

You can add a new user to database and assign the appropriate privilege for administration. To create new user go to the User tab and click Add User.  Fill the required information and permission for new user. 

Create user for database
Create user for database

Click the go button to create the new user. Now you can use the database and user for your website.

To delete a database with all tables, select the database you want to delete and click Drop button.

Delete database
Delete database

This will perform the complete deletion of a database, and be careful do not delete your real website database.

Related Search: 

how to create database in phpmyadmin in wamp server.
how to create database in phpmyadmin.
phpmyadmin create database no privileges.
how to create table in phpmyadmin.
how to create database using phpmyadmin.
how to create database mysql.
localhost phpmyadmin create database.
how to create table in mysql phpmyadmin.

Leave A Reply

Your email address will not be published.

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More

where to buy viagra buy generic 100mg viagra online
buy amoxicillin online can you buy amoxicillin over the counter
buy ivermectin online buy ivermectin for humans
viagra before and after photos how long does viagra last
buy viagra online where can i buy viagra