Connect with SQL Developer

To connect to SingleStore from SQL Developer:

1. Download a MySQL connector for Java, for example, MySQL Connector Java 8.0.24.

2. Open SQL Developer, and add a new third-party connector. Select Preferences > Database > Third Party Drivers.

3. Select Add Entry, and then add the .jar file downloaded earlier.

4. Create a new connection, select Connections > New Connection.

5. In the New / Select Database Connection dialog, select or enter the following information:

   • Name: A name for your connection, for example SingleStoreDB.

   • Database Type: From the list, select MySQL.

   • Hostname: The IP address or hostname of your SingleStore cluster.

   • Username: The SingleStore database username. Enter root.

   • Password: The password for the SingleStore database user.

   • Port: Default is 3306.

6. Select Connect.