Click here to watch a video tutorial

When you create a database, many users are unaware that there are several other items that you need to do as well. The new database creation process actually involves:

  1. Creating a database
  2. Creating a database user
  3. Giving your database user access to work with your database

Luckily for us, cPanel includes a MySQL Database Wizard that walks you through each of these steps.

Creating a database in cPanel using the MySQL Database Wizard:

  1. Log into your cPanel
  2. Click the MySQL Database Wizard under the Databases heading
  3. Next to New Database enter a name for your database and click Next Step
  4. Next to Username enter a username.
  5. Enter a password next to Password, enter it again for Password (Again) and then click Create User
  6. On the next page, you'll assign privileges for the user to the database. Check the box next to All Privileges and then click Next Step.

    Congratulations, you have just successfully created a database!

Now that the database is set up in your cPanel, you will need to add a user to the database. Please see our article on How to create and attach a database user in cPanel.

Did you find this article helpful?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve this article:
Email Address
Name

new! - Enter your name and email address above and we will post your feedback in the comments on this page!

Like this Article?

Related Questions

Here are a few questions related to this article that our customers have asked:
Programatic way to create mysql databases and users
I do not want to use prefixes with the MySQL database or user
Can't create a new mySQL database
Would you like to ask a question about this page? If so, click the button below!
Ask a Question
n/a Points
2014-04-08 11:04 am

How I can fix it this trouble.... I try in this point everything. Like delete all the DB, reset the domain, try with other versions but nothing work... I try install a old version from PrestaShop 1.5.6.2. But I have the same error always:

Not found Server database. Please check the fields for username, password and server (DbPDO)

I check everything but I cant found what is wrong

Staff
15,897 Points
2014-04-08 12:49 pm
Hello Julio,

How are you installing the program? There should be a file that contains the username, database name, and password for your server. The server name for our hosting servers should be 'localhost'.

You can check the settings to ensure they match the database and use you have created. The file for those settings is settings.inc.php and is located in your /config folder.

Kindest Regards,
Scott M

Post a Comment

Name:
Email Address:
Phone Number:
Comment:
Submit

Please note: Your name and comment will be displayed, but we will not show your email address.

2 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!