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 by default if you do not specify the appropriate host and port options. If you attempt to connect to SingleStoreDB 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