You can create a MySQL user in cPanel to manage specific database permissions for your website or application. This process allows you to assign a unique username and password to a database while restricting that user's access to only the necessary databases.
Before you begin
You will need:
A cPanel account with the appropriate permissions to manage MySQL databases.
A chosen username for the MySQL user (typically starting with your cPanel account prefix).
A secure password for the MySQL user.
Create a MySQL user
Log in to your cPanel account.
Locate the Databases section and select MySQL® Databases.
Scroll down to the MySQL Users section.
Enter a new username in the Add MySQL User field.
Enter a password for the account in the Password field.
Click Add User.
Confirm the result
The new user will appear in the list of MySQL users.
You will see a confirmation message indicating the user was successfully created.
Note: Assigning permissions
Creating a user only creates the identity; it does not grant access to a database. To allow the user to access a specific database, you must scroll to the Add Privileges section on the same page, select the user and the database, and click Add.
