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
PhpMyAdmin access on VPS account
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
29,167 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
26,137 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
26,137 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
5,114 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
29,167 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
29,167 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
17,726 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
n/a Points
2015-07-06 2:02 pm

The link above, How to create and attach a database user in cPanel at the end of the article sends me back to this page.

Staff
17,726 Points
2015-07-06 2:44 pm
Hello DK,

Thank you for contacting us, and letting us know. I have updated the link to go to the correct article.

Let us know if you see any other issues.

Thank you,
John-Paul
n/a Points
2015-07-22 6:12 am

Hi,

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

Staff
26,137 Points
2015-07-22 10:39 am
Hello Anil,

If you are creating a database and it does not appear, then it's possible that the database is not being created. We would need to have more information on the account to see what's happening. If you're a customer of InMotion, please information on your domain and we can look to see what's happening.

Regards,
Arnel C.
n/a Points
2015-07-22 6:33 am

i added the user to the databsae and when i seen in the phpmyadmin there was not any databae please solve this

Staff
26,137 Points
2015-07-22 10:41 am
Hello Jai soni,

As per the user above, we would really need to know what domain/account is involved during the creation of the database in order for us to investigate the problem. Please provide us more information on the account and we can look into the issue further.

If you have any further questions or comments, please let us know.

Regards,
Arnel C.
n/a Points
2015-08-21 2:27 am

I want to fetch file from database (phpadmin on serever) and save this file on c panel public_html .in public_html i created data foleder i want to save this file in data folder...please give me solution

Staff
29,167 Points
2015-08-21 9:57 am
Hello soniya,

Unfortunately we do not provide custom coded solutions. You will want to either code that yourself or hire a coder to do that for you.

Kindest Regards,
Scott M
n/a Points
2015-08-22 2:31 am

hii scott, i dont want code,but tell me can i create folder in c panel and fetch file from database in that folder?

Staff
29,167 Points
2015-08-24 1:43 pm
Hello Soniya,

No, that would take some sort of coded script.

Kindest Regards,
Scott M
n/a Points
2015-08-25 2:17 am

ok,no problem scoot

n/a Points
2015-08-23 10:56 am

Thank you very much for taking the time to share these tutorials. It helped me a lot to setup a test site.

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.

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