> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://support.dotcanada.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# How to manage MySQL users and grant permissions in cPanel

Here is how to manage MySQL users and grant permissions in cPanel for dotCanada.com customers:

1.	Log into your dotCanada.com cPanel account.

2.	Under the "Databases" section, click on "MySQL Databases".

3.	To create a new MySQL user: • Click on "Add User" • Enter a username and password for the new user • Click "Create User"

4.	To grant permissions to an existing MySQL user: • Click on the "Add User" link next to the user you want to modify • Under "Add User Permissions", select the appropriate permissions • You can grant "All Privileges" or specific permissions like SELECT, INSERT, UPDATE, etc. • Choose the database(s) this user should have access to • Click "Make Changes"

5.	To change a user's password: • Click on the pencil icon next to the user • Enter the new password • Click "Change Password"

6.	To revoke a user's permissions: • Click on the pencil icon next to the user • Under "Revoke User Permissions", select the permissions to revoke • Click "Make Changes"

7.	To delete a MySQL user completely: • Click the "Remove User" link next to the user's name • Confirm you want to remove the user

At dotCanada.com, we recommend creating separate users for each application that needs MySQL access. This allows you to grant only the necessary permissions and increase security.