Connecting to MariaDB Cloud Databases
This page describes how to connect to a MariaDB Cloud database using a MariaDB-compatible client.
Warning: Using 0.0.0.0/0
will disable the firewall. Never do this for production databases.
For more details, go to the Firewall settings page.
Connecting Using the MariaDB Client
Once your DB service is launched, click on the ‘Connect’ option for your service on the dashboard. This pops up all the required attributes to connect from any SQL client.
Connection parameters include:
Default username
Default password
Hostname (Fully Qualified Domain Name)
TCP port (3306 or 3307)
ssl-verify-server-cert (if SSL is ON)
There is a default config change in the 11.4.2 MariaDB client that requires SSL. This needs to be disabled by setting --ssl-verify-server-cert=0
.

Install and Connect Using the MariaDB Client
After installing the MariaDB client according to your operating system, copy and paste the MariaDB command as displayed in the Connect window.
Connecting From Your Application
Applications can connect to MariaDB Cloud using any of the below MariaDB supported connectors. There are several other connectors from the community too.
Connecting From SQL Tools
Clients listed here have been tested to properly connect with MariaDB Cloud and execute queries.
Most of the SQL clients and editors natively support MariaDB. Most often you can also just select 'MySQL' and connect to your MariaDB Cloud DB service.
Connecting using Java clients like Squirrel SQL
All you need to do is to make sure the "useSsl" property is set to 'true' if SSL is ON.
MariaDB CLI
Sequel Ace - Connect to MariaDB from MacOS
In the connection window, you should select 'Require SSL' if your MariaDB Cloud database has SSL turned ON (the default).
Graphical User Interfaces (GUIs)
The following GUI clients have been tested to properly connect with MariaDB Cloud and execute queries. Most SQL clients and editors natively support MariaDB. You can often select 'MySQL' as the connection type to connect to your MariaDB Cloud DB service.
Connect using DBeaver (CloudDBA recommended)
Last updated
Was this helpful?