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:
Log into your dotCanada.com cPanel account.
Under the "Databases" section, click on "MySQL Databases".
To create a new MySQL user: • Click on "Add User" • Enter a username and password for the new user • Click "Create User"
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"
To change a user's password: • Click on the pencil icon next to the user • Enter the new password • Click "Change Password"
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"
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.
Log into your dotCanada.com cPanel account.
Under the "Databases" section, click on "MySQL Databases".
To create a new MySQL user: • Click on "Add User" • Enter a username and password for the new user • Click "Create User"
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"
To change a user's password: • Click on the pencil icon next to the user • Enter the new password • Click "Change Password"
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"
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.
Updated on: 19/04/2024
Thank you!