Create a new MySQL user and assign it to a specific database within the WHM interface. This process allows a server administrator to manage database permissions at the user level rather than using the root account.
Before you begin
You will need:
Root access to the WHM interface
The name of the database you wish to assign the user to
A chosen username and password for the new MySQL user
Create and assign a MySQL user
Log in to WHM.
In the left-hand navigation menu, search for MySQL Databases and select it.
Scroll down to the New One MySQL Databases section.
Enter a name for the new MySQL user.
Enter a password for the MySQL user.
Select the database from the MySQL Databases dropdown menu to assign the user to that specific database.
Click Create.
Confirm the result
The new MySQL user will appear in the list of users.
The user will be associated with the selected database.
You can verify the connection by attempting to log in to the database using the new credentials via a tool like phpMyAdmin or a command-line client.
Limitations
This process creates a user with permissions limited to the specific database selected in the dropdown menu. If the user requires access to multiple databases, you must repeat the assignment process for each additional database.
