While using the MySQL Database Wizard is the easiest way to create both a MySQL database and user, if you have created a database but not a user, this article will walk you through creating a database user and assigning that user to a database.

Creating a database user is actually a two step process:

  • Create the user and password
  • Assign the user to a database
  1. Begin by logging into your cPanel.

  2. Click on the "MySQL Databases" icon under Databases in your cPanel home screen.

  3. cpanel-mysql-databases

  4. In the MySQL Databases area, scroll down until you see the "MySQL Users Add New User" area.

  5. All database names and database user names are prefixed with your cPanel username. Type in the last part of the username for your new database user and type in a password for the user.

    mysql-database-add-user

  6. Click the "Create User" button. On the next screen you will receive the confirmation message that your user was created. Click on the "Go Back" link to return to the MySQL Databases screen.

  7. To assign the database user to the database, look for the "Add User To Database" area just below "Add New User." Select the user you created in Steps 4-5 and the database you want to assign them to from the drop down menus. Click the Add button.

    mysql-database-add-user-to-db

  8. In the Manage User Privileges screen select "All Privileges" for your user and click the "Make Changes" button.

    mysql-user-privileges

Congratulations! You've created your new database user and assigned that user to a database.

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?

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:
Would you like to ask a question about this page? If so, click the button below!

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.