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.

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

Click the "MySQL Databases" icon.

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

When ready, click "Add".

Select the privileges you want to grant the user... in this case, let's select "All Privileges".

Then click "Make Changes".

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

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

Was this answer helpful?

 Print this Article

Also Read

How to check a MySQL database for errors in cPanel

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

How to repair a MySQL database in cPanel

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

How to setup a database using the MySQL Database Wizard in cPanel

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

How to delete a MySQL database user in cPanel

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

How to create a MySQL database user in cPanel

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