<div class="gmail_quote">OK, I solved it...<br><br>On Tue, May 18, 2010 at 8:49 AM, Peter Abplanalp <span dir="ltr"><<a href="mailto:pta-myth@psaconsultants.com">pta-myth@psaconsultants.com</a>></span> wrote:<br><br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><a href="http://forums.mysql.com/read.php?34,161843,194399#msg-194399" target="_blank">http://forums.mysql.com/read.php?34,161843,194399#msg-194399</a><br>
<br>
can you test from another host on your network? perhaps the mysql<br>
client is smart enough to figure out it is on localhost and uses the<br>
socket instead of the network port.<br>
<br>
an easy way to test just connectivity is to 'telnet <hostname/ip><br>
3306'. if you get a connection with some garbled text, your network<br>
config is ok.<br></blockquote><div><br>Tried this. Everything works great. Not a network connectivity issue. Thanks for the tip since this allowed me to eliminate that possibility.<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;">
i'd also try a 'select * from mysql.user where user = "mythtv"' and<br>
look for any differences.<br></blockquote><div><br>This turned out to be the key. The password fields were different. I assumed that the password was tied to the username alone. Even using mysql-admin, this seemed to be the case. But looking at the table itself the password fields (or at least their hashes) were different. So, I changed the username for all "mythtv" users with:<br>
<br><div style="margin-left: 40px;"><span style="font-family: courier new,monospace;">use mysql;</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">update user set password=PASSWORD("MYPASSWORD") where user='mythtv';</span><br style="font-family: courier new,monospace;">
</div><br>and now it works perfectly. Thanks for the help.<br><br>I'm still puzzled about a couple of things:<br><ul><li>Why have I never had this problem before?</li><li>Why did this suddenly stop working? (I had everything configured previously, just fine). About the only thing I can think of is that an update came through and messed it up.</li>
</ul>--<br>Mike<br><br></div></div>