Connect with Any MySQL Compatible Tool to SingleStoreDB Cloud
On this page
In general, if the client you are using to connect supports the MySQL protocol, you can use it to connect to SingleStoreDB Cloud.
This guide should help you troubleshoot any issues that come up.
When using a third-party SQL client or development tool, you must first add a database user to log into a SingleStoreDB Cloud database.
You’ll need to specify the
password, and possibly the
host- Use the endpoint (you can find this in the Cloud Portal)
port- default is 3306
Some of the issues you may encounter, and how to solve them:
Wrong Authentication Adapter - MySQL v8 authentication has some issues in SingleStoreDB Cloud and SingleStore recommends that you use a newer version.
Sometimes you can work around this by specifying
--default-auth=mysql_in the connection details.
Binary Protocol - Use the text protocol when connecting to SingleStoreDB Cloud.
You may need to disable server-side prepared statements (
Connection Failed - Check firewall configuration and perform other general connectivity troubleshooting.
Last modified: October 31, 2023