Connect to MySQL

Configure MySQL or MariaDB URLs, TLS certificates, SSH tunnels, timeouts and session read-only settings.

The connection form is titled MySQL / MariaDB connection. It accepts either a provider URL or the fields needed to open a MySQL or MariaDB session.

URL and database

  1. Paste a mysql:// or mariadb:// URL into paste connection URL.
  2. Choose apply to copy the host, credentials and database into the form.
  3. Review the database opened by default. The sidebar still lists all the databases your user can reach.
  4. Run test connection before saving.

The URL parser decodes percent-encoded passwords. It also reports URL parameters that it did not apply, instead of silently pretending that all provider-specific settings were understood.

TLS

The TLS mode choices are:

  • verify CA and server name
  • verify CA
  • require TLS (no verification)
  • no TLS

A new connection to a host outside this computer starts in verify CA and server name. With an empty CA certificate (PEM), verify CA and server name trusts the system roots (the operating system’s certificate store; the public Mozilla roots only when that store is empty or unreadable; plus the CA from Settings › Network); a pasted CA replaces all of them. verify CA requires a pasted CA (against public roots it would accept any public certificate). Through an SSH tunnel the certificate is checked against the host you typed, not the tunnel address.

The form accepts CA certificate (PEM), client certificate (PEM) and client private key (PEM). The private key is stored in the system keychain, not in the connections file. timeout (s) applies to the first connection opened by the test and sidebar; later pool connections do not inherit that limit.

SSH and connection metadata

MySQL uses the shared SSH section with SSH host, SSH port, SSH user, authentication, SSH password, private key path, key passphrase and optional jump host / bastion. Blank fields fall back to ~/.ssh/config.

The shared metadata includes environment, color, folder, read-only and safe mode. Use production for a production connection so it remains visually distinct.

Use Ctrl+S for pending grid changes. The URL is an import aid; it does not replace reviewing the connection settings before saving.