So I’m trying to setup a database to use with kodi to be stored on the nas. User is setup, permissions are correct, but can’t connect to the database from the local lan.
Connections seem to be set for 127.0.0.1 only, If I SSH in, I can set /etc/my.cnf to read 0.0.0.0 but outside connections are still refused; using either simple tcp/ip or tcpip over ssh connection. The file seems to be overwritten during reboot by /var/usr/modules/etc/my.cnf which is ‘read only’,
How can it be setup to allow connections from the local network?