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.
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Create a Database

To create the database: In the New Database field, type a name for the database....

Check a Database for Errors

If you are experiencing problems using any database related software you have installed on the...

Repair a Database

If you have checked a database and found an error, you will need to repair it. To repair a...

Create a Database User

After you create the database, you will need to add users and their privileges so that the...

The Current Databases Table

This table contains a list of databases on your server. For each database, the table displays:...