Lots of websites use MySQL databases, including content management systems, e-commerce solutions, and forums. MySQL databases can be created from within your cPanel.  When a database is created, there are three primary tasks:

  1. Create the database
  2. Create a database user
  3. Assign the user to the database

While cPanel allows you to do these tasks separately in the MySQL Databases section of the cPanel, it is much easier to use the MySQL Database Wizard as it will walk you through these steps.

To create a database using the Database Wizard, first log into your cPanel and click on "MySQL Databases Wizard" under the "Databases" sub-header:

mysqlwizard1

On the next screen, put in the name for the database that you want to create.  In this example, we will name it test2.  Then click on "Create Database:"

mysqlwizard2

Next we will create a user for the database.   Put in the username that you want to use (all usernames will start with your Web Hosting Hub username), and enter a secure password.  Then click on "Create user":

mysqlwizard3

On the final screen, you will decide what privileges to give the user to the database.  Unless you are creating a second user that you want to have limited access, click on "ALL PRIVLEDGES" and click on "Next Step":

mysqlwizard4

You are done!  You will get a confirmation page with the database that you just created:

mysqlwizard5

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!

Did you find this article helpful?

Comments

n/a Points
2016-04-13 7:01 pm

I need know if you have support for Sql server database?

Staff
17,314 Points
2016-04-14 3:54 pm
Hello Dnis,

MySQL is a "flavor" of SQL, so as long as your SQL database matches up with mySQL then it should be no problem. You may need to look at the differences between MySQL and SQL to make sure that your database functions the same.

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

Regards,
Arnel C.
n/a Points
2018-04-12 6:34 am

I've created a database with the mySQL Wizard, but the database does not show up in phpMyAdmin. I'm at a loss as to how I can import my .sql file without the new database showing up. I tried to repeat the process, but get a message saying that I can't create the database because it already exists. When I refresh phpMyAdmin, the database still doesn't show up there, but it does show up in the MySQL Databases page.

Staff
12,339 Points
2018-04-12 4:56 pm
Since this seems like unusual behavior for cPanel, I recommend contacting Live Support so they can test your specific account.

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.

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!
Need More Help?

Help Center Search

Current Customers

Email: support@WebHostingHub.com Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.)
Chat: Click To Chat Now

Ask the Community

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

Not a Customer?

Get web hosting from a company that is here to help.
}