MySQL Command-Line Considerations

  • If using the MySQL 8.x client, you must pass --default-auth=mysql_native_password in your connection string.

  • If you also have MySQL installed, the MySQL client may connect to MySQL instead of SingleStoreDB Cloud by default if you do not specify the appropriate host and port options. If you attempt to connect to SingleStoreDB Cloud on localhost, even if you specify the correct port, the MySQL client may still attempt to connect to MySQL with default configuration. See ERROR 2002 (HY000): Can’t connect to local MySQL server through socket /var/run/mysqld/mysqld.sock

For more documentation on the MySQL client, visit the MySQL documentation.