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

December 20, 2021 / SQL

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 this 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 that you want the cPanel user to own.
  7. To save your changes, click the “Submit” button.

Related documentation: Database Map Tool

We sincerely hope that you now have 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. Additionally, find out more about How to Inspect the Sizes of MySQL Databases and Tables

Leave a Reply

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