SQLyog is a graphical application which can interact with MariaDB Servers, including MariaDB database services on MariaDB SkySQL.
SQLyog is a third-party product. Additional information on SQLyog is available from Webyog Inc.
SQLyog 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 SQLyog
SQLyog version 13.1.7 (Windows) was used to prepare these instructions. When using other versions, these instructions may require adjustment.
To connect to a database service on MariaDB SkySQL through SQLyog:
Determine the connection information for your MariaDB SkySQL database service:
Where to find itMySQL tabHost
Fully Qualified Domain Name in the Service Details viewMySQL tabPort
Read-Write Port or Read-Only Port in the Service Details viewMySQL tabUser
Default username in the Service Credentials view, or the username you createdMySQL 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 "MySQL" tab:
Fill in the connection information for your service.
Remember to specify the port, as MariaDB SkySQL does not use the standard port for client connections.
In the "SSL" tab:
Select the "Use SSL Encryption" checkbox.
In the "CA Certificate" text box, enter the path to the downloaded
If using MariaDB Platform for Analytics, in the "Power Tools" tab of preferences:
Uncheck "Enable Query Profiler" and click OK.
A SSL warning is surfaced for HA (Primary/Replica), Galera, and Distributed Transactions topologies (all are topologies that use MariaDB MaxScale). The only known impact is the warning message; you are able to query the database.