MySQL Connection Guide
Data Bridge Pro supports MySQL 5.7+, MariaDB 10.2+, Amazon RDS for MySQL, and Azure Database for MySQL.
Connection Settings
| Setting | Description | Example |
|---|
| Server | Hostname or IP | mysql.company.com |
| Port | Default: 3306 | 3306 |
| Database | Database/schema name | sales_db |
Connection String
Server=myserver;Port=3306;Database=mydb;Uid=myuser;Pwd=****;SslMode=Required;
SSL Configuration
| Mode | Description |
|---|
| None | No SSL (not recommended) |
| Preferred | Use SSL if available (default) |
| Required | Require SSL |
Required Permissions
GRANT SELECT, INSERT, UPDATE, DELETE ON sales_db.* TO 'app_user'@'%';
FLUSH PRIVILEGES;
Troubleshooting
- Access denied: Verify user has access from your IP address
- SSL error: Try SSL Mode = "Preferred" first