I can not connect to my mysql cluster. I followed this tutorial : https://www.digitalocean.com/community/tutorials/how-to-create-a-multi-node-mysql-cluster-on-ubuntu-18-04 I tried connecting with workbench and mysql command to both data nodes and managment nodes on both 3306 and 1186 but I can cont connect to anywhere. Firewall is disabled on all machines. I created new user which can connect from anywhere but still no luck. Cluster works according to the test in the tutorial. To which node and port should i try to connect? Or is something missing in that tutorial?
So I fixed it thanks to nafooesi. For everyone that has same problem I did this.
Tried on my managment node telnet localhost 3306 .
It said connection refused.
I have edited /etc/mysql/mysql.conf.d/mysqld.cnf.
sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
Find bind-address = 127.0.0.1 and rewrite it with bind-address = ip.of.managment.node
And with workbench and programming languages you connect to your managment node not data nodes as i previously thought.
Thanks once again nafooesi.