mySQL user permissions

Once you have created a user to use a database you need to grant that user permission to use the database.

To grant user permissions to a mySQL database:

  1. Click on the MySQL Databases link in the Advanced Menu area.

  2. Choose the specific user from the User drop-down list and the specific database to grant permissions to from the Db drop-down list.

  3. Click on the Add User to Database button button. The user now has permission to use that database and sample connection strings are shown in the mySQL window.

Granting a user's permissions to a mySQL database

A user will no longer be able to access a particular database when you have removed their permissions to that database.

To remove a user’s permissions:

  1. Click on the MySQL Databases link in the Advanced Menu area.

  2. Click on the Delete button next to the specific user underneath the name of the database in the Databases area.

Removing a user's permissions