MySQL Workbench

Overview

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

  • MySQL Workbench is a graphical database tool

  • MySQL Workbench is available for Linux, macOS, and Windows

Compatibility

MySQL Workbench 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:

  • MySQL Workbench version 8.0.27 for macOS

  • MySQL Workbench version 8.0.27 for Windows

When using other versions, these instructions may require adjustment.

Connecting with MySQL Workbench

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 "Parameters" 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:

    • In the "Use SSL" dropdown list, select "Require".

    • In the "SSL CA File" text box, enter the path to the certificate authority chain (.pem) file.

Note

MySQL Workbench raises a warning when connecting to MariaDB Enterprise, given that it is not connecting to MySQL Server. Click "Don't show this message again" and "Continue Anyway" to accept the connection.