hosted by liquidweb


Go Back   Web Hosting Talk : Web Hosting Main Forums : Web Hosting Talk Tutorials : Hosting Software and Control Panels Tutorials : Adding a MySQL database in CPanel (X2 Theme)
Reply

Forum Jump

Adding a MySQL database in CPanel (X2 Theme)

Reply Post New Thread In Hosting Software and Control Panels Tutorials Subscription
 
Send news tip View All Posts Thread Tools Search this Thread Display Modes
  #1  
Old
Web Hosting Master
 
Join Date: Aug 2003
Posts: 2,003

Adding a MySQL database in CPanel (X2 Theme)


This is taken from one of my CPanel articles I wrote several months back. I think this is one of the more helpful topics as people often have problems with MySQL, so here it is.

How do I add a MySQL database in CPanel?
*This article assumes you are already logged into CPanel*

Adding a MySQL database: In the 3rd row, 3rd to the right you will see an icon labeled as MySQL Databases. Click on it.

This will take you to a new page where you will see:

DB
Username
Password
Host


In the box marked as DB, this is where you will enter the name of the database. Do so now and click on the button labeled as Add DB. The database will then be created.

Now, in the Username and Password boxes enter the username and password which will be used for to access the MySQL database. Once you have done so, click on the button labeled as Add User.

In the Host box, if the MySQL server is on the same server then type in localhost and click on the button labeled as Add Host. If it isn't, then enter the IP/server name instead.

You now have a MySQL database and a user. So now you must add the user to the database in order to access it. At the top of the page there are 2 boxes across from each other. One will have the username in it and the other has the MySQL database name in it. If they are not already selected, click the drop down box and select your user and/or MySQL database. Once you have done this click on the button labeled as Add User to Db.


The user is now added to the database and you can start using it.



Sponsored Links
  #2  
Old
Tells All!
 
Join Date: Jul 2003
Location: UK
Posts: 1,879
1stStrike - Nice in-depth tutorial, well done, I'm sure many users will find this helpful!

  #3  
Old
Newbie
 
Join Date: Jun 2004
Posts: 7
good job ..! keep it up

Sponsored Links
  #4  
Old
Newbie
 
Join Date: Jul 2003
Posts: 6
It is indeed a good article..! But one of the things that I have experienced is that people forget assigning users to databases, which creates problem and throws a database login error.
Especially newbies need to take care about that ..!

  #5  
Old
Newbie
 
Join Date: Aug 2004
Posts: 10
Re: Adding a MySQL database in CPanel (X2 Theme)

Quote:

Now, in the Username and Password boxes enter the username and password which will be used for to access the MySQL database. Once you have done so, click on the button labeled as Add User.

The user is now added to the database and you can start using it.
Does it matter what user/pass you select or should you select your cpanel user/pass?

thanks,
SHG

Reply

Related posts from TheWhir.com
Title Type Date Posted
Tesora's OpenStack DBaaS Supports MongoDB, Cassandra, Redis, and MySQL Web Hosting News 2014-05-23 14:53:11
Google Releases Hosted Database Service Cloud SQL to General Availability Web Hosting News 2014-02-12 13:46:02
Google Cloud Provides Support For Native MySQL Connections Web Hosting News 2013-11-01 14:36:06
Web Hosting Sales and Promos Roundup - September 20, 2013 Web Hosting News 2014-05-23 15:42:47
cPanel Security Updates Address Perl Module Vulnerabilities Web Hosting News 2012-12-06 12:55:54


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Postbit Selector

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump
Login:
Log in with your username and password
Username:
Password:



Forgot Password?
WHT Host Brief Email:

We respect your privacy. We will never sell, rent, or give away your address to any outside party, ever.

Advertisement:
Web Hosting News:
WHT Membership
WHT Membership



 

X

Welcome to WebHostingTalk.com

Create your username to jump into the discussion!

WebHostingTalk.com is the largest, most influentual web hosting community on the Internet. Join us by filling in the form below.


(4 digit year)

Already a member?