How to manage remote MySQL connections on Hostinger

intermediate 8 min read Updated 2026-03-30

Quick Answer

To manage remote MySQL connections on Hostinger, you need to enable remote access through the hPanel control panel, configure allowed IP addresses, and update your database connection settings. This allows external applications to connect to your MySQL database hosted on Hostinger servers.

Full Hostinger Review

Prerequisites

Active Hostinger hosting account
MySQL database already created
Basic understanding of database connections
Your server's IP address or domain

Step-by-Step Instructions

Access MySQL Databases in hPanel

Log into your Hostinger hPanel and navigate to Websites section. Select your domain and click on MySQL Databases from the left sidebar menu. This will display all your existing databases and management options.

Make sure you're accessing the correct hosting account if you have multiple domains

Locate Your Target Database

Find the database you want to enable remote access for in the databases list. Click on the Manage button next to your database name. This opens the database management interface where you can configure connection settings.

Note down your database name, username, and password as you'll need these for remote connections

Enable Remote MySQL Access

In the database management panel, look for Remote MySQL or Remote Access section. Click on Enable Remote Access button to activate the feature. You'll see a confirmation message once remote access is successfully enabled for your database.

Remote MySQL access may not be available on all Hostinger plans - check your plan features

Configure Allowed IP Addresses

In the Remote MySQL Access section, you'll see an input field for IP addresses. Enter the IP address or domain from which you want to allow connections, or use % to allow all IPs (not recommended for security). Click Add to save the IP configuration.

For security, always specify exact IP addresses rather than using wildcards

Note Remote Connection Details

Copy the remote MySQL connection details displayed in the panel. This typically includes the Remote MySQL hostname (usually different from localhost), port number (default 3306), your database name, username, and password. Save these details securely for your applications.

The remote hostname is often different from your website domain - use the exact hostname provided

Test the Remote Connection

Use a MySQL client like MySQL Workbench, phpMyAdmin, or command line to test the connection. Enter the remote hostname, port, username, password, and database name you noted earlier. Execute a simple query like SELECT 1 to verify the connection works properly.

Test connections from your specific IP address to ensure the whitelist configuration is working

Update Application Configuration

Modify your application's database configuration file to use the remote MySQL connection details. Replace localhost with the remote hostname, ensure the correct port is specified, and update any connection strings. Deploy and test your application to confirm remote database connectivity.

Keep a backup of your original configuration before making changes

Monitor and Manage Access

Regularly review your remote access settings in hPanel. You can add or remove IP addresses, disable remote access temporarily, or check connection logs if available. Update IP addresses when your server locations change to maintain secure access.

Set up monitoring alerts for database connections to detect any unauthorized access attempts

Common Issues & Troubleshooting

Connection refused or timeout errors

Verify that your IP address is correctly added to the allowed list in hPanel. Check if your firewall or network is blocking outbound connections on port 3306. Confirm you're using the correct remote hostname, not localhost or your domain name.

Access denied for user error

Double-check your database username and password in hPanel. Ensure you're using the correct database user that has remote access privileges. Try recreating the database user if the credentials appear correct but still fail.

Remote MySQL option not available

Remote MySQL access is not available on all Hostinger plans. Upgrade to a Business or higher plan that supports remote database connections. Contact Hostinger support to confirm your plan includes remote MySQL access.

Can connect but cannot see tables or data

Check database user permissions in hPanel. Ensure the user has appropriate privileges (SELECT, INSERT, UPDATE, DELETE) for the database. Verify you're connecting to the correct database name and that tables exist in that specific database.

Prices mentioned in this guide are pulled from current plan data and may change. Always verify on the official Hostinger website before purchasing.

Visit Hostinger View Hostinger Pricing

Related to Hostinger

ReviewHostinger Review PricingHostinger Pricing AlternativesHostinger Alternatives