MySQL - Summation

Summation connects to MySQL and compatible flavors (MariaDB, RDS for MySQL, Aurora MySQL, Cloud SQL for MySQL) using standard host/port credentials.

What you’ll need

A reachable host and port (default 3306).
A database name.
A user with SELECT on the tables you want exposed. See GRANT Statement in the MySQL docs.

Provider	Where to look
Amazon RDS / Aurora	RDS console → your DB instance → Connectivity & security. See Connecting to a DB instance running MySQL.
Google Cloud SQL for MySQL	Cloud SQL console → your instance → Connections. See About connection options.
Azure Database for MySQL	Azure portal → your server → Overview. See Connect and query.

Field	Required	Stored as	Notes
Host	Yes	Config	DNS name or IP, e.g. `db.example.com`.
Port	Yes	Config	Default `3306`.
Database	Yes	Config	The MySQL database (schema) name.
Username	Yes	Config	MySQL login.
Password	Yes	Secret
SSL Mode	Optional	Config	`disabled`, `preferred`, `required`, `verify_ca`, or `verify_identity`. Default `required`. See `--ssl-mode` in the MySQL docs.
CA Certificate	Optional	Secret	Upload or paste a PEM CA bundle for `verify_ca` / `verify_identity`. See Configuring MySQL to use encrypted connections.
Min Pool Size	Optional	Config	Minimum idle connections. Default `10`.
Max Pool Size	Optional	Config	Maximum concurrent connections. Default `100`.

CREATE USER 'summation'@'%' IDENTIFIED BY '<strong-password>';
GRANT SELECT ON analytics.* TO 'summation'@'%';
FLUSH PRIVILEGES;

To force TLS on the user:

ALTER USER 'summation'@'%' REQUIRE SSL;

See CREATE USER Statement for more options.

Source references use the form:

mysql:my_database.my_table

Error or symptom	Likely cause
`Access denied for user`	Wrong user, password, or host pattern. Check `'summation'@'%'` vs `'summation'@'10.%'`.
`SSL connection error`	SSL Mode doesn’t match the server. Most managed providers reject `disabled`.
Too many connections	Lower Max Pool Size if the server’s `max_connections` is low.