How to assign a user to a MySQL database in cPanel?



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.

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

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

  • 0 Users Found This Useful

Was this answer helpful?

Related Articles

How to password protect a directory in cPanel?

How to password protect a directory in cPanel This demo assumes you've already logged in to...

How to Restore MySQL Database from phpMyAdmin?

This article will provide you the step by step guidance on how to restore MySQL database through...

How to delete Domains/subdomain in the cPanel?

You can delete the add-on domains and sub-domains from the cPanel. Add-On Domain: Login to...

How to set your default address in cPanel?

How to set your default address in cPanel This demo assumes you've already logged in to...

How to set a return to sender failure message for unrouted emails in cPanel?

How to set a return to sender failure message for unrouted emails in cPanel This demo assumes...