Step-by-Step Guide

How to create a new database and manage it in cpanel and PhpMyAdmin

We assume you are already signed in to cpanel, or please take this link to login in CPanel

In c panel databases menu select the MYSQL databases

MYSQL databases

In MYSQL database here we create a new database type any name click on “create database”

create a new database

Database can be created successfully


In MYSQL database here enter our user name , password and click on ‘create user’ button

create user

User name can be successfully created in MYSQL database

successfully created

In MYSQL database users has been created successfully

database  users

In MYSQL database add user to database, here we select our created user, database and click on “Add” button

add user

In MYSQL database select the all privileged button and click on make changes

all privilege

In MYSQL database here have our database and users has been created successfully

MYSQL database

In c panel databases menu select the PhpMyAdmin


In phpmyadmin have database,status,import,export and settings etc…


In phpMyAdmin databases click on the Databases statistics


Click on the database name in which under you create a table.After click on the database name you find a page like that.

Click on the database

In create table here we enter the name and click on “GO” button

create table

In table has been created successfully in MYSQL browse

 created successfully

If you want to create a table by writing SQL Query simply click on the SQL button on the page and write your query and click on the go button.


In database structure have our name,type,action and Information etc..


PhpMyAdmin enables you to check the status of your MySQL server. To do this, jump to the Status tab in phpMyAdmin without selecting a specific database


In search menu have table search , Zoom search , find and replace these all having


In phpMyAdmin Insert here have the column , type and select their function and click on the ”Go” button


In phpmyadmin export ,here we select the format and export our databases quickly and click the ‘GO’ button


In phpMyAdmin import choose any one file and select the format Next click on “GObutton


In operations here we Adjust & copy our database table maintenance, delete data here have all options


In phpMyAdmin ,variables here we Server variables and settings variables


In charsets ,here we sets Character and collations

0 0 votes
Article Rating


About Author

Notify of

Inline Feedbacks
View all comments

You may also like

Step-by-Step Guide

How to Register a Domain Name and Web Hosting(website) for Your Own Business

Go to google and search Enter your domain name here and click here to search Next comes a search
Domain India Client Area
Step-by-Step Guide

How to Access and Manage Client Service Portal (Client Area) of Domain India

The Client Area (Dashboard) of our Customers Management Portal is where client access the product / service and manage their
Would love your thoughts, please comment.x