InMotion Hosting Support Center

Generally, when you want to create a database in the cPanel, using the MySQL Database wizard is the fastest and easiest way. This creates both the database and a user for that database. However, you may need to either add a database user to a database or wish to create a single user you want to add to multiple databases. In that case, you will need to create the users manually. This article will guide you through how to create and attach a database user in cPanel.

Creating the database user

  1. Log into your cPanel dashboard.
  2. Locate the Databases icon from your main cPanel page and click on the MySQL Databases icon.
    select mysql database tool
  3. Once inside the database area, scroll down until you see the MySQL Users Add New User section. From here, you will see the form to create your new user. Note that the database name will always be prefixed with your cpanel username. Add the second portion to create the new database username. For example, our new user will be named inmoti6_imhtest.
    create new user name
  4. Type in the password you desire for both the Password and Password (Again) fields.
  5. Click the Create User button to complete the database user creation.

Assign the user to one or more databases

Now that you have created the user, it is time to assign it to the database or databases you wish for it to access. You will begin from the same Database page where you created the user.
  1. Locate the Add User to database section. You will see two dropdowns here. Select your desired user from the top dropdown and the database you wish to add it to from the lower dropdown.
    add new user to database
  2. Click the Add button to save the changes.
  3. You are brought to a screen that allows you to select privileges. Generally speaking you will want to click the checkbox for ALL PRIVILEGES. Selecting individual privileges is a customization for advanced users.
    add user privileges
  4. Click the Make Changes button at the bottom to save the user and privileges to the database. You will be able to see the new user in the user list for each database they are assigned to in the database list.
    user added to database
  5. Repeat steps 1-4 for any additional databases you want to allow the user to have access to.
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-03-29 4:24 pm

Created Databases are not shown in my phpmyAdmin. Why?

10,724 Points
2018-03-29 4:46 pm
I advise contacting your host to see if they can replicate the issue and find a cause. What you are experiencing is certainly not the desired outcome.
n/a Points
2016-06-18 4:19 am

WARNING: You currently use the maximum number of MySQL databases. If you need additional databases, contact your service provider.

43,761 Points
2016-06-20 11:53 am
This means you are at the maximum databases allowed for your account. If you need more, you will need to contact your service provider and upgrade your account. Or you can delete any databases you no longer need.
n/a Points
2015-10-28 9:44 am

bt its showing table query error..

Error creating the table query wasCreate Table (id_user INT NOT NULL AUTO_INCREMENT ,name VARCHAR( 128 ) NOT NULL ,email VARCHAR( 64 ) NOT NULL ,phone_number VARCHAR( 16 ) NOT NULL ,username VARCHAR( 16 ) NOT NULL ,password VARCHAR( 32 ) NOT NULL ,confirmcode VARCHAR(32) ,PRIMARY KEY ( id_user ))mysqlerror:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(id_user INT NOT NULL AUTO_INCREMENT ,name VARCHAR( 128 ) NOT NULL ,email VARCHA' at line 1

42,232 Points
2015-10-28 10:28 am
Hello Zmf,

Sorry for the SQL syntax error that you're seeing. Per the error message, you have a syntax error in your query that may involve either missing punctuation or the incorrect use of certain commands. We do not provide coding support as it is beyond the scope of our support, but you may need to speak with a programmer in order to identify the exact problem. It's possible that a part of the code located within this section " (id_user INT NOT NULL AUTO_INCREMENT ,name VARCHAR( 128 ) NOT NULL ,email VARCHAR( 64 " is using deprecated commands.

Apologies again that we can't provide a direct answer for the issue. If you have any further questions or comments, please let us know.

Arnel C.
n/a Points
2015-09-11 7:14 am

This tutorial is helpul.


it worked for me.

Thanks guys ..

Post a Comment

Email Address:
Phone Number:

Please note: Your name and comment will be displayed, but we will not show your email address.

7 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?


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