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!

Support Center Login


Social Media Login

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
23,972 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
n/a Points
2014-11-11 12:45 am

Thanks, your details are ver usefull.

n/a Points
2015-01-09 12:58 am

i have learned to create database. now would you please tell me how to create tables in the database? and how i would connect my webpage to the database (connection string)?

Staff
21,466 Points
2015-01-12 4:02 pm
Hello Abdul Hadi,

Thanks for the question. You can manage your database through phpMyAdmin. Through phpMyAdmin, you can also add a new table to your database. We also have an article that can help to show you how to insert data. The article also demonstrates a sample connect string for the database.

I hope this helps to answer your question, please let us know if you require any further assistance.

Regards,
Arnel C.
n/a Points
2015-01-31 3:10 pm
Just fine as is--don't mess with it!
n/a Points
2015-02-07 11:30 am
It's great
n/a Points
2015-02-09 10:58 am

I would like to add another mySQL database for a WordPress installation on my subdomain, but I'm getting the message:

Warning: You are currently using the maximum number of MySQL databases. If you need more please contact your service provider.

Where do I go to add another database?

Thanks!

Staff
21,466 Points
2015-02-09 11:25 am
Hello Kelli,

Sorry that you're running into the database limit with your current hosting plan. The number of databases that can be generated is based on the hosting plan you have selected. The only way to increase the number of databases is to upgrade your current plan. You can upgrade your current plan in AMP and then you would be able to add the other database. Otherwise, you would need to delete a database before you can create a new one.

I hope this helps to answer your question, please let us know if you require any further assistance.

Regards,
Arnel C.
n/a Points
2015-02-09 11:45 am

Thanks, I wasn't sure where to go to do that.  

n/a Points
2015-03-24 10:26 am

 Hello, I create my own database and I brought a script online and how do publish it on my database. It almond classified ads. Anyone had use it before?

Staff
2,033 Points
2015-03-24 1:35 pm
Hello Kenny,

The classifieds web script should write to the database itself. If you have not done so you will need to connect the classifieds program to the database via its configuration file.

Best Regards,
TJ Edens

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.

13 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!