Define a User's Privileges

Privileges define how the user is able to interact with the database. For example, they will determine whether or not the user can add and delete information.

To define a user’s privileges:

  1. Under Add User to Database, select a user from the User drop-down menu.
  2. From the Database drop-down menu, select the database to which you wish to allow the user access.
  3. Click Add.
  4. From the MySQL Account Maintenance screen, select the privileges you wish to grant the user, or select ALL PRIVILEGES.
  5. Click Make Changes.
  • 16 Users Found This Useful
Was this answer helpful?

Related Articles

How do I add a user to a MySQL database?

Login to cPanel. Locate and click on the "MySQL Databases" icon under the "Databases"...

How do I export a MySQL Database?

Login to cPanel. Locate and click on the "phpMyAdmin" icon under the "Databases" category....

How do I remove a MySQL user from a database?

Login to cPanel. Locate and click on the "MySQL Databases" icon within the "Databases"...

How do I create a MySQL database?

Login to cPanel. Locate and click on the "MySQL Databases" icon in the "Databases" category....

How do I delete a MySQL database?

Login to cPanel. Locate and click on the "MySQL Databases" icon under the "Databases"...