How can I Grant a user's permissions to a MySQL database?

Once you have created a user to use a database you need to grant that user permission to use the database. 1- Click on the MySQL databases button on the Cpanel 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.
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How can I create a MySQL database?

1- Click on the MySQL databases button on the Cpanel home page. 2- Enter the name of the...

How can I Remove a database?

Removing a database will delete that database from its online location. Be sure that you have...

How can I Create a MySQL user?

You need to create a MySQL user before that user is able to use the database. This does not...

How can I Remove a user?

Removing a user deletes that user - it removes all database permissions that the user has and...

How can I Remove a user's permissions?

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