I have changed the root password of the memsql cluster as below.
But I am unable to connect to the memsql cluster using the latest password. When I try to connect with latest password , I am facing an error as "ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES)
" Refer the below screenshot for more information.
It looks like maybe the exclamation point in the string may have been interpreted by the Linux shell and changed the password itself. Looks like the password was actually set as:
“Raghavsudo memsql-report collect -allroot”
according the the output.
Next time try a password without an exclamation point.
sudo memsqlctl change-root-password --password “NewSecurePass”
In above link example specified in double quote.Password should be enclosed in single quote not in double quote.
Now I am able to connect.