Grant a user 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. If you have not yet created a user, refer to Creating a MySQL user 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
  • 8 Users Found This Useful
Was this answer helpful?

Related Articles

MySQL

SQL stands for Structured Query Language. SQL is an international standard in querying and...

Removing a database

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

Creating a MySQL user

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

Managing MySQL databases

CPanel includes a web-based MySQL management tool called phpMyAdmin. This tool allows you to...

Adding host access

You can allow external web servers to access your MySQL databases by adding their domain name...

Powered by WHMCompleteSolution