I deployed a memsql cluster by memsql-deploy setup-cluster, the deployment seems normal without error, but after the deployment, when I type memsql, there will be below error:
$ memsql
ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO)
memesql-admin show all the nodes are running.
$ memsql-admin list-nodes
⠋ Listing nodes on all hosts arris@10.89.58.61’s password:
±-----------±-----------±------------±-----±--------------±-------------±--------±---------------±-------------------±-------------+
| MemSQL ID | Role | Host | Port | Process State | Connectable? | Version | Recovery State | Availability Group | Bind Address |
±-----------±-----------±------------±-----±--------------±-------------±--------±---------------±-------------------±-------------+
| AA39B238C5 | Master | 10.89.58.61 | 3306 | Running | True | 6.8.11 | Online | | 0.0.0.0 |
| A3B9D195A7 | Aggregator | 10.89.58.62 | 3306 | Running | True | 6.8.11 | Online | | 0.0.0.0 |
| 68387F2364 | Leaf | 10.89.58.63 | 3306 | Running | True | 6.8.11 | Online | 1 | 0.0.0.0 |
| D8C02B75B3 | Leaf | 10.89.58.64 | 3306 | Running | True | 6.8.11 | Online | 2 | 0.0.0.0 |
| A7B9F63C1A | Leaf | 10.89.58.65 | 3306 | Running | True | 6.8.11 | Online | 1 | 0.0.0.0 |
| FA282B5BAC | Leaf | 10.89.58.66 | 3306 | Running | True | 6.8.11 | Online | 2 | 0.0.0.0 |
±-----------±-----------±------------±-----±--------------±-------------±--------±---------------±-------------------±-------------+
I don’t what’s the problem, can anyone give me some advice? thanks advance.
It sounds like you need to use
memsql -p
and then enter your root password when prompted.
Thanks Sir.
that’s the issue.