<div class="gmail_quote">On Mon, May 17, 2010 at 8:50 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;">
On Mon, May 17, 2010 at 6:17 PM, Michael Tiller<br>
<div class="im"><<a href="mailto:michael.tiller@gmail.com">michael.tiller@gmail.com</a>> wrote:<br>
> On Mon, May 17, 2010 at 7:40 PM, Michael Tiller <<a href="mailto:michael.tiller@gmail.com">michael.tiller@gmail.com</a>><br>
> wrote:<br>
</div><div class="im">> mysql> select user, host from user;<br>
> +------------------+-----------+<br>
> | user | host |<br>
> +------------------+-----------+<br>
> | mythtv | % |<br>
> | root | 127.0.0.1 |<br>
> | debian-sys-maint | localhost |<br>
> | mythtv | localhost |<br>
> | root | localhost |<br>
> +------------------+-----------+<br>
> 5 rows in set (0.00 sec)<br>
<br>
</div>that looks fine to me.<br>
<br>
i went back and looked at your original post and i noticed that you used:<br>
<div class="im"><br>
mysql> grant all on mythconverg.* to mythtv@"%" identified by "mythtv";<br>
<br>
</div>what i'm used to doing is putting both user and host in quotes or ticks a la:<br>
<div class="im"><br>
mysql> grant all on mythconverg.* to "mythtv"@"%" identified by "mythtv";<br>
<br>
</div>if you want to try this, i'd erase the current mythtv@% row from the<br>
user table first.<br></blockquote><div><br>Erased previous entry added new one with quotes. Didn't change anything. :-(<br> <br></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<font color="#888888">-peter<br>
</font><div><div></div><br></div></blockquote><div><br>--<br>Mike<br> <br></div></div>