MySQL
Read and write MySQL or MariaDB: self-hosted, or managed on Amazon RDS and Aurora, Cloud SQL, or Azure Database. Browse to a table or write your own SQL; the builder shows a query's columns without running it.
Settings
What the connection form asks for. Every connection has a Staging side, which it needs, and an optional Production side with values of its own; both ask for the same settings.
| Host | |
| Port | |
| Database | |
| Username | |
| Password | Stored encrypted, and never shown again after you save it. |
| Encryption | Managed services (Amazon RDS and Aurora, Cloud SQL, Azure Database) accept verify-full with no extra setup. Use require for a server with a self-signed certificate. Choices: Require encryption; Require encryption, verify certificate and hostname; Require encryption, verify certificate; Encrypt if the server offers it; No encryption. |
Testing the connection
Test connects to the server, signs in and runs SELECT 1.
Good to know
- Works with MySQL and MariaDB, self-hosted or managed.
- Encryption has five settings, from no encryption to verifying the certificate and the hostname.
- A query's columns show in the builder without running it.
Nodes that use it
Look up each row's keys in a database table and add the matching row's columns.
Read a table or SQL query from a MySQL database. A Bookmark can read only the rows added or changed since the last successful run.
Load rows into a MySQL table. Turn on All or nothing and a load that fails leaves the table as it was.