Skip to main content
MySQL and MariaDB load the same bundled driver, so MySQL carries the setup. Port 3306, an optional Database field, Cmd+K to change database in place, SSL/TLS starting on Preferred, AWS IAM and SSH tunnels. MariaDB 10.x and later are supported. The rest of this page is what differs.

​
Connection URL

Both schemes open a connection; mariadb:// creates a MariaDB connection, mysql:// a MySQL one:
See Connection URL Reference.

​
Differences from MySQL

  • The default authentication plugin is mysql_native_password, against caching_sha2_password on MySQL 8. Both connect.
  • MariaDB stores JSON in a LONGTEXT column. The driver reads MariaDB’s extended field attributes and types those columns as JSON, so their values open in the JSON editor instead of as plain text.
  • Virtual and persistent columns are detected on every version, including the bare VIRTUAL and PERSISTENT spelling that 10.1 and older report, and are left out of generated INSERT and UPDATE statements.
  • A query timeout goes in as SET SESSION max_statement_time, counted in seconds. MySQL takes max_execution_time in milliseconds.
  • 10.2.1 to 10.2.21 and 10.3.0 to 10.3.9 enforce check constraints without publishing an information_schema.CHECK_CONSTRAINTS to read them from. The Constraints tab takes them out of SHOW CREATE TABLE on those releases and out of the catalog everywhere else.
  • Sequences appear in the sidebar’s Tables section as their own kind, read-only, with Drop Sequence on the menu. See Sequences and system-versioned tables.
  • A table declared WITH SYSTEM VERSIONING is listed as an ordinary table and loses Truncate alone, which the server refuses with error 4137.
  • A temporary table shadowing a base table of the same name is left out of the listing, so the name appears once.
JSON cell editor popoverJSON cell editor popover

A JSON value open in the JSON editor

​
Limitations

  • Cloud SQL Auth Proxy is not offered for MariaDB. That pane appears for MySQL, PostgreSQL and SQL Server only. Reach a server that is not directly routable through an SSH tunnel.
  • Users & Roles reads mysql.user and reports every row there as a user, never as a role. Create and grant MariaDB roles with SQL in the editor.