Setting Up a Remote MySQL Database

Remotely connecting to a MySQL database gives you seamless access to databases hosted on your account from external servers. How to do it? Well, your Account Manager streamlines the process by enabling secure and efficient remote database connections. Whether you need to grant other servers access to your MySQL databases or manage connections with ease, it offers the necessary tools to get the job done. Let's get started!

• Remote MySQL Database Connection in Account Manager
• How to Remove or Edit Remote Access Host
• Summary

Remote MySQL Database Connection in Account Manager

To enable remote MySQL connection, the connecting computer must be added as an Access Host. Follow these steps:

1. Log in to your Bluehost Account Manager.
2. Click Websites on the left side of the navigation menu.
   
3. If you manage multiple hosting accounts, select the Hosting tab.
   

   Locate the hosting package you need to manage and click its MANAGE button.

   
4. On the website management page, locate the website you need to manage and click its SETTINGS button.
   
5. In the Advanced tab, locate the Databases tile and click Manage.
   
6. Under Database Management, click the REMOTE tab.
   
7. In the Remote MySQL Access section, click ADD HOST.
   
8. Type the connecting IP address under the Enter IP field. You can also add a description (optional) and click ALLOW ACCESS.
   

   That's it! You should now be able to remotely connect to your database. Here’s an example below:

   

   In the next section, let's take a look at how to remove access for a remote access host in Account Manager.

How to 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. To edit, locate the Host/IP address you want to modify and click the ellipsis icon.
   
2. Click Edit Host.
   
3. Once you're done editing, click SAVE.
   

To Remove:

1. To remove, locate the Host/IP address you want to modify and click the ellipsis icon.
   
2. Click Delete Host.
   
3. To confirm, click the DELETE button.
   

Summary

To enable seamless access to your MySQL databases, you can configure a remote database connection through your Account Manager. This guide provides all the essential configuration settings you'll need, along with helpful troubleshooting tips for any common connection issues, available in the linked articles.