[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