InMotion Hosting Support Center

When you create a database, many users are unaware that there are several other tasks 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. WARNING: If you receive an error message regarding the limited number of databases available, you may consider upgrading your Business Class Hosting plan.

  5. Next to Username enter a username.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! Now, you know how to successfully create a database.

Was this article helpful?

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Support Center Login

Our Login page has moved, Click the button below to be taken to the login page.

n/a Points
2018-11-03 7:13 pm

I was having the same issue of the database not showing in phpMyAdmin after creating it in the wizard. This was solved by logging out and then logging back in to my inMotion account.

Staff
3,228 Points
2018-11-05 7:43 pm
I'm sorry to see that it wasn't working right away. I'm glad to see the issue was resolved the next time you logged in. Thanks for letting us know, your contribution to the community is appreciated!
n/a Points
2018-06-09 4:35 pm

When in my cPanel, it says I am using all of my MariaDB.

You are using your maximum allotment (2) of MariaDB/MySQL databases. If you want more, contact your service provider.

it then says my two databases are .26MB and .92MB.  This is not alot of space.  In fact I do not use databases at all since I'm not online yet.

Is this an issue for me??

Thanks!

 

Staff
1,173 Points
2018-06-11 10:46 am
Database usage is not based on size its based on the number of databases, Being maxed out on databases is not an issue for the performance of your sites however if you wanted to add another site to your account that needs a database you would need to remove one of the existing ones or upgrade your plan.
n/a Points
2018-06-21 12:41 pm

i am also having issues showing two databases, how do i know wich one to delete

Staff
42,432 Points
2018-06-21 1:56 pm
If you are hosting with InMotion Hosting, then please contact the live support team via ticket, phone call, or chat to get additional assistance with this issue. It may require further investigation with the live support team in order to determine the cause and provide a resolution.
n/a Points
2018-03-12 7:21 pm

Hello Support Team,

If I have already created a MySQL database on my desktop (using the Oracle MySQL Community Edition software), how do I upload it to my account in In Motion Webhosting? I am new to web databases, but you will tools like forms, combo boxes, list boxes to illustrate my database information?

I have another question: - do you offer Microsoft Azure database services or MySQL for Visual Studio services. 

Kind regards,

Laurence Hennis

Staff
42,432 Points
2018-03-13 10:17 am
Hello Laurence,

Oracle is a much different database than MySQL as its PAID version has a much more developed interface for management and development. The interface used in the Community version likely derives from this interface. You can do most if not all of the things you need from an SQL database using MySQL, but it will not have the same user interface as you're familiar with in your previous client. For more information see the other articles on MySQL or check out Managing a MySQL Database in cPanel with PHPMyAdmin .
n/a Points
2018-02-13 4:44 pm

Hi! When connecting to the database using php, an error is returned: Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /home/bitcoi27/public_html/config.php:10 Stack trace: #0 /home/bitcoi27/public_html/test.php(1): require_once() #1 {main} thrown in /home/bitcoi27/public_html/config.php on line 10.

In phpMyAdmin, the database is created, but when checking the privilege, it shows that there are no privileges. Perhaps the reason is this. What should I do?

Staff
10,806 Points
2018-02-13 4:55 pm
This looks like an issue with the mysql_connect function, which was no longer supported as of PHP version 7. You may want to use the Mysqli_connect instead.
n/a Points
2018-01-15 1:25 am

Yes, I am having the same issue too. When I go to phpMYadmin, the database that I created does not show up either

Staff
42,432 Points
2018-01-15 9:47 am
Sorry for the problem with your database not appearing. This has been reported previously and it has been identified as a cPanel issue. Please report this problem to our live technical support team via a verified support ticket. The support team will need to identify your account in order to address the issue. An update may need to be applied to your account in order to resolve the problem.
n/a Points
2017-12-13 4:23 pm

I can not see the database after creating it. This appears to be the same issue as the person above was experiencing.

Initially I tried to just copy the database of my website and have it create the database while doing so. That reported an error so I deleted it and manually created with the same name and still couldn't see it.

Staff
42,432 Points
2017-12-13 6:10 pm
Hello,

Sorry for the problem with your database not appearing. This has been reported previously and it has been identified as a cPanel issue. Please report this problem to our live technical support team via a verified support ticket. The support team will need to identify your account in order to address the issue.

n/a Points
2017-11-18 6:56 pm

Hello Support,

 

After following the provided steps above it creates a data base.

BUT AFTER THAT WHEN I GO TO PhpMyAdmin i can NOT find my data base.

using phpMyAdmin console and typing "show databases;"

it show the created database!!

I have to type its name in the url to use it and it never show in the left panel of phpmyadmin

https://secure236.inmotionhosting.com:2083/xxxxxxxxxxxxxxxx/3rdparty/phpMyAdmin/db_structure.php?server=1&db=MYDATABASETHATICREATED

SO do you have nay solutions it is annoying and can not handle it any more

I need URGENT solution so i can import my local database using phpMyadmin

 

Staff
42,432 Points
2017-11-20 11:22 am
Sorry to hear about the frustrations with the creation of the database and then seeing it in the phpMyAdmin. In order for us to troubleshoot it we would need more information about the account. Primarily, we would need the account name or primary domain. If you want to handle this issue privately, then please contact our live technical support team via phone/email/chat.

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.

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