SingleStore DB

Connect with SQL Developer

  1. Download a MySQL connector for Java. For example: https://packages.atlassian.com/maven-external/mysql/mysql-connector-java/8.0.24/mysql-connector-java-8.0.24.jar

  2. In SQL Developer, add a new third-party database connector. Under Oracle SQL Developer > Preferences > Database > Third-Party JDBC Drivers, add your MySQL connector .jar directory. Click OK.

  3. Create a new connection and select the MySQL connection option:

    16083b57631f91.png
  4. Enter the following connection information:

    1. For User: enter admin (SingleStore Managed Service) or root (SingleStore DB). Enter your password.

    2. For Hostname: enter the Admin endpoint (SingleStore Managed Service) or IP Address (SingleStore DB) for your cluster. You can find the Admin endpoint in the SingleStore Portal.

    3. Enter the port number: 3306

  5. Click Connect.