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 for configuring a remote MySQL database connection.

• Remote MySQL Database Connection
• Edit or Remove a 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. Follow the steps below:

1. Log in to your Bluehost Account Manager.
2. In the left-hand menu, click Websites.
3. Click the Manage button located next to the website you want to manage.

   
    

4. On the Overview page, click Databases to open the Database Management panel.

   
    

5. Under Database Management, navigate to the REMOTE tab.

   
    

6. In the Remote MySQL Access section, click Add Host.

   
    

7. Enter the IP in the Enter IP field.
   (Optional) Add a description to help identify the host.
8. Click Allow Access.

   
    

Once completed, remote access to your MySQL database should be active.

Edit or Remove a Remote Access Host

You can edit or remove existing hosts directly from the Account Manager.

Edit a Host

1. Locate the Host/IP Address you want to modify.
2. Click the vertical ellipsis icon (⋮) and select Edit Host.

   
    

3. Make the necessary changes and click Save.

   
    

Remove a Host

1. Locate the Host/IP Address you want to delete.
2. Click the vertical ellipsis icon (⋮) and select Delete Host.

   
    

3. 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 are adding a new access host, editing an existing one, or managing dynamic IP addresses, this guide provides the essential steps to keep your remote connections running smoothly.