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)