When working with databases for your website, you may need to know which users are assigned to certain databases so you can create code to work with them or if you are using SSH (or shell) access. While you may remember the user if you created the database on your own, programs installed via Softaculous automatically create databases and assign users in the background.

This article helps you in being able to identify what users are assigned to particular databases on your hosting account via the cPanel.

Determining which users are assigned to databases

  1. Log into your cPanel interface.
  2. click the database toolFrom within the main cPanel page, look to the right hand panel. From there, locate the Databases category and click on the MySQL Databases tool icon.
  3. find users in database list tableThis brings you to the MySQL databases list page. You will see each database listed. Next to each database is a column with the users that can access the database. In the example here, you can see that one database has two users that have access and the other has one.
Continued Education in Course cPanel
You are viewing Section 3: How to find which users are attached to databases
Section 2: Preventing the "Index Of" listing page using the Index Manager
Section 4: 301: How to run a cron job
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!

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

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.

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