cPanel MySQL 05 How to assign a MySQL user to a database

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

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

  • MySQL, assign
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

cPanel MySQL 01 How to use the MySQL wizard

1. How to setup a database using the MySQL Database Wizard in cPanel This demo assumes you've...

cPanel MySQL 03 How to delete a MySQL database

3. How to delete a MySQL database in cPanel This demo assumes you've already logged in to...

cPanel MySQL 02 How to create a MySQL database

2. How to create a MySQL database in cPanel This demo assumes you've already logged in to...

cPanel MySQL 04 How to create a MySQL user

4. How to create a MySQL database user in cPanel This demo assumes you've already logged in to...

cPanel MySQL 06 How to change a MySQL user password

6. How to change a MySQL database users password in cPanel This demo assumes you've already...