How to Connect Your Remote Database to WPCloud MySQL
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 IP address
- A database management tool (MySQL Workbench, HeidiSQL, or similar)
IP Whitelisting Process
- Identify Your IP Address
- Visit whatismyip.com
- Note your public IP address
ย
- Submit IP for Whitelisting Contact our support team through either method:
- Create a ticket: WPCloud Support Portal
- Email: support@wpcloud.ca
- Your account details
- The IP address(es) to whitelist
- Purpose of the connection
Include:
Note: IP whitelisting is typically processed within 1 hour
Connection Setup
- Gather Database Credentials Required information:
Host: [your-provided-hostname]
Port: 3306 (default MySQL port)
Database: [your-database-name]
Username: [your-username]
Password: [your-password]
ย
- Configure Database Client
- Click "New Connection"
- Enter connection details
- Test connection
- Click "New"
- Select "MySQL (TCP/IP)"
- Enter connection details
- Test connection
Steps for MySQL Workbench:
Steps for HeidiSQL:
ย
Security Best Practices
- Use strong passwords
- Connect only from secure networks
- Maintain updated database management tools
- Regularly review IP whitelist requirements
Troubleshooting Guide
Issue | Solution |
Connection Timeout | Verify IP whitelisting status |
Access Denied | Double-check credentials |
Cannot Resolve Host | Confirm hostname accuracy |
SSL/TLS Errors | Update database client |
FAQ
Q: Can I whitelist multiple IPs? A: Yes, provide all required IPs in your support request.
Q: What if my IP changes? A: Contact support immediately for whitelist updates.
Q: Is SSL/TLS required? A: Yes, all connections require SSL/TLS encryption.
Support Options
Need assistance? Contact us:
- Support Portal: support.wpcloud.ca
- Email: support@wpcloud.ca
- Response Time: Usually within 15 minutes
Did this answer your question?
๐
๐
๐คฉ
Last updated on November 19, 2024