Knowledgebase
Set Up cPanel MySQL Database and User
Posted by on 16 December 2013 04:28 PM

Intro to cPanel MySQL Databases

Each database you use on your account needs to have a distinct name. Each database you connect to needs a database username assigned to the database so your scripts/website can connect to it. For this document, we'll assume you have the domain name example.com, and your cPanel login/username is example.
Create a New Database
  1. Login to cPanel using the URL: http://example.com/cpanel
  2. Click MySQL Databases
  3. On the next screen, scroll to and click Current Databases
  4. Click New Database
  5. Type in the database name (let's call it 'mydb') in the empty text field and click Create Database
Your database name will automatically be prefixed with your cPanel username. Anytime you need to reference the database, it will look like this: example_mydb.
Create a Database User
Each database needs a username to allow connections. To create a database user:

  1. Log into your cPanel account
  2. Click MySQL Databases and scroll down to Current Users
  3. Look for username and password fields
  4. Type in a username and password
    Note: we'll assume you are using 'dbuser' with password 'user123'
  5. Click Create User
Your database username will automatically be prefixed with your cPanel username, so be sure to reference the full username in your scripts:

     User: example_dpuser
     Pass: user123

Add User to Database
Finally, you need to associate the new username with the database. To do so:
  1. Scroll down to and click Add Users to Your Databases
  2. Select 'example_dbuser' from the dropdown menu on the left and the database 'example_mydb' from the dropdown menu on the right
  3. Click Add User to Database
That's it. You've created a database, a database user and connected the two together. Here's the information you will use for your scripts (such as Wordpress or vBulletin):

   server: localhost
   database: example_mydb
   database user: example_dbuser
   database password: user123



(0 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
Help Desk Software by Kayako fusion