Navicat is a graphical application which can interact with MariaDB Servers, including MariaDB database services on MariaDB SkySQL.
Navicat is a third-party product. Additional information on Navicat is available from PremiumSoft CyberTech Ltd.
Navicat can be used with:
MariaDB Platform for Transactions
MariaDB Platform for Analytics
MariaDB Platform for Smart Transactions (HTAP)
MariaDB Platform for Distributed SQL
Connecting with Navicat
Navicat version 15.0.18 (Windows) and 15.0.22 (macOS) were used to prepare these instructions. When using other versions, these instructions may require adjustment.
To connect to a database service on MariaDB SkySQL through Navicat:
Determine the connection information for your MariaDB SkySQL database service:
Where to find itGeneral tabHost
Fully Qualified Domain Name in the Service Details viewGeneral tabPort
Read-Write Port or Read-Only Port in the Service Details viewGeneral tabUser
Default username in the Service Credentials view, or the username you createdGeneral tabPassword
Default password in the Service Credentials view, the password you set on the default user, or the password for the user you createdSSL tabCA Certificate
Path to the
skysql_chain.pemfile containing the "Certificate Authority Chain" (Download)
Create a new connection.
In the "General" tab:
Fill in the connection information for your service.
Remember to specify the port, as MariaDB SkySQL does not use the standard client port.
In the "SSL" tab:
Select the "Use SSL" checkbox.
Select the "Use authentication" checkbox.
In the "CA Certificate" text box, enter the path to the downloaded