[mythtv-users] 0.28 upgrade issue frontend connection

[Steve Greene]

>
> mysql> SELECT user, host from user;
> +------------------+-------------+
> | user             | host        |
> +------------------+-------------+
> | mythtv           | %           |
> | mythtv           | 192.168.1.2 |
> | mythtv           | bilbo.home  |
> | debian-sys-maint | localhost   |
> | mysql.sys        | localhost   |
> | root             | localhost   |
> +------------------+-------------+
>

Shouldn't this cover all the locations?


This is super-frustrating, I always expect that a database restore from a
working setup should "just work". It never does.

How do I turn on more helpful debugging messages? /var/log/mysql/error.log
gives me nothing more than what I've seen from command-line login attempts.

Steve

On Sat, Jul 16, 2016 at 5:42 PM, Hika van den Hoven <hikavdh at gmail.com>
wrote:

> Hoi Steve,
>
> Saturday, July 16, 2016, 11:30:57 PM, you wrote:
>
> > I thought that was what mythtv.cnf was for, which I've set to my
> > local ip.  I just tried setting mysqld.cnf
> > "bind-address=my_ip_address"  and it hasn't worked.
>
> > I can still manually call up mysql -umyth  -p, but mysql
> > -h192.168.1.x -umyth -p gives me ERROR 1045 (28000):  Access denied
> > for user 'mythtv'@'my_hostname' (using password: YES).
> > Incidentally, same with the root mysql account. I can connect from
> > my secondary backend via the ip address. It just won't accept an
> > login via the IP address local to the server.
>
> > Steve
>
> > On Sat, Jul 16, 2016 at 3:27 PM, Steve Greene <sgreene59 at verizon.net>
> wrote:
>
> > Since upgrading to 0.28 and Mint 18, my local frontend connects to
> > "localhost" but not the IP address of the MBE (which is local).
>
> > mysql -h"my_IP_ADDR" -u myth -p will fail, but mysql -umythtv -p
> > will connect. Do I have to add the IP address to one of the tables in
> mythconverg?
>
> > Thanks in advance for your assistance.
>
> > Steve
> >
>
> Have you setup a user for that location in mysql. You have to setup
> the user/password for the locations from where you want to have
> access. So localhost or an IP address or % for all machines.
>
> Tot mails,
>   Hika                            mailto:hikavdh at gmail.com
>
> "Zonder hoop kun je niet leven
> Zonder leven is er geen hoop
> Het eeuwige dilemma
> Zeker als je hoop moet vernietigen om te kunnen overleven!"
>
> De lerende Mens
>
> _______________________________________________
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20160716/95c4f18b/attachment.html>