Connect with Any MySQL Compatible Tool to SingleStore Helios

On this page

In general, if the client you are using to connect supports the MySQL protocol, you can use it to connect to SingleStore Helios. For example, if you connect Wordpress to MySQL, you can probably use most of the same configuration to connect to SingleStore Helios.

Ensure that the connection details are correct. Refer to Common Issues to troubleshoot some common connectivity issues.

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.

Connection Details

You’ll need to specify the host, port, user, password, and possibly the database.

host: IP address or hostname of your workspace.

Refer to SingleStore Helios Endpoints to determine the endpoint (host:port) of your deployment.
port: Port of the SingleStore deployment. Default is 3306.
user: Username of the SingleStore database user. For example, admin.

Common Issues

Some of the issues you may encounter, and how to solve them:

Wrong Authentication Adapter: MySQL v8 authentication has some issues in SingleStore Helios and SingleStore recommends that you use a newer version. Sometimes you can work around this by specifying --default-auth=mysql_native_password in the connection details.
Binary Protocol: Use the text protocol when connecting to SingleStore Helios. You may need to disable server-side prepared statements (useServerPrepStmts=false).
Connection Failed: Check the firewall configuration and perform other general connectivity troubleshooting.

Last modified: September 26, 2025

Was this article helpful?

Verification instructions

Note: You must install cosign to verify the authenticity of the SingleStore file.

Use the following steps to verify the authenticity of singlestoredb-server, singlestoredb-toolbox, singlestoredb-studio, and singlestore-client SingleStore files that have been downloaded.

You may perform the following steps on any computer that can run cosign, such as the main deployment host of the cluster.

(Optional) Run the following command to view the associated signature files.
Shell
```
curl undefined
```
Download the signature file from the SingleStore release server.
- Option 1: Click the Download Signature button next to the SingleStore file.
- Option 2: Copy and paste the following URL into the address bar of your browser and save the signature file.
- Option 3: Run the following command to download the signature file.
  Shell
```
curl -O undefined
```

After the signature file has been downloaded, run the following command to verify the authenticity of the SingleStore file.

Shell

echo -n undefined |
    cosign verify-blob --certificate-oidc-issuer https://oidc.eks.us-east-1.amazonaws.com/id/CCDCDBA1379A5596AB5B2E46DCA385BC \
      --certificate-identity https://kubernetes.io/namespaces/freya-production/serviceaccounts/job-worker \
      --bundle undefined \
      --new-bundle-format -

Verified OK