Working with database users and Privileges

In this tutorial we will look into the basic methods of adding users to your different databases and checking which user has access to which database, as this is fairly important when trying to setup your website.

Step1: Log in to your desired cPanel account.

Step2: From 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.

Step3 : This 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.

Step 4: If you scroll a little further down you will notice the MySQL Users section, which will allow you to create additional database users and attach them to different databases.

Step 5: One you have created your database and database user you can simply choose them from the drop-down menus under Add a User to a Database and click on "Add". This will open up a new window allowing you to set the privileges the user will ahve over the database, for example you can create a user that will only be allowed to perform selects or updates but not deletions. However in most cases when installing some application like Wordpress for example you will need to have the All privileges option chosen, as this will allow this user full control over the database.
  • Email, SSL
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to login into cPanel

This article will review the two different ways you can login to cPanel -  via WHM and via a...

How to log into WebMail

Step 1. Visit yourdomain.com/webmailNote! Be sure to replace yourdomain.com with your actual...

Creating a wildcard subdomain

Wildcard Subdomains and DNS You may need to set up a wildcard subdomain, and this can be done...

How to backup your website

Backing up your website is a necessary step for all users.Before making any changes to your...

Modifying your MX records

Step 1. The first step is to log into your cPanel account.Step 2. Once logged into cPanel, find...