MariaDB

MariaDB is a network SQL engine that speaks the MySQL wire protocol, so TableR connects to it exactly like MySQL. Point TableR at an existing server by filling the connection form, or let TableR start a local MariaDB for you with the built-in bootstrap when you do not have a server yet.

Overview

Because MariaDB uses the MySQL wire protocol, the same connection fields and connection strings as MySQL apply. It works with a local install, a container, a managed service (SkySQL, Amazon RDS, and similar), or a bootstrapped local server.

• Local development — connect to 127.0.0.1:3306, or bootstrap a local server.
• Remote / managed — use the provider endpoint and enable SSL/TLS.
• MySQL-compatible — fields, connection strings, and behaviour match MySQL; see the MySQL guide for anything not covered here.

Before you start

• A reachable MariaDB server (host and port), or use Local bootstrap instead.
• A database user name — this is required.
• The user's password, if the server requires one.
• Optionally, the specific database (schema) to open on connect.
• For remote servers: network access to the port and, usually, SSL/TLS enabled.

Connection fields

These defaults match TableR's MariaDB connection form, which is identical to MySQL. Secrets are written to the operating system keyring, never to plain configuration files.

Connect with the form

1. 1
   Choose MariaDB

   Open the launcher and pick the MariaDB card.

2. 2
   Enter host and port

   Use 127.0.0.1 and 3306 for a local server, or your provider's endpoint for a remote one.

3. 3
   Add credentials

   Type the username, and the password if required. The password is saved to the OS keyring.

4. 4
   Pick a database (optional)

   Set a database to open it directly, or leave it blank and choose one after connecting.

5. 5
   Enable SSL/TLS for remote

   Turn on SSL/TLS when connecting to a remote or managed server.

6. 6
   Save and connect

   Save the profile so it reappears in the launcher, then connect.

Use a connection string

MariaDB uses MySQL's connection URI format, so you can paste a MySQL-style connection string.

mysql://username:password@host:3306/database?ssl-mode=REQUIRED

• Omit the password from the URI and let TableR store it in the keyring instead.
• Append ssl-mode=REQUIRED (or VERIFY_IDENTITY) for remote servers.
• URL-encode special characters in the password (for example @ becomes %40).

Local bootstrap

If you do not have a server, TableR can start a local MariaDB for you — no separate install required.

1. 1
   Select MariaDB

   Pick MariaDB in the launcher.

2. 2
   Choose Local bootstrap

   TableR provisions and starts a local server on your machine.

3. 3
   Start querying

   A connection is created for you; open a SQL tab and run a query.

SSL/TLS

Local servers on 127.0.0.1 usually need no encryption. For anything over a network, enable SSL/TLS. If you connect with a URI, control the behaviour with the ssl-mode parameter.

• DISABLED — no encryption (local only).
• REQUIRED — encrypt, but do not verify the server certificate.
• VERIFY_CA / VERIFY_IDENTITY — encrypt and verify the certificate (most secure).

Verify the connection

Once connected, open a SQL tab and run a quick check:

SELECT VERSION();
SELECT DATABASE(), CURRENT_USER();

If both statements return rows, the connection and credentials are working.

Troubleshooting

Next steps