[mythtv-users] Ver 31 frontend cannot connect to the database

[James Linder]

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

Is irrelevant.

James