[mythtv-users] 0.25 to 0.26 upgrade issue with MYSQL

[Steve Greene]

On Sun, 2013-08-04 at 17:22 -0500, Bill Meek wrote:
> On 08/04/2013 03:19 PM, Steve Greene wrote:
> >
> >
> > On Sun, 2013-08-04 at 11:56 +1200, Paul Kendall wrote:
> >>
> >> In my setup I have bind-address=0.0.0.0
> >> i.e. any/all addresses
> 
> Specifically: /etc/mysql/conf.d/mythtv.cnf need only contain the following:
> 
> [mysqld]
> bind-address=0.0.0.0
> 
> > Ok, started again from scratch, after some dpkg craziness with Mint
> > wanting to setup another Mysql Administrator "sys-debian-maintainer"...
> 
> In *buntu, it's: debian-sys-maint. Which you should never need to
> use/mess with after setup.
> 
> > ... I pointed it back to the root account I previously setup, which in
> > turn supposedly registered my IP address with myth. "Supposedly". After
> > editing "/etc/mysql/my.cnf" to point to my local IP
> 
> As mentioned, leave that file alone and make the change under conf.d.
> It won't fix your current problem, just makes it less likely that when
> a package maintainer releases a new my.cnf that your change won't get
> removed.
> 
> > ... and changing the
> > permissions in mysql to grant all to my subnet. I still have the issue.
> 
> Here's a dump of mine (that works, you may want to restrict it more.)
> 
>      http://pastebin.com/raw.php?i=b5nafh8W
> 
> Obviously the passwords have been scribbled. If you wanted to see the
> encrypted version of a password, from mysql, you'd type (for example:)
> 
>      SELECT PASSWORD('mythtv');
> 
> > Manually connecting to the database fails using the commandline: mysql
> > -h 192.168.1.2 -u mythtv -p, yielding the message "ERROR 1045 (28000):
> > Access denied for user 'mythtv'@'hostname.local' (using password: YES)".
> > Still mystified.
> 
> Your command line should have been:
> 
>      mysql -h 192.168.1.2 -u mythtv -p mythconverg

Still mystified, I even tried to get the frontend on the master working
using localhost, and it failed. Looked at the users and hosts set in
mysql, I suspect there was something going on in the order they were
being looked at from the table. 0.25 works with no issues. I may just
end up holding on until the next Mint long term release, hopefully if
there are distribution issues involved, they'll be solved by then. Thank
god for Clonezilla backups!

Thanks again,
Steve

-- 
fnord
Robert Anton Wilson (1932-2007)