[mythtv-users] mysql problems

Damian myth at surr.co.uk
Wed Apr 27 11:32:06 UTC 2016


On 26/04/2016 22:00, Thomas Mashos wrote:
>
>
> On Tue, Apr 26, 2016 at 1:51 PM Damian <myth at surr.co.uk
> <mailto:myth at surr.co.uk>> wrote:
>
>     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
>     _______________________________________________
>     mythtv-users mailing list
>     mythtv-users at mythtv.org <mailto:mythtv-users at mythtv.org>
>     http://lists.mythtv.org/mailman/listinfo/mythtv-users
>     http://wiki.mythtv.org/Mailing_List_etiquette
>     MythTV Forums: https://forum.mythtv.org
>
>
> Check is mysql is listening on that IP
>
> 'netstat -tulpn | grep 3306'
>

Hi Thomas,

Thanks for helping! Here's the output of that ...

netstat -tulpn | grep 3306
(Not all processes could be identified, non-owned process info
  will not be shown, you would have to be root to see it all.)
tcp        0      0 127.0.0.1:3306          0.0.0.0:* 
LISTEN      -


sudo netstat -tulpn | grep 3306
[sudo] password for media:
tcp        0      0 127.0.0.1:3306          0.0.0.0:* 
LISTEN      875/mysqld



> If not, then take a look in
>
> /etc/mysql/conf.d/mythtv.cnf and see what bind-address is set to.

That file contains ...

[mysqld]
#bind-address=::
max_connections=100

That doesn't seem to be binding anything! I'll see if I can find out 
what it should look like.

Thanks again for the pointer's.

Damian


More information about the mythtv-users mailing list