MySQL Workbench is a graphical application which can interact with MariaDB Servers, including MariaDB database services on MariaDB SkySQL.
MySQL Workbench is a third-party product. Additional information on MySQL Workbench is available from Oracle Corporation.
MySQL Workbench 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 MySQL Workbench
MySQL Workbench version 8.0.22 (Windows) and 8.0.21 (macOS) were used to prepare these instructions. When using other versions, these instructions may require adjustment.
Older version MySQL Workbench version 8.0.20 is not compatible with MariaDB Platform for Distributed SQL service (Distributed Transactions topology). Users attempting to connect with this client will receive a "Lost connection" error.
To connect to a database service on MariaDB SkySQL through MySQL Workbench:
Determine the connection information for your MariaDB SkySQL database service:
Where to find itParameters tabHost
Fully Qualified Domain Name in the Service Details viewParameters tabPort
Read-Write Port or Read-Only Port in the Service Details viewParameters tabUser
Default username in the Service Credentials view, or the username you createdParameters tabPassword
Default password in the Service Credentials view, the password you set on the default user, or the password for the user you createdSSL tabSSL CA File
Path to the
skysql_chain.pemfile containing the "Certificate Authority Chain" (Download)
Create a new connection.
In the "Parameters" 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:
In the "Use SSL" drop-down list, select "Require".
In the "SSL CA File" text box, enter the path to the downloaded
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.