Computer with mariadb server was set up a long time ago and has 3 client-computers on LAN that work great. I want to add another client. Installed mariadb-client on latest linux mint 22.2. But,
mariadb -uroot -h<server local IP> -p gives an ERROR 2002 can't connect error.
on server I checked that
/etc/mysql/mariadb.conf.d/50-server.cnf has
bind-address = 0.0.0.0
When first set up I remember making root accessible from any IP and it works because my IPs have changed many times over the years and I also got new internet but the other clients still work.
I ran:
netstat -ant | grep 3306
output:
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN
Is there another obvious setting or step that I am forgetting?
UPDATE: i ran
telnet <host ip> 3306
it said it connected. then host disconected. After that everything worked. mariadb worked, my scripts worked... but i thought telnet was just a check... didn't actually change anything. But that is what happened so I am happy. If anyone knows what happened I'd be grateful for any explanation.
