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 SingleStoreDB has one user, root with no password, so set username to root and leave password empty. For SingleStoreDB, the user name is admin and the password is specified when the cluster was created.

  4. Complete the other fields as desired.

  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.

Last modified: April 3, 2023

Was this article helpful?