Connect Your Remote Database to WPCloud MySQL
Overview
This guide explains how to securely connect your remote database to WPCloud’s hosted MySQL servers. For security purposes, we implement IP whitelisting to protect your database access.
Prerequisites
- Access credentials for your remote database
- WPCloud hosted database credentials
- Your connection’s public IP address
- A database management tool (e.g., MySQL Workbench, HeidiSQL)
IP Whitelisting Process
- Identify Your IP Address
- Visit an IP lookup tool (e.g., whatismyip.com)
- Note your public IP address
- Submit IP for Whitelisting
Contact our support team via one of the following:- Create a ticket in the WPCloud Support Portal
- Email support@wpcloud.ca
- Your account details
- The IP address(es) to whitelist
- Purpose of the connection
Connection Setup
- Gather Database Credentials
- Host: [your-provided-hostname]
- Port: 3306 (default MySQL port)
- Database: [your-database-name]
- Username: [your-username]
- Password: [your-password]
- Configure Database Client
MySQL Workbench:- Click New Connection
- Enter the connection details above
- Click Test Connection and save
- Click New
- Choose MySQL (TCP/IP)
- Enter the connection details above
- Click Open (or Save then Open) to test
Security Best Practices
- Use strong, unique passwords
- Connect only from secure networks (avoid public Wi-Fi)
- Keep your database client tools updated
- Review your IP whitelist regularly and remove old entries
Troubleshooting Guide
- Connection Timeout → Verify IP whitelisting status with support
- Access Denied → Double-check username/password and database name
- Cannot Resolve Host → Confirm the hostname is correct
- SSL/TLS Errors → Update your database client and retry
FAQ
- Can I whitelist multiple IPs? Yes—include all required IPs in your request.
- What if my IP changes? Contact support immediately to update the whitelist.
- Is SSL/TLS required? Yes—all connections require SSL/TLS encryption.
Support Options
Need assistance? We’re here to help.
- Support Portal: support.wpcloud.ca
- Email: support@wpcloud.ca
- Typical response time: within 15 minutes