Can't connect to remote MySQL server Error 2003 (HY000)

Question

Sorry but I started this thread because I couldn't found a solution. I'm using MySQL Router and InnoDB Cluster to deploy a sandbox cluster. I've followed the documentation see here and here , but when I try to connect by mysqlsh --uri root@localhost:6446, it outputs this following error:

MySQL Error 2003 (HY000): Can't connect to remote MySQL server for client connected to '127.0.0.1:6446'

What am I missing?

Answer 1

Maybe you can check the myrouter log?

In my log it shows the following:

Failed connecting with Metadata Server mysql-db1.mjdh.local:3308: Unknown MySQL server host 'mysql-db1.mjdh.local' (110) (2005)

So I write it in hosts and the problem missed.