[mythtv-users] Ver 31 frontend cannot connect to the database
jam at tigger.ws
Mon Nov 23 09:59:52 UTC 2020
Mike I said
> From frontend box
> $ mysql -u mythtv -pmythtv -h dbbox mythconverg
> If you can’t connect then fix this first (watch space after -p)
I thought you replied
> I can log in to mysql on the backend using mythtv and 'mysillyrubbish'
> but when I use those same credentials in the database page in the
> frontend setup they don't work. They do work when I log in to mythtv
> using the backend address (192.168.0.xxx:6544) from my browser.
> The mc.sql I found doesn't appear to be useful for my needs.
In which case
> Ok, that is the problem then. The "bind-address=127.0.0.1" is the one
> being used by MariaDB, instead of the "bind-address=::", because of
> the order it reads the config files. The last one read is the one
> that gets used. So the simple thing to do is just to comment out the
> "bind-address=127.0.0.1" line in the
> /etc/mysql/mariadb.conf.d/50-server.cnf file by putting a # at the
> start of the line. Then restart MariaDB:
> sudo systemctl restart mariadb
More information about the mythtv-users