Intermediate
How to manage remote MySQL connections on Hostinger
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.
Prerequisites
- Active Hostinger hosting account
- MySQL database already created
- Basic understanding of database connections
- Your server's IP address or domain
1
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.
Tip
Make sure you're accessing the correct hosting account if you have multiple domains
2
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.
Tip
Note down your database name, username, and password as you'll need these for remote connections
3
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.
Tip
Remote MySQL access may not be available on all Hostinger plans - check your plan features
4
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.Tip
For security, always specify exact IP addresses rather than using wildcards
5
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.
Tip
The remote hostname is often different from your website domain - use the exact hostname provided
6
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.Tip
Test connections from your specific IP address to ensure the whitelist configuration is working
7
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.
Tip
Keep a backup of your original configuration before making changes
8
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.
Tip
Set up monitoring alerts for database connections to detect any unauthorized access attempts
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.
Ready to get started with Hostinger?
Put this tutorial into practice. Visit Hostinger and follow the steps above.
Visit Hostinger →