Step-by-Step Guide

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

If you want to know how to login to c panel,please take this link
http://blog.domainindia.com/wp-admin/post.php?post=399&action=edit

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

created

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

PhpMyAdmin

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

PhpMyAdmin

In phpMyAdmin databases click on the Databases statistics

 Databases

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.

 SQL

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

 structure

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

status

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

search

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

insert

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

export

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

inport

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

operations

In phpMyAdmin ,variables here we Server variables and settings variables

variables

In charsets ,here we sets Character and collations

charsets
0 0 vote
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments