How to Set Up a Remote MySQL Database Connection

Remotely connecting to a MySQL database allows you to access and manage your databases from external servers or local machines. This is especially useful for developers, administrators, or applications that require off-site database access.

Your Account Manager simplifies this process by providing a secure and user-friendly interface to configure remote MySQL access.

• Remote MySQL Database Connection
• Remove or Edit Remote Access Host
• Summary

Remote MySQL Database Connection

To enable remote MySQL access, you must add the connecting computer’s IP address as an Access Host. Here's how:

1. Log in to the Bluehost Account Manager.
2. Click Websites in the left menu.

   
    

   • If you have only one website, you will be redirected straight to its Overview panel.
   • If you have multiple websites, all of them will be listed. Click on Settings to access the website's Overview panel.

     
      

3. In the Overview page, click Databases to open the Database Management panel.

   
    

4. Under Database Management, go to the REMOTE tab.

   
    

5. In the Remote MySQL Access section, click ADD HOST.

   
    

6. Enter the IP address in the Enter IP field. Optionally, add a description.
7. Click ALLOW ACCESS.

   
    

Once completed, your remote connection should be active.

Remove or Edit a Remote Access Host

To remove or edit a host from accessing databases on your server in Account Manager, follow these steps:

To Edit:

1. Locate the Host/IP address.
2. Click the ellipsis icon (⋮).

   
    

3. Select Edit Host.

   
    

4. Make changes and click SAVE.

   
    

To Remove:

1. Locate the Host/IP address.
2. Click the ellipsis icon (⋮).

   
    

3. Select Delete Host.

   
    

4. Confirm by clicking DELETE.

   
    

Summary

Setting up a Remote MySQL Database Connection through your Account Manager ensures secure and efficient access to your databases from external sources. Whether you're adding a new access host, editing an existing one, or managing dynamic IPs, this guide provides all the essential steps to keep your remote connections running smoothly.