<div class="gmail_quote">On Mon, May 17, 2010 at 7:40 PM, Michael Tiller <span dir="ltr"><<a href="mailto:michael.tiller@gmail.com">michael.tiller@gmail.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;">
<div class="gmail_quote"><div class="im">On Mon, May 17, 2010 at 5:13 PM, Peter Abplanalp <span dir="ltr"><<a href="mailto:pta-myth@psaconsultants.com" target="_blank">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></div></blockquote><div><br>I cleared out some of the unwanted hosts, etc. I used mysql-admin to add "anywhere" host (%) and then I gave it all privileges. Now that command returns:<br>
<br>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>Also, I didn't notice this before by MythTV has its own special "include" in the mysql config file that does a "bind-address = 0.0.0.0" which seems to be what I want (I assume that means accept connection on any interface) so that should rule out that issue.<br>
<br>Nevertheless, when I do this:<br><br><div style="margin-left: 40px;"><span style="font-family: courier new,monospace;">mtiller@mythtv:/var/log/mysql$ <b>mysql -h192.168.11.110 -umythtv -p</b></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">Enter password: </span><br></div><br>I still get<br><br><div style="margin-left: 40px;"><span style="font-family: courier new,monospace;">ERROR 1045 (28000): Access denied for user 'mythtv'@'192.168.11.110' (using password: YES)</span><br>
</div><br>even though "-hlocalhost works".<br><br>--<br>Mike<br><br><br><br></div></div>