Connect to MySQL databases to query and analyze your relational data. Supports tables with spatial columns for geographic analysis.
Connect to MySQL
- Click Add data in the Layers panel
- Go to the Connections tab
- Select MySQL
- Fill in the connection parameters
- Click Create Connection
Connection Parameters
| Parameter | Required | Description |
|---|---|---|
| Connection Name | Yes | A friendly name to identify this connection |
| Host | Yes | Hostname or IP address (e.g., localhost, db.example.com) |
| Port | Yes | Port number (default: 3306) |
| Database | Yes | Database name to connect to |
| Username | Yes | Database username |
| Password | Yes | Database password |
SSL/TLS Configuration
Enable SSL/TLS for encrypted connections to your database. When enabled, you can optionally upload:
- Client Certificate: PEM or CRT format
- Private Key: PEM or KEY format
- CA Certificate: For server verification
Working with Data
After connecting, browse available tables. Select the data you want to import and click Add to Project. Tables with MySQL spatial columns (POINT, LINESTRING, POLYGON, GEOMETRY) import as vector layers.
Firewall Configuration
If your database is behind a firewall, whitelist these Atlas IP addresses:
16.16.129.130
51.20.23.178
13.50.71.210
51.21.188.73
Troubleshooting
| Issue | Solution |
|---|---|
| Connection Refused | Verify host and port. Check MySQL allows remote connections in my.cnf. |
| Authentication Failed | Confirm credentials. Check user has access from your IP address. |
| Database Not Found | Database names are case-sensitive on Linux servers. |
| Access Denied | User needs SELECT privileges on target tables. Grant with GRANT SELECT ON. |
| SSL Connection Error | Verify certificate files are valid PEM format and not expired. |