April 20, 2020, 3:46am
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.
April 20, 2020, 5:32pm
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.
April 22, 2020, 2:35pm
Change the root password for a MemSQL node on the local machine, or correct memsqlctl’s record of an existing password.
Usage Usage: memsqlctl change-root-password [flags] Flags: -a, --all change the password of all nodes on the machine...
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.