Unable to create a new Cluster: invalid root credentials

Help
1

Hello,
on a virtual machine Centos 7 I have installed a single host cluster-in-a-box using a user with sudo permissions.
Later, I’ve tried to create a new cluster by MemSQL - Studio as described in SingleStoreDB Cloud · SingleStore Documentation. The guide says I have to enter “root” as username and an empty password but I get an invalid credentials error

image
image1433×148 6.6 KB

Capture
Capture729×671 34.2 KB

How can I solve this impediment?

Thanks.

2

Hi
,

I am wondering if you did set up a root password when you installed the MemSQL instances. Can you try this command successfully to get into MemSQL command line client:

your Linux prompt>memsql -P 3306 -u root -p

The system will prompt you for the password, hit enter.

Do you get some kind of password errors?

Yu-wang

3

Thanks for the quick reply. Yeah, I had not realized I set up a password during the installation process. Is there a way to change it into an empty one?
Thanks.

4

sure, run this sql command:

set password for ‘root’@’’ = password(’’);

5

The command was uncorrect as the percentage sign was missing. No problem. I solved my issue.
Thanks a lot!

set password for ‘root’@’%’ = password(’’);