Allow Remote MySQL Connections in WHM

SimpleBackups founder

Laurent Lemaire

Co-founder, SimpleBackups

Last update on November 15, 2023
Originally posted on June 10, 2020

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

  • Log in to your server’s WHM panel

  • Find the left-side navigation bar labeled SQL Services, or type ‘mysql’ in the search box as shown below.

  • Click Additional MySQL Access Hosts

WHM Control Panel

On the following page, enter the IP address you would like to whitelist in the text box as shown.

  • Click the Save button

Allow Remote MySQL Connections in WHM

Back to blog

Stop worrying about your backups.
Focus on building amazing things!

Free 7-day trial. No credit card required.

Have a question? Need help getting started?
Get in touch via chat or at [email protected]

Customer support with experts
Security & compliance
Service that you'll love using