Skip to main content
MariaDB

Keyboard users: Escape to exit.

SkySQL Documentation / Connect and Query / Interactive Clients / Navicat

SkySQL Documentation

  • Get Started
  • Features and Concepts

Topics:

  • Service Management
  • Connect and Query
    • Desktop Clients
      • DBeaver
      • dbForge Studio
      • HeidiSQL
      • MariaDB Client
      • MySQL Workbench
      • Navicat
      • SQLyog
      • TablePlus
  • Data Operations
  • Migration
  • Security
  • SQL Reference

Interfaces:

  • SkySQL Portal
  • DBaaS API
  • Billing
  • Configuration Manager
  • Monitoring
  • Support
  • Workload Analysis

Resources:

  • FAQ
  • Glossary
  • MariaDB ID
  • Reference Tables
  • Release Notes
  • Sample Code

Topics on This Page

  • Overview

  • Compatibility

  • Tested Versions

  • Connecting with Navicat

Reader Tools

  • Pages that link here
  • Pages linked from here
  • Send Feedback

Navicat

This page is part of MariaDB's SkySQL Documentation.

The parent of this page is: Interactive Clients

Topics on this page:

  • Overview

  • Compatibility

  • Tested Versions

  • Connecting with Navicat

Overview

Navicat can connect to MariaDB SkySQL services, allowing you to run queries interactively:

  • Navicat is a graphical database tool

  • Navicat is available for Linux, macOS, and Windows

Compatibility

Navicat has been tested by MariaDB to properly connect and execute queries with:

  • Multi-Node Analytics

  • Replicated Transactions

  • Single Node Analytics

  • Single Node Transactions

Tested Versions

These instructions are based on:

  • Navicat version 16.0.6 for macOS

  • Navicat version 16.0.7 for Windows

When using other versions, these instructions may require adjustment.

Connecting with Navicat

To connect to a MariaDB SkySQL service:

  1. Determine the connection parameters for your MariaDB SkySQL service:

  2. Download the certificate authority chain.

  3. Create a new connection.

  4. In the "General" tab:

    • Fill in the connection information for your service.

      • For Host, enter the Fully Qualified Domain Name of your service.

      • For Port, enter the read-write port or read-only port of your service.

      • For User, enter the default username for your service or the username you created.

      • For Password, enter the default password for your default user, the password you set for the default user, or the password for the database user you created.

  5. 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 certificate authority chain (.pem) file.


© 2022 MariaDB. All rights reserved.

Products | Services | Resources

Legal | Privacy Policy | Cookie Policy

| | | Newsletter | About Us | Contact