Connect with DbVisualizer

Prerequisites

• The SingleStore JDBC Driver (You may also install the SingleStore JDBC driver from DbVisualizer, select Tools > Driver Manager. Find the SingleStore driver from the list, and install it.)

Connect with DbVisualizer

You need to setup a Database Connection in DbVisualizer to access your SingleStoreDB database.

1. In DbVisualiser, select Database > Create Database Connection.

2. From the Driver Name list, select SingleStore.

3. In the SingleStore tab, enter the following details in the corresponding fields:

   • Database Server: the IP address or hostname of the SingleStoreDB cluster

   • Database Port: the port used by the SingleStoreDB cluster (default: 3306)

   • Database: the name of the SingleStoreDB database

   • Database Userid: ID or name of the SingleStoreDB user

   • Database Password: password for the SingleStoreDB user

   

4. Select the Connect button. You may also select Ping Server to verify the connectivity between DbVisualizer and SingleStoreDB.

You can now explore your SingleStoreDB databases using DbVisualizer.