SQL

How can you map MySQL databases and users to cPanel users?

In this tutorial, we’ll explain how you can map MySQL databases and users to cPanel users.

MySQL doesn’t have any kind of concept of database ownership; for reason, cPanel stores the database mappings in the /var/cpanel/databases folder.

If you want to restore the database manually, you need to map the databases and the usernames to the cPanel accounts.

Follow the Procedure to map the database:

Mapping the MySQL databases can be done in WHM:

1. Log in to WHM

2. Click on the SQL Services 

3. You can see the Database Map Tool

4. You must choose either the cPanel user’s domain name or username here. You can also search the list of domains or users using the “Search by” tool. Then press the “Select” key.

5. In the “Database users” text box on this page, you can enter a comma-separated list of database users that the cPanel user should own.

6. In the Database names text box, you need to enter a comma-separated list of databases which you want for the cPanel user to own.

7. To save your changes, click the “Submit” button.

Related documentation: Database Map Tool

Do we sincerely hope that you must now have got a clear idea regarding How can you map MySQL databases and users to cPanel users? However, if you are still facing any difficulty in the procedure mentioned above, feel free to reach out to the bodHOST Team for proactive support 24×7. Check out our web hosting plans today.

Leave a Reply

Your email address will not be published. Required fields are marked *