MySqlRouter cant connect to MySqlServer

Posted on

Question :

mysqlrouter service is running

ports are listening

tcp        0      0 0.0.0.0:6446            0.0.0.0:*               LISTEN      6150/mysqlrouter
tcp        0      0 0.0.0.0:6447            0.0.0.0:*               LISTEN      6150/mysqlrouter
tcp        0      0 0.0.0.0:6448            0.0.0.0:*               LISTEN      6150/mysqlrouter
tcp        0      0 0.0.0.0:6449            0.0.0.0:*               LISTEN      6150/mysqlrouter
tcp        0      0 0.0.0.0:8443            0.0.0.0:*               LISTEN      6150/mysqlrouter

but when I try to connect using mysql client from different computer

mysql -u innodbcluster -h 192.168.11.124 -P 6446 -p

it says

ERROR 2003 (HY000): Can’t connect to MySQL server on
‘192.168.11.124:6446’ (10060)

what am I missing?

PS I installed the mysqlrouter in the primary mysqlserver
am I correct or it should be installed in the application thats going to connect to the innodbcluster?

Answer :

mysqlrouter should be installed in the application that is going to connect to innodbcluster

Leave a Reply

Your email address will not be published.