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
Optional fields
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.
