[mythtv-users] Mysql permissions problem

[Michael Tiller]

On Mon, May 17, 2010 at 5:13 PM, Peter Abplanalp <
pta-myth at psaconsultants.com> wrote:

> hi,
>
> would you mind posting the results of:
>
> use mysql;
> select user, host from user;
>

mysql> select user, host from user;
+------------------+----------------+
| user             | host           |
+------------------+----------------+
| mythtv           | %              |
| root             | 127.0.0.1      |
| mythtv           | 192.168.11.%   |
| mythtv           | 192.168.11.120 |
| mythtv           | daddy          |
| debian-sys-maint | localhost      |
| mythtv           | localhost      |
| root             | localhost      |
| root             | terranova      |
+------------------+----------------+
9 rows in set (0.00 sec)


Note that I tried to remove the "terranova" entry (some artifact of Ubuntu
packaging?!?) but I couldn't seem to do it.

As you can see, I started with very specific hosts and moved to gradually
more general ones.

Note my MySql server is completely behind my firewall so I'm not so access
from 192.168.11.% should be fine.

--
Mike
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20100517/f2c3c2bf/attachment.htm>