How to set your WHM server to use a remote MySQL server

How to set your WHM server to use a remote MySQL server?

 If your users will be running database-heavy applications, or if you have many servers, perhaps you’d like to consolidate your MySQL databases all onto one server. In order to do that you will need to instruct cPanel/WHM to use a remote MySQL server.

  1. Go to the SQL Services menu.
  2. Proceed to Setup Remote MySQL server.
  3. Let’s change that Start with the server’s hostname or IP.
  4. Ensure that the remote SSH port is correct.
  5. Scroll down. You will find Authenticaton information. Click the button next to Root.
  6. Change authentication method to Password. Enter the Root Password for the server. When finished here, click Setup.
  7. Return to the page setup, enter localhost for the server address.
  8. Skip all the rest of the settings and click Setup. 
  • 58 Users Found This Useful
Was this answer helpful?

Related Articles

How to create a new cPanel account in WHM

How to create a new cPanel account in WHM? To create a new cPanel account in WHM here below are...

How to access cPanel accounts through WHM

How to access cPanel accounts through WHM? In order to access cPanel accounts through WHM, here...

How to change an accounts password in WHM

How to change an account's password in WHM? In order to modify an account password in WHM, you...

How to change an accounts disk quota in WHM

How to change an account's disk quota in WHM? Remember that some webhosts want their clients to...

How to see a list of all the accounts over their disk quotas in WHM

How to see a list of all the accounts over their disk quotas in WHM? Occasionally, some of the...