SingleStore provide multiple way to connect the SingleStore cluster. This tutorial will show how to connect the cluster from Mac/Linux Terminal.
Following information is required to connect to the SingleStore cluster.
********************logonFile.properties********************
[mysql]
user=tutorial_db_owner
password="5eFV!Q4AYy,Ynl$#_b^"
host=memsql-host-name.dbmstutrials.com
*************************************************************
Note: Double quote in the password is not part of password and enclosing it within double quote is important, otherwise it will fail with below error.
ERROR 1045 (28000): Access denied for user 'tutorial_db_owner'@'localhost' (using password: YES)
path/to/mysql-connector/bin/mysql --defaults-file=/path/to/logonfile/logonFile.properties tutorial_db --port=3306 --default-auth=mysql_native_password --protocol=TCP