I am struggling to connect Mariadb installed on a Synology. MariabDB10 has been installed successfully. I am able to create a user via phpmyadmin. I can connect to the DB using the Synology CLI. But when I try to connect via HA (HA is install on a rpi on the same network as the Synology), I get this error.
Error 2002 (HY000): Can't connect to MySQL server on '192.168.1.50' (115)
On Synology: I have edited the my.cnf file to read either one
bind-address = 0.0.0.0 or bind-address = 192.168.1.50
On HA: I use this cmd to test connect to Mariadb
mysql -h 192.168.1.50 -P 3307 -u some_user -p
phpmyadmin: This is the user I have created for HA.