Knowledgebase: All about cPanel
Grant a user's permissions to a MySQL database
Posted by Roy Petersen on Feb-15-2007 12:16 PM

Once you have created a user to use a database you need to grant that user permission to use the database. If you have not yet created a user, refer to "creating a mySQL user" in the knowledge base for more information.

To grant user permissions to a MySQL database:

  1. Click on the MySQL databases button on the home page.

  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 Db 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