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

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

Last modified: June 22, 2022

Was this article helpful?