Connection Overview
This page describes connecting to a MariaDB Cloud database using the following options:
MariaDB-compatible client
From your application
Through SQL tools
GUI Clients
Whitelist IP Address Access to all services is by default protected by a firewall. You need to whitelist your client’s (your desktop, laptop or server) IP address before connecting. Select ‘Manage —> Security Access’ and then click ‘Add my current IP’ to add the IP of your current workstation (laptop, desktop).
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)
Unlike previous MariaDB Cloud versions, the current version no longer requires clients to supply the Server SSL Certificate for SSL connections. Customers who migrated from MariaDB corporation to MariaDB Cloud Inc can continue to use provided certificates (when using the previous MariaDB Cloud method for connecting). But we strongly recommend moving to the connection properties as shown in the Connect window for your service.
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.
For Server with Replicas, you can also use any MongoDB client and use the NoSQL Interface.
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?