Connecting to MemSQL From Command line

Help Connectors and Pipelines
1

I am very new to MemSQL and trying to do a POC. I know the topic I am putting here must have been answered many times but I could not find any particular note to this, so posting it here.

I have deployed MemSQL on 3 node cluster where it is running as 1 aggregator and 2 leaves. I am trying to connect memsql prompt locally from aggregator node but not sure where I am doing wrong in logging in. Following error I am getting. Any help here is much appreciated.

[root@myhost~]# mysql -u root -h 127.0.0.1 -P 3306 --prompt="memsql> "
ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO)
[root@myhost~]#

2

Add -p to the command line and you will be prompted to enter the root password.

3

Thanks Hanson, It worked!