How to assign a user to a MySQL database in cPanel

This demo assumes you’ve already logged in to cPanel, and are starting on the home screen.
image01

Now let’s learn how to assign a user to a database.

Click the “MySQL Databases” icon.
image02

Under “Add User To Database”, select the user you want to add, and then select the database you want to add it to.
image03

When ready, click “Add”.
image04

Select the privileges you want to grant the user… in this case, let’s select “All Privileges”.
image05

Then click “Make Changes”.
image06

That’s it! The user has been assigned to the database.
image07

You can see the user assigned to the database in the table of databases.
image08

This is the end of the tutorial. You now know how to assign database users to databases in cPanel.

Was this article helpful?

Related Articles