Question

What is a MySQL/Database Profile in WHM?

 

Answer

A MySQL Profile (or Database Profile) defines a connection to a locally or remotely hosted MySQL server. Servers with particularly high database usage may consider offloading the database work to a separate server, and the MySQL profile allows you to connect to the remote server. A single profile can be active at a time.

You can create a profile with the following steps:

  1. Log in to WHM as the root user
  2. Navigate to "Home / Database Services / Manage MySQL Profiles"
    On servers version 120 and later, the option is labeled "Manage Database Profiles"
  3. Select the "+ Add Profile" button
  4. Fill in the information required to access the remote MySQL server
  5. Select "Save"
  6. Once the profile has been validated, you can set it to active by selecting the "Activate" button on the main screen.

 

Additional Information

cPanel Docs: Manage MySQL Profiles