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

[Bill Meek]

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

-- 
Bill