Connect with Any MySQL Compatible Tool to SingleStore

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

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

Connection Details

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

  • host: IP address or hostname of your cluster.

  • port: Port of the SingleStore deployment. Default is 3306.

  • user: Username of the SingleStore database user. For example, root.

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 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. 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:

Was this article helpful?