<div class="gmail_quote">On Mon, May 17, 2010 at 5:13 PM, Peter Abplanalp <span dir="ltr"><<a href="mailto:pta-myth@psaconsultants.com">pta-myth@psaconsultants.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
hi,<br>
<br>
would you mind posting the results of:<br>
<br>
use mysql;<br>
select user, host from user;<br></blockquote><div><br>mysql> select user, host from user;<br>+------------------+----------------+<br>|
user | host |<br>+------------------+----------------+<br>|
mythtv | % |<br>| root |
127.0.0.1 |<br>| mythtv | 192.168.11.% |<br>|
mythtv | 192.168.11.120 |<br>| mythtv |
daddy |<br>| debian-sys-maint | localhost |<br>|
mythtv | localhost |<br>| root |
localhost |<br>| root | terranova |<br>+------------------+----------------+<br>9
rows in set (0.00 sec)<br><br><br>Note that I tried to remove the
"terranova" entry (some artifact of Ubuntu packaging?!?) but I couldn't
seem to do it. <br><br>As you can see, I started with very specific
hosts and moved to gradually more general ones.<br><br>Note my MySql
server is completely behind my firewall so I'm not so access from
192.168.11.% should be fine.<br><br>--<br>Mike<br><br></div></div>