InMotion Hosting Support Center

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.

Support Center Login

Social Media Login

   
Social Login Joomla

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
27,163 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
24,842 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
24,842 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
3,251 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
n/a Points
2015-04-07 12:44 am

Hi,

i create database in cpanel using database wizard but that database not shown in phpmyadmin pls help me about this problem

 

Staff
27,163 Points
2015-04-07 8:38 am
Hello,

If that occurs, you will want to contact the Live Support as there may be ownership or permissions issues with the database.

Kindest Regards,
Scott M
n/a Points
2015-04-25 8:52 am

The link "How to create and attach a database user in cPanel" just leads back to the how to create a database page. Frustrating! And you can't use phpMySQL unless you're a user.

Staff
27,163 Points
2015-04-27 1:08 pm
Hello Lionel,

Apologies for the incorrect link. It has now been adjusted and points to the correct article.

Kindest Regards,
Scott M
n/a Points
2015-04-28 4:14 am

Thanks Scott. Your prompt service is impressive.

n/a Points
2015-05-13 9:12 pm

Hello, 

I made MySql datbase to connect my Cpanel with WordPress, I am trying to make a maintenance page but nothing happens, I changed all wp-config user and database name in my Cpanel public page, still nothing is working. I turned off 2 other MySQL databases and nothing, any idea?

Thank you in advance.

Lilia Ch.

Staff
16,301 Points
2015-05-18 2:22 pm
Hello Lilia,

Thank you for question. Here is a link to our helpful guide on how to How to enable WordPress Maintenance mode. It shouldn't require you to modify the database directly.

Thank you,
John-Paul

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.

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