A Web.com Partner

How to assign a user to a MySQL database in cPanel

cPanel Paper Lantern MySQL series

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.

image0115

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

Click the “MySQL Databases” icon.

image0237

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

image0334

 

When ready, click “Add”.

image0434

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

image0533

Then click “Make Changes”.

image0630

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

image0726

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

image0822

 

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

x