[mythtv-users] mysql problems

Thomas Mashos thomas at mashos.com
Tue Apr 26 21:00:11 UTC 2016


On Tue, Apr 26, 2016 at 1:51 PM Damian <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
> 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'

If not, then take a look in

/etc/mysql/conf.d/mythtv.cnf and see what bind-address is set to.
-- 
Thomas Mashos
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20160426/42672a1b/attachment.html>


More information about the mythtv-users mailing list