Cpanel Mysql Database Management - Part 2.1 Of My 7 Part Cpanel Tutorial

Albus Dumbledore

Nov 8 2006, 12:14 AM

This tutorial is an extension to my 7 tutorial series about the Cpanel. The 7 different Cpanel tutorials can be found below.
Part 1: E-mail Management
Part 2: Useful Site Management Tools
Part 3: Useful Site Management Tools2.1
Part 4: Analysis/Log Files
Part 5: Advanced Tools
Part 6: PreInstalled Scripts, Extras, and Cpanel Options
Part 7: Fantastico

Detailed Cpanel Tutorial Part 2.1: MySQL Management

In this tutorial, i will explain how to add, edit, delete and over-all manage the MySQL Feature in the Cpanel.

Creating a MySQL Database

1) Go to the middle of the page until you see an input field with the text MySQL Database:

2) Enter the name of the MySQL Database that you want it to be. For instance, if you are making the MySQL Database for your forums, you might want to make it forums.

3) Then Simply hit enter, or 'Create MySQL Database'
-note- After you make the MySQL Database, it's OFFICAL name will be: "CPANEL USERNAME_Database name" so basically, it will be your cpanel username prefixing the name of the database you created.

Deleting a MySQL Database
1) Find the MySQL Database that you want to delete in the list.

2) Find the icon to the RIGHT of the Database Name and click the icon that says DELETE

3) You will be asked if you are sure you want to do this, click Yes if you really want to and No if you dont want to.

Checking The Database
This will allow you to check and see if all of the tables were created correctly, or if there is something wrong with them.
1) Click on the little icon to the RIGHT of the database name that says CHECK

2) It will run the automatic check and tell you which ones are OK and which ones AREN'T OK

Repairing the Database
This will allow you to repair any damage that has been caused to the Databse.
1) Click on the little icon to the RIGHT of the database name that says REPAIR

2) It will run an automatic script and tell you which ones were successfully repaired, and which ones weren't successfully repaired.

Creating a Database User
1) Go down to the bottom of the page until you see two text input fields that say 'User Name:' and 'Password:' next to them

2) Enter the desired 'User Name' and 'Password'

3) Click the submit button, or hit enter and you're done creating the user.

Assigning a User to a Database
Most scripts require that the User be assigned to a databse, this will show you how to do it.
1) Just above where you created the databse, find two drop down lists that say 'User:' and 'MySQL Database:'

2) Find the User that you just made, as well as the database you made before that.

3) Make sure the User is Highlighted and the Database you want is highlighted.

4) The Privileges are already set for you so nothing you need to do with that

5) Click the button that says Grant Permissions, and then you are done.

Deleting Database Users
There are two ways you can do this.
A:
1) Find the database that the user is assigned to and under the Database name it says the Database User Name.

2) Find the button to the RIGHT of the Database username that says DELETE

3) That will un-assign the user to the database.

B:
1) Go down to where you created the Database User

2) Find the Database User you wish to delete

3) Click the little icon that says DELETE to the RIGHT of the Database Username

4) This will delete the Database User Forever

Access Host
In most scripts, this field is already filled in for you as localhost but if it is not, when setting up the script on your site, when it asks for the accesshost, simply put in 'localhost' you do not need to make a new Access Host for any real reason.

Just as a side note: Underneath the Database Name and UserName in the list of Databases, you will see a bit of coding, this coding can be used by people who know PHP and PERL to allow access to this particular database.

At the bottom of the screen, you will find a link to PHP My Admin, once i write a tutorial for that, I will link to it from here. But currently i do not have a tutorial for that.

farsiscript

Nov 10 2006, 09:59 AM

very nice dear Albus Dumbledore , thanks for this tut
in localhost we can make one database in phpmyadmin ! but in cpanel "phpmyadmin " we can not ?
why this script working different ?

jlhaslip

Nov 10 2006, 12:23 PM

For security reasons, the way to create a Database on the Shared Hosting server is by using the cpanel MYSQL selection. This ensures the Database is created on your account and then you have control over which users can access it. Your cpanel name is pre-pended to each of your database names, for instance.
If we all had phpmyadmin create capability, the organisation of the datbases would be a disaster zone.
This feature of the fantastico adding the user name is a security feature, in short answer form.

delivi

Nov 17 2006, 07:16 AM

thanx dude for this complete tutorial for setting up and workin with CPanel. Eventhough i've been using it for several months i never knew that this much can be done.

Thanx for this extensive tutorial.

TeeCee06

Nov 18 2006, 05:51 AM

Very nice tutorial. The information is very clear and I learned I thing or two. Even though I really dont mess with Mysql Databases much myself I do need them for my forum and a couple of the things you said about users helps me understand the way it works a lot better.

Albus Dumbledore

Nov 20 2006, 07:13 AM

yes, there are many things that people can do with Cpanel, and allot of people do not know about them.. which is why i made these complete Cpanel tutorials.

It's good to know that they helped some people out

sumit

Dec 9 2006, 06:31 PM

yes it is very nice tutorial. this post can helps to understand about cpanel. anybody could get about cpanel.

Recent Queries:-

cpanel canot delete mysql database - 17.13 hr back. (1)
cpanel mysql tables - 43.40 hr back. (2)
cpanel log delete database - 95.77 hr back. (1)
how to find a database which is there in the cpanel in the server - 97.35 hr back. (1)
cpanel database user not getting assigned to database - 138.20 hr back. (1)
manage sql cpanel 1.1 - 145.30 hr back. (1)

Similar Topics

Keywords : cpanel mysql database management cpanel

Complete Login System - With PHP + MYSQL (56)
Its an complete login sistem made and tested by me and I think itwill be very usefull for people who
are tryn to learn PHP. First, let's make register.php: CODE <?
include("conn.php"); // create a file with all the database connections
if($do_register){ // if the submit button were clicked if((!$name)
|| (!$email) || (!$age) || (!$login) ||
(!$password) || (!$password2)){ print "You can't let
any fields in blank...

Ftp Account Management - Part 2.2 of my 7 Part Cpanel Tutorial (1)

This tutorial is an extension to my 7 tutorial series about the Cpanel. The 7 different Cpanel
tutorials can be found below. Part 1: E-mail Management Part 2: Useful Site Management Tools
Part 3: Useful Site Management Tools2.1 Part 4: Analysis/Log Files Part 5: Advanced Tools Part
6: PreInstalled Scripts, Extras, and Cpanel Options Part 7: Fantastico Detailed Cpanel
Tutorial Part 2.2: FTP Management For this tutorial, you will need to locate the Icon under
Site Management Tools labeled FTP Manager and also inside of the FTP:// Accounts area...

Check Referrer To Prevent Linking Yours From Other Sites - Check referrer with Php and Mysql (8)

Check Referrer Using Php To Prevent People Linking To Your Downloads From Other Sites Ever
find that found some people are listing items, images and tuts and linking directly to the download
url (those that are like my photoshop tutorial.php?id=0), which is a .php to count the number of
downloads. To prevent this, you can add a piece of code to the download pages that checks which page
referred them to the download page: if it's my domain, it downloads the file normally, if
it's not, it will redirect to my home page instead. Important : Not all browser...

Cron Jobs - Cron Jobs In Cpanel - Cron Jobs : Cron Jobs using PHP (27)

How to setup Basic Cron Jobs. Ok. Many people are yelling that they cannot configure the
crons properly. Here is a short tutorial which will help you set them. I have tried my best to
explain the concept but there can be more advanced configurations. Basically you will want to run a
PHP script file in specific intervals. Suppose you want to execute a php file called maintanence.php
every one hour. This is what you do :- The CRON Command is in the Following Format CODE
[ Minute - Hour - Day - Month - Weekday ] - Command The COMMAND, can be bro...

Getting Started With Mysql - creating tables and insert data into them. (2)

Simple User System - php, mysql driven (19)

Hey! Maybe you've seen my other tutorials...or my signature.. Anyways I'm going to show
you how to make a system so users of your site could register accounts and you could have protected
- user only - pages on your site /smile.gif" style="vertical-align:middle" emoid=":)" border="0"
alt="smile.gif" /> Ok, so we start by creating a config.php file. CODE <?php
$dbhost = 'database host'; $dbname = 'database name';
$dbusername = 'database username'; $dbuserpass = 'database pas...

Complete Login And Registration System - doesn't use mysql! (9)

kLogin 0.1 QUOTE(readme.txt) Readme file to kLogin 0.1 To use the internet explorer fix:
download the latest IE7 ZIP file
(http://sourceforge.net/project/showfiles.php?group_id=109983&package_id=119707) Extract the ie7
zip file to the root directory of your web server. Example, if you are using a unix/linux server,
it's on "public_html/" or "home/public_html" Open kLogin.php file with your editor and edit the
$info_text or $info_txt variable. Then, extract the kLogin.php file in to the root
directory of your web server also. Just run kShoutBo...

Cpanel Preinstalled Scripts, Extras, And Cpanel Options - Part 6 of My 7 Part Tutorial (1)

This Tutorial will be divided into 7 different parts, and this is the first part, when i get the
other parts together, i will post the links under here /biggrin.gif" style="vertical-align:middle"
emoid=":D" border="0" alt="biggrin.gif" /> Enjoy. Part 1: E-mail Management Part 2: Useful Site
Management Tools Part 3: Useful Site Management Tools2.1 Part 4: Analysis/Log Files Part 5:
Advanced Tools Part 7: Fantastico Detailed Cpanel Tutorial Part 4: PreInstalled Scripts,
Extra, and Cpanel Options In this tutorial I will, in detail explain all of th...

Adding Data To A Database And Displaying It Later - Using Forms, PHP and MySQL (1)

Requirements: PHP Support MySQL Database access I am going to use a news program as an example.
Ok, first you are going to need to connect to the database. Do so by using the code below. I have
added some comments where you will need to edit to fit your server's specifications. Create a
new file with notepad and call it config.php QUOTE //Change root to your database
account's username $dbusername = "root"; //Add your account's password in between the
quotations $password = " "; //Add the name of the database you are using in betw...

Simple Shoutbox - PHP, MySQL driven.. (34)

Ok, so I'm going to show you how to create a very basic shoutbox which is driven with PHP and a
MySQL database. So, lets start - open a database management program like PHPMyAdmin and run these
queries. SQL CREATE TABLE `shoutbox` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT
, `name` VARCHAR( 255 ) NOT NULL , `mail` VARCHAR( 255 ) NOT NULL , `time`
VARCHAR( 255 ) NOT NULL , `message` TEXT NOT NULL , `ip` VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( `id` ) ) TYPE = MYISAM ; CREATE TABLE `shoutbox_a...

Cpanel Fantastico - Part 7 Of My 7 Part Tutorial (14)

This tutorial is going to discuss the entire list of fantastico features that are on the trap17
servers This is an extention of my origional 6 part tutorial, now 7 part tutorial. The links to the
rest are listed below. This tutorial is a follow-up to the Cpanel Tutorials that i wrote last
night, the links can be found below. Part 1: E-mail Management Part 2: Useful Site Management
Tools Part 3: Useful Site Management Tools2.1 Part 4: Analysis/Log Files Part 5: Advanced
Tools Part 6: PreInstalled Scripts, Extras, and Cpanel Options Detailed Cpanel Tutor...

Ftp And Cpanel For Dummies - (7)

In this tutorial I will be teaching you how to upload files via FTP(File Transfer Protocol) so you
can get your website on the web, and off your computer. First off, I'll be going over some
terms that you'll need to know. cPanel : Control Panel. This is the area of your website
where you will do all your maintenance, backups, ect. You get this with your webhost when you sign
up. After signing up for a webhost, you'll be asked to specify a "Control Panel(or cPanel)"
name, and password. Something you will easily remember is best. Try something like "yournam...

How To Save Upload Time In Cpanel - (37)

Do not Extract files and then upload them by ftp, try the following (1)open the file manager
(2)upload the zip or gz format file (3)then extract the file it save the comulation time for
ftp client and the ftp server....

Cpanel Advanced Tools - Part 5 of My 7 Part Tutorial (20)

This Tutorial will be divided into 7 different parts, and this is the first part, when i get the
other parts together, i will post the links under here /biggrin.gif" style="vertical-align:middle"
emoid=":D" border="0" alt="biggrin.gif" /> Enjoy. Part 1: E-mail Management Part 2: Useful Site
Management Tools Part 3: Useful Site Management Tools2.1 Part 4: Analysis/Log Files Part 6:
PreInstalled Scripts, Extras, and Cpanel Options Part 7: Fantastico Detailed Cpanel Tutorial
Part 4: Advanced Tools In this tutorial I will, in detail explain all of t...

Cpanel E-mail Management Set-up - Part 1.1 of My 7 Part Cpanel Tutorial (0)

This tutorial is an extention to my 7 tutorial series about the Cpanel. The 7 different Cpanel
tutorials can be found below. Part 1: E-mail Management Part 2: Useful Site Management Tools
Part 3: Useful Site Management Tools2.1 Part 4: Analysis/Log Files Part 5: Advanced Tools Part
6: PreInstalled Scripts, Extras, and Cpanel Options Part 7: Fantastico Detailed Cpanel
Tutorial Part 1.1: E-mail Management In this tutorial i will, in detail explain all of the
uses for the E-mail Section of the Cpanel. Then, if this is your first time in the cpane...

Cpanel Analysis And Log Files - Part 4 of My 7 Part Tutorial (0)

This Tutorial will be divided into 7 different parts, and this is the first part, when i get the
other parts together, i will post the links under here /biggrin.gif" style="vertical-align:middle"
emoid=":D" border="0" alt="biggrin.gif" /> Enjoy. Part 1: E-mail Management Part 2: Useful Site
Management Tools Part 3: Useful Site Management Tools2.1 Part 5: Advanced Tools Part 6:
PreInstalled Scripts, Extras, and Cpanel Options Part 7: Fantastico Detailed Cpanel Tutorial
Part 3: Analysis and Log Files In this tutorial I will, in detail explain all ...

Cpanel Useful Site Management Tools 2.1 - Part 3 of My 7 Part Tutorial (0)

This Tutorial will be divided into 7 different parts, and this is the first part, when i get the
other parts together, i will post the links under here /biggrin.gif" style="vertical-align:middle"
emoid=":D" border="0" alt="biggrin.gif" /> Enjoy. Part 1: E-mail Management Part 2: Useful Site
Management Tools Part 4: Analysis/Log Files Part 5: Advanced Tools Part 6: PreInstalled
Scripts, Extras, and Cpanel Options Part 7: Fantastico Detailed Cpanel Tutorial Part 2.1:
Useful Site Management Tools In this tutorial I will, in detail explain all of th...

Cpanel Useful Site Management Tools - Part 2 of My 7 Part Tutorial (0)

This Tutorial will be divided into 7 different parts, and this is the first part, when i get the
other parts together, i will post the links under here /biggrin.gif" style="vertical-align:middle"
emoid=":D" border="0" alt="biggrin.gif" /> Enjoy. Part 1: E-mail Management Part 3: Useful Site
Management Tools2.1 Part 4: Analysis/Log Files Part 5: Advanced Tools Part 6: PreInstalled
Scripts, Extras, and Cpanel Options Part 7: Fantastico Detailed Cpanel Tutorial Part 2:
Useful Site Management Tools In this tutorial I will, in detail explain all of t...

Cpanel E-mail Management - Part 1 of My 7 Part Tutorial (0)

This Tutorial will be divided into 7 different parts, and this is the first part, when i get the
other parts together, i will post the links under here /biggrin.gif" style="vertical-align:middle"
emoid=":D" border="0" alt="biggrin.gif" /> Enjoy. Part 2: Useful Site Management Tools Part 3:
Useful Site Management Tools2.1 Part 4: Analysis/Log Files Part 5: Advanced Tools Part 6:
PreInstalled Scripts, Extras, and Cpanel Options Part 7: Fantastico Detailed Cpanel Tutorial
Part 1: E-mail Management In this tutorial I will, in detail explain all of th...

Starting Or Stopping Apache And Mysql Server Via Batch File - (0)

Hi guys, this is a litte tutorial about how we start and stop the Apache and MySQL in Windows NT
(2000, XP, 2003) via a batch file script. As we know in Windows NT based system Apache and MySQL
installed as Windows Services. So we can stop and start it using NET command. For more information
about DOS command, type HELP at command prompt. I assuming that your MySQL service name is "mysql"
and your Apache (Apache 2.0.x) service name is "apache2". If you want to chek it click Start > Run >
services.msc > OK. Windows IS NOT Case Sensitive. Let's get started!. 1. ...

Quiz With Php, But Without Mysql - (3)

Ok let`s start! Once I wrote it for school: At first we need questions (php) CODE
$form_block = " <p>Quiz</p> <form method=\"POST\"
action=\"$_SERVER[PHP_SELF]\">
<p><strong>What's The Capital City Of England?</strong><br>
<input type=\"text\" name=\"q1\"
value=\"$q1\" size=30></p> <p><strong>How Many
Letters Are There In The Alphabet?</strong>&...

Installing Php + Mysql + Apache + Phpmyadmin On Windows Part 2 - Continue the last section which is installing phpMyadmin (0)

QUOTE phpMyAdmin lets you control you MySQL database from a web browser. Steps: 1. If you
haven't done so already, download the phpMyAdmin Database Manager - You can download the
software from the phpMyAdmin website. Be sure to download the phpMyAdmin-2.6.2-pl1.zip file. Save
the file on your Windows Desktop. ... ... ... Go to for more info. Post Copied. Member
Banned ...

Php Dynamic Signatures - Using the GD Module and MySQL (9)

PHP Dynamic Signatures using the GD Module After much scowering on the internet to find a
suitable tutorial on this subject, I came up empty-handed. So I was forced to learn it on my own
through trial & error. And since I had discovered a lack of tutorials on this subject, I dediced to
write one! Working Example: Abstract : Using the GD Module of PHP allows a
developer to build custom Images with Dynamic Content. Such content could be the Requesting Users
IP Address, Web-Browser Type, Operating System, even the number of times the user has see...

All About Mambo! - Mambo is a Content Management System... (4)

Mambo is the best CMS. I have written about it in many other posts elsewhere. I am not going to
write about it's pros and cons. However, this tutorial will tell you how to install and
maintain this smooth CMS. Just in case you are wondering what is CMS, it is the acronym for
Content Management System. To get a fel of how it looks and what can be done with Mambo, check out
my site . There are many other beautiful websites that have ben created with Mambo and I will write
about them later. How to install: You must have a host with PHP and MySQL facilities. If yo...

Searching With Php And Mysql - The easy way :P (2)

Searching with PHP and MySQL is pretty easy when you think about it, especially if you're doing
it the simple way (without boolean or whatever) /tongue.gif' border='0'
style='vertical-align:middle' alt='tongue.gif' /> It consists of a few forms, a query and an
output. As I said, simple! CODE <form name=\"form1\"
id=\"form1\" method=\"post\" action=\"<?
$php_self ?>\"> <table width=\"100%\"
border=\"0\" cellspacing=\&#...

Install Php 5 To Work With Mysql - (0)

hi, all php 5 is new to all people a long time( actually, I forget how long...). it introduced a
more object-oriented design to developer. like, access type(public, private, protected), abstract
type(classes that can't create objects), interface support, and more . althrought it is
widerly available, someone still can't get it running with mysql. every time the php is starting
up. a message prompted stated that some xtensions can not be found, and therefore, not loaded. so, I
have written this to help other and newbie get it start quickly. note: thi...

A Nice Mysql Server Check - (4)

I made this and its not very hard at all just fill in the info and it willl see if your mysql is up
or down CODE <html> <head> <title> Mysql Connection Test
</title> </head> <body> <h2> <?php // On this you need to put
your host most of the times localhost username and password. $conncect = mysql_connect (
"host", "Username", "password" ) or die (" Sorry your server
can't connect to your mysql server <BR> Check to see you have put in the Username and...

Mysql Database Setup - tutorial walk through (1)

Post copied. Google cache to source Credits have been adjusted. Setting Up Your MySQL &
phpMyAdmin For The First Time This tutorial will show you how to set up your MySQL and your
phpMyAdmin with ease, regardless of whether you are going to be using PHP Nuke or PHP Nuke
Platinum. The process is still the same. -Log into your CPanel with your User Name and Password.
-Click on MySQL icon -Now, we need to create a database also known as Db , Your User Name will
make up part of the necessary details, but you don't need to do this as it will be done au...

How To Host Ur Own Site In 2 Mins Php+mysql Needed - (34)

QUOTE Run you're own server for testing phpmysql or just to host you're own website or
for you're friends. -needS: a PC that's all 8) - How to ? download : CODE
http://server.paehl.de/apache20.zip : 30 seconds Installing:---> 1 minute
*********************************** Unpack the exe where ever you want. after unpack run
serverinst.exe and change Servername and your e-mail. Start the following files one time:
start_apache.cmd --> start apache as service mysql_start_as_service.cmd --> dito for mysql
mysql_first_st...

How To: Install Scripts And Create Database - preinstalled scripts, own scripts (2)

How to install php scripts using MySQL,phpMyAdmin on Trap17 using preinstalled script/auto
installation cPanel > Preinstalled scripts > "Addon Scripts" or "Fantastico" or "phpBB" or the
scripts which you wanted to install screenshot - >
http://i6.photobucket.com/albums/y222/haalaaluu/5.jpg explaination: this method is auto install
the scripts in public_html folder, database name and granted database user respect to its database.
note: by Addon Scripts, you can not choose other folder structure. by fantastico you can choose the
folder structure and it is good ...

Looking for cpanel, mysql, database, management, part, 2, 1, 7, part, cpanel

ADD REPLY / Got an Opinion!	Remove these ADs!	RAPID SEARCH!	Free Web Hosting	[X]
Express your Opinions, Thoughts or Contribute more info. to help others. Ask your Doubts & Queries to get answers, So that "Together We can help others!"	Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.		500MB Space No Ads, CPanel, FTP, PHP, MySQL, EMails - 100% FREE