Skip to main content

SingleStoreDB v7.8

Connect with Any MySQL Compatible Tool to SingleStoreDB

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

This guide should help you troubleshoot any issues that come up. The main thing is to make sure you're using the correct connection details.

Connection Details

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

  • host - IP address of your cluster

  • port - default is 3306

  • user - 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 SingleStoreDB and we recommend 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 SingleStoreDB. You may need to disable server-side prepared statements (useServerPrepStmts=false).

  • Connection Failed - Check firewall configuration and perform other general connectivity troubleshooting.

In this section: