SQLyog can connect to MariaDB SkySQL services, allowing you to run queries interactively:
SQLyog is a graphical database tool
SQLyog is available for Windows
SQLyog has been tested by MariaDB to properly connect and execute queries with:
Single Node Analytics
Single Node Transactions
These instructions are based on:
SQLyog version 13.1.7 for Windows
When using other versions, these instructions may require adjustment.
Connecting with SQLyog
To connect to a MariaDB SkySQL service:
Determine the connection parameters for your MariaDB SkySQL service:
Download the certificate authority chain.
Create a new connection.
In the "MySQL" 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.
In the "SSL" tab:
Select the "Use SSL Encryption" checkbox.
In the "CA Certificate" text box, enter the path to the certificate authority chain (.pem) file.
For Analytics services, in the "Power Tools" tab of preferences:
Uncheck "Enable Query Profiler" and click OK.
For Distributed Transactions service, in the "Power Tools" tab of preferences:
Uncheck "Show Profile" and click OK.