Working with database users and Privileges Print

  • 14

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.

database 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.

databases and users

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.

mysql users

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.

database priviledges

Was this answer helpful?

« Back