Prerequisites
- A MySQL server reachable from the internet.
- A database user with read access to the schemas and tables you want to query.
Required fields
| Field | Description | Example |
|---|---|---|
| Name | A display name for this datasource in Mora. | Graphics Press warehouse |
| Host | The hostname or IP address of your MySQL server. | localhost |
| Port | The port MySQL is listening on. | 3306 |
| Database | The name of the database to connect to. | my_database |
| User | The database user. | admin |
| Password | The user’s password. |
Optional fields
| Field | Description |
|---|---|
| SSL | Enable SSL for encrypted connections. |
Steps
- Open Settings → Datasources → New.
- Enter a name and select MySQL as the type.
- Fill in the fields above.
- Click Test connection to verify.
- Click Create.
Troubleshooting
- Connection refused — Confirm the host and port. Check that your MySQL server’s
bind-addressallows remote connections. - Access denied — Verify the user and password, and ensure the user has
SELECTprivileges on the target database.