Connect with SQL Workbench

Note

When using a third-party SQL client or development tool, you must first add a database user to log into a SingleStoreDB Cloud database.

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.
In the Driver drop-down menu select MySQL (com.mysql.jdbc.Driver). This Driver requires the MySQL Java connector.
Once you have Driver selected, enter the URL jdbc:mysql://<host>:<port>. By default SingleStoreDB Cloud has one user, root with no password, so set username to root and leave password empty. For SingleStoreDB Cloud, the user name is admin and the password is specified when the workspace was created.
Complete the other fields as desired.
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.

Was this article helpful?