SingleStore Managed Service

Connect with SQL Workbench

  1. Once you have SQL Workbench installed, open the Connectors window.

    Note: Some users have reported issues connecting with SQL Workbench v8 and have recommended using v6 instead.

  2. In the Driver drop-down menu select MySQL (com.mysql.jdbc.Driver). This Driver requires the MySQL Java connector.

  3. Once you have Driver selected, enter the URL jdbc:mysql://<host>:<port>. By default SingleStore DB has one user, root with no password, so set username to root and leave password empty. For SingleStore Managed Service, the user name is admin and the password is specified when the cluster was created.

  4. Complete the other fields as desired.

    16083b576527d1.png
  5. Click OK and the SQL Workbench window will appear. Here you can issue queries in the top window and see results in the bottom window.

    16083b5765a052.png
    16083b57660cb0.png