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:

FieldValue
Database typeMySQL
Port3306, MySQL's default, or the port your service shows.
Database nameThe 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.

Was this page helpful?