Allow Remote MySQL Connections in WHM

By default, remote connections to MySQL are disabled in WHM. If you would like to allow a remote IP to connect to your MySQL instance, let's say for backup or to access your database from your local machine, you could do the following.

Enabling Remote MySQL in the WHM panel

  1. Log in to your server’s WHM panel
  2. Find the left-side navigation bar labeled SQL Services, or type ‘mysql’ in the search box as shown below.
  3. Click Additional MySQL Access Hosts

WHM Control Panel

  1. On the following page, enter the IP address you would like to whitelist in the text box as shown
  2. Click the Save button

Allow Remote MySQL Connections in WHM

Back to blog

Ready to automate your backups?

Sign up for FREE. Get started in less than one minute.

Secure your backups

No credit card required. Free 14-day trial.