Skip to main content

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

  1. Open Settings → Datasources → New.
  2. Enter a name and select MySQL as the type.
  3. Fill in the fields above.
  4. Click Test connection to verify.
  5. Click Create.

Troubleshooting

  • Connection refused: Confirm the host and port. Check that your MySQL server’s bind-address allows remote connections.
  • Access denied: Verify the user and password, and ensure the user has SELECT privileges on the target database.