[mythtv-users] 0.28 upgrade issue frontend connection

[Mark Perkins]

> This is a single computer mythTV setup, so external access is not
expected.

Ok.

> The IP address of this computer is 192.168.63.3  so for this machine, it
should work the same as 127.0.0.1 or localhost.

Agreed. Should. At least when the bound address is 0.0.0.0 not sure it
does/should for the initial case where the mysqld bound address was
127.0.0.1.

At this point you could probably just test this command:
mysql -h127.0.0.1 -umythtv -pb0RhwvPj -e "select * from mythconverg.settings
where value='BackendServerIP'"

And if / when that works update config.xml to use 127.0.0.1 as the IP
address and call it a day. Probably also re-comment out the bind-address
line in /etc/mysql/mysql.conf.d/mythtv.cnf just to tighten things up a
little.

However based on the netstat output using the IP address of 192.168.63.3
should now have worked (mysqld is now bound to 0.0.0.0). Assuming you don’t
have a firewall blocking things (I don't know what Mint uses for firewall)
and also assuming there is not something odd happening with IPv6 I would be
very very tempted to try this:

mysql -uroot -pb0RhwvPj -e "grant all on mythconverg.* to
'mythtv'@'192.168.63.%' identified by 'mythtv';
mysql -uroot -pb0RhwvPj -e "set password for
'mythtv'@'192.168.63.%'='b0RhwvPj'"
mysql -uroot -pb0RhwvPj -e "flush privileges"
mysql -h192.168.63.3 -umythtv -pb0RhwvPj -e "select * from
mythconverg.settings where value='BackendServerIP'"

If this works, then in my opinion it seems to show that a host value of %
does not work as a wildcard for 192.168.63.%. If it works that is. Please
let me know if you try it.

Also, if the topmost command using -h127.0.0.1 does not work you could try
this:

mysql -uroot -pb0RhwvPj -e "grant all on mythconverg.* to
'mythtv'@'127.0.0.1' identified by 'mythtv';
mysql -uroot -pb0RhwvPj -e "set password for
'mythtv'@'127.0.0.1'='b0RhwvPj'"
mysql -uroot -pb0RhwvPj -e "flush privileges"
mysql -h127.0.0.1 -umythtv -pb0RhwvPj -e "select * from mythconverg.settings
where value='BackendServerIP'"