Portal Home > Knowledgebase > WHM > How to set your WHM server to use a remote MySQL server


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. 


Was this answer helpful?

Add to Favourites Add to Favourites    Print this Article Print this Article

Also Read

* Minimum sign up periods for cPanel Web Hosting plans: Mini - 3mo., Pro - 1mo., Biz - 1mo., cPanel Reseller Hosting, Linux VPS, Windows VPS, Managed cPanel VPS and Dedicated Servers - 1mo. secret link
Accepted payments: Credit/Debit Card, Paypal, Payza, Skrill, WebMoney, CashU, Ukash, paysafecard, Bitcoin, Perfect Money, SolidTrust Pay, OKPay, EgoPay, Western Union/MG, Wire Transfer and more.