MySQL
Connect a MySQL database with the MySQL database type. Managed MySQL connects the same way: Amazon RDS and Aurora MySQL, Google Cloud SQL and Azure Database for MySQL. MariaDB, TiDB and OceanBase have their own database types; see Supported databases.
Connect a database
Add the database as in Connect a database, with these values:
| Field | Value |
|---|---|
| Database type | MySQL |
| Port | 3306, MySQL's default, or the port your service shows. |
| Database name | The schema to query. MySQL calls a database a schema. |
For the credential, create a read-only user. To keep QueryDesk's queries off your primary, connect a read replica.
Connection strings
Paste a mysql:// connection string under Update with connection string on the database's settings page and click Apply. An ssl-mode key (also spelled ssl_mode or sslMode) of REQUIRED, VERIFY_CA or VERIFY_IDENTITY turns on Encryption.
AI read-only
With Read only set, an AI query runs in a read-only transaction that is always rolled back, so MySQL refuses a write the parser didn't catch. See AI governance.