SQLyog

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.

Compatibility

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

Note

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:

  1. Determine the connection information for your MariaDB SkySQL database service:

    Parameter

    Where to find it

    MySQL tab
    Host

    Fully Qualified Domain Name in the Service Details view

    MySQL tab
    Port

    Read-Write Port or Read-Only Port in the Service Details view

    MySQL tab
    User

    Default username in the Service Credentials view, or the username you created

    MySQL tab
    Password

    Default password in the Service Credentials view, the password you set on the default user, or the password for the user you created

    SSL tab
    CA Certificate

    Path to the skysql_chain.pem file containing the "Certificate Authority Chain" (Download)

  2. Create a new connection.

  3. 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.

  4. In the "SSL" tab:

    • Select the "Use SSL Encryption" checkbox.

    • In the "CA Certificate" text box, enter the path to the downloaded skysql_chain.pem file (Download).

  5. If using MariaDB Platform for Analytics, in the "Power Tools" tab of preferences:

    • Uncheck "Enable Query Profiler" and click OK.

Note

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.