How to Assign a User to a MySQL Database in cPanel
This guide details the steps necessary to link an existing database user to an existing MySQL database and define the user's access permissions.
Step 1: Accessing Database Management
- Log in to your cPanel control panel.
- Navigate to the Databases category and click on the MySQL Databases link.
Step 2: Assigning the User
- On the MySQL Databases page, scroll down until you locate the "Add User To Database" heading.
- Use the drop-down menus to select the specific database user you wish to link, and then select the database that user needs access to.
- Click the Add button to initiate the assignment process.
Step 3: Setting User Privileges
- On the next screen, choose the privileges you want the user to have within the database. Selecting All privileges is generally suitable for most web applications.
- Click the Make Changes button to save the permissions and complete the user assignment.
The database user now has the specified access rights to the selected database.
