How To Assign a User to a MySQL Database in cPanel

  1. This tutorial assumes you’ve already logged in to cPanel, and are starting on the home screen.
  2. Now let’s learn how to assign a user to a database.
  3. Click the "MySQL Databases" icon.

    cpanel-pl-mysql-5-assignuser-02

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

    cpanel-pl-mysql-5-assignuser-03

  5. When ready, click "Add".

    cpanel-pl-mysql-5-assignuser-04

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

    cpanel-pl-mysql-5-assignuser-05

  7. Then click "Make Changes".

    cpanel-pl-mysql-5-assignuser-06

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

    cpanel-pl-mysql-5-assignuser-07

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

    cpanel-pl-mysql-5-assignuser-08

 

Be Sociable, Share!

    Published by

    Here's 75 % off, Launch a New VPS Today. Find out why 30,000 customers have chosen our Best-in-Class Performance & 24x7 Heroic Support