Connect with SQL Developer

Notice

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

  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 (SingleStoreDB Cloud) or root (SingleStoreDB Cloud). Enter your password.

    2. For Hostname: enter the endpoint (SingleStoreDB Cloud) or IP Address (SingleStoreDB Cloud) for your workspace. You can find the endpoint in the SingleStore Portal.

    3. Enter the port number: 3306

  5. Click Connect.