[mythtv-users] mysql problems

[Damian]

Hi Everyone,

I've got the shiny new Xubuntu 16.04 freshly installed on all of my 
machines. I'm just starting to add Mythbuntu backend onto the server 
machine tonight, and I'm having problems already.

The backend can't connect to mysql.

I can log in as root ...
mysql -u root -p
... gets me in fine.

I can log in as mythtv ...
mysql -u mythtv -p
... gets me in fine.

However, this ...
mysql -u mythtv -p -h 192.168.0.2
... responds with:
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.0.2' (111)

I don't understand this. Why can I not log in when I specify the 
computer's own IP address?

ifconfig confirms that "inet addr:192.168.0.2"

I just checked, and I can log in with " mysql -u mythtv -p -h 
127.0.0.1". It's just adding the real IP address that's not working.

I assume this is the source of the problem. Any idea what's causing this?

Thanks,
Damian