[mythtv-users] DB Backup Issues

[Chuck Peters]

On Mon, Apr 23, 2012 at 8:49 AM, Michael T. Dean
<mtdean at thirdcontact.com> wrote:

>> And to add another point to hopefully solve this issue, the
>> mythconverg_backup.pl works from one of the frontends.
>
>
> This implies that your MySQL server configuration provides different
> permissions (and/or different passwords) for different "users".  In MySQL a
> "user" is a combination of username, hostname (used to connect) and
> password.  MySQL will always choose the most-restrictive of the user
> definitions when the information matches multiple (i.e. an actual IP address
> or an actual hostname rather than a wildcard definition).  Though your user
> table implies that the password for mythtv at localhost is identical to the
> password for mythtv@% (where localhost would be chosen in preference to % on
> the host that's running the database server), it's possible that the
> configuration didn't "take"--i.e. some distros seem to have broken MySQL
> auth so that a GRANT/FLUSH PRIVILEGES doesn't actually work on its own--it
> must be followed by a:
>
> SET PASSWORD FOR 'mythtv'@'localhost' = PASSWORD('mythtv');
> SET PASSWORD FOR 'mythtv'@'%' = PASSWORD('mythtv');

My original email showed that is the settings I have [1].  Does the %
mean IP address only, and/or any hostname?

The original error message showed it connecting from io.lan, the FQDN
in DNS bind, not the IP address.  If I try to set access from the .lan
zone, would the following work?
SET PASSWORD FOR 'mythtv'@'*.lan' = PASSWORD('mythtv');

Thanks,
Chuck


1.
http://www.mythtv.org/pipermail/mythtv-users/2012-April/332559.html
http://www.mythtv.org/pipermail/mythtv-users/2012-April/thread.html#332559
mysql> SELECT `Host`,`User` FROM `db` WHERE `Db` = 'mythconverg';
+-----------+--------+
| Host      | User   |
+-----------+--------+
| %         | mythtv |
| localhost | mythtv |
+-----------+--------+
2 rows in set (0.00 sec)

The original error was:
mysqldump exited with status: 2
mysqldump output:
mysqldump: Got error: 1045: Access denied for user 'mythtv'@'io.lan'
(using password: YES) when trying to connect