How to connect to MySQL and MariaDB

MySQL and MariaDB connection strings come in more shapes than any other database: URLs, Go DSNs, .env blocks, raw mysql commands. You do not have to normalize any of them by hand. Paste what you have into Tamery and the form reads it.

The MySQL connection string

Choose MySQL or MariaDB under Engine, or paste a string:

mysql://user:password@localhost:3306/mydb

mariadb://user:password@localhost:3306/mydb

The default port is 3306. A Go DSN like user:pass@tcp(host:3306)/mydb, an .env file, or a mysql command line works too.

SSL and TLS options

Use your provider's string with its SSL options. ssl=true encrypts the connection and verifies the certificate:

mysql://user:[email protected]:3306/mydb?ssl=true

Add sslrejectunauthorized=false to keep encryption but skip the certificate check, or ssl=false to turn it off. With no SSL option set, Tamery tries an encrypted connection without certificate verification and drops to unencrypted only if the server says SSL is unavailable.

Authentication plugin errors

If the connection fails with something about an unsupported authentication plugin, the server is using an auth method the driver cannot speak. Create the user with mysql_native_password, or update the server's auth plugin, and connect again. Tamery tells you this in the error itself, so you are not left guessing.

MariaDB

Everything works the same as MySQL: rows, SQL, schema. System-versioned tables show their current rows, and you query the history with SQL. Sequences are available through SQL rather than the Navigator.

FAQ

What port does MySQL use?

3306 by default, and the same for MariaDB.

How do I fix "authentication plugin cannot be loaded"?

The server is using an auth method the driver cannot speak. Recreate the user with mysql_native_password, or update the server's auth plugin.

Does Tamery support MariaDB?

Yes. Rows, SQL and schema work the same as MySQL, and system-versioned tables show their current rows.

Can I paste a Go DSN or an .env file?

Yes. A DSN like user:pass@tcp(host:3306)/mydb, an .env block, or a mysql command line all parse.

Download Tamery and paste a URL, a DSN or an .env block. The full reference, including the local proxy for localhost on the web, is in the MySQL and MariaDB docs.