Connect with SQL Developer

Note

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

To connect to SingleStore Helios 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 Helios workspace.

    • Username: The SingleStore database username. Enter admin.

    • Password: The password for the SingleStore database user.

    • Port: Default is 3306.

  6. Select Connect.

Last modified: November 30, 2023

Was this article helpful?