Prerequisites
Connect MariaDB Cloud to VexiData
Get your connection details
- Log in to the SkySQL Dashboard
- Click on your database service
- Click the Connect button to view connection details
| Parameter | Example |
|---|---|
| Host | dbpwfXXXXXXXX.sysp0000.db1.skysql.com |
| Port | 3306 |
| Username | Your service username |
| Password | Your service password |
| Database | Your database name |
Allow VexiData through the firewall
SkySQL blocks all external connections by default. You must add VexiData’s IP addresses.
- In the SkySQL Dashboard, go to Manage > Security Access
- Add each of VexiData’s IPs:
| IP address |
|---|
139.59.53.167 |
165.22.217.42 |
- Save the changes
Security Access configuration is mandatory. Your connection will fail without this step.
Add the connection in VexiData
- Go to Data Sources in VexiData
- Click MariaDB to open the connection form
- Fill in the details:
| Field | Value |
|---|---|
| Display Name | A name to identify this connection (e.g., “MariaDB Cloud Production”) |
| Host | Your SkySQL hostname (e.g., dbpwfXXXXXXXX.sysp0000.db1.skysql.com) |
| Port | 3306 |
| Database | Your database name |
| Username | Your service username |
| Password | Your service password |
SSL is enabled by default on MariaDB Cloud. VexiData handles this automatically — no additional configuration is needed.
Troubleshooting
Connection timed out
Connection timed out
- Verify VexiData’s IPs are added in Manage > Security Access. All connections are blocked by default
- Check that your database service is running in the SkySQL Dashboard
Authentication failed
Authentication failed
- Get fresh credentials by clicking the Connect button on your service in the SkySQL Dashboard
- Verify you’re using the correct database name
SSL connection errors
SSL connection errors
- VexiData handles SSL automatically. If you see SSL errors, verify the hostname and port are correct
- Check that your service is running and not in a maintenance state