Portal Home > Knowledgebase > WHM > How to add MySQL access hosts in WHM


How to add MySQL access hosts in WHM




How to add MySQL access hosts in WHM?

When generating a MySQL user access to a database, you have to specify which hosts are allowed to log in as that user. The MySQL Access Hosts tool in WHM allows you to specify certain hostnames and IP addresses that should automatically be added to every user of every database on your server.

  1. Find the SQL Services category.
  2. Go to Additional MySQL Access Hosts. Enter as many additional hosts in the box as you want, one per line.
  3. Finish by clicking Save.
  4. Return to Additional MySQL Access Hosts. Find Click here link and hit it. That’s it! All accounts on the server  have been updated to use the new hosts.

 



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.