<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content=text/html;charset=iso-8859-1>
<META content="MSHTML 6.00.6000.16825" name=GENERATOR></HEAD>
<BODY id=MailContainerBody
style="PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-TOP: 15px"
bgColor=#ffffff leftMargin=0 topMargin=0 CanvasTabStop="true"
name="Compose message area">
<DIV><FONT face=Arial size=2>Thanks for all the great suggestions - I really
appreciate the help. I've checked everything suggested, and still no
dice:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Verdana size=2>1. Seems like MySQL is listening on 3306
correctly (and recall that I can login if I start mysql with the
--skip-grant-tables option, so that makes me believe that this is not a
networking issue):</FONT></DIV>
<DIV><FONT face=Verdana size=2>$ netstat -a -t -n |grep 3306 |grep
LISTEN<BR>tcp
0 0
0.0.0.0:3306
0.0.0.0:*
LISTEN<BR></DIV></FONT>
<DIV><FONT face=Verdana size=2>2. My my.cnf file has the 3306 port listed for
[client] and [mysqld]</FONT></DIV>
<DIV><FONT face=Verdana size=2></FONT> </DIV>
<DIV><FONT face=Verdana size=2><FONT face=Arial>3. I've tried both
</FONT></FONT><FONT face=Verdana size=2>mysql -u mythtv -h 192.168.50.9 -p (no
DB specified) and mysql -u mythtv -h 192.168.50.9 -p mythconverg - both yield
the same results (failure)</FONT></DIV>
<DIV><FONT face=Verdana size=2></FONT> </DIV>
<DIV><FONT face=Verdana size=2><FONT face=Arial>4. I can telnet in on 3306 just
fine (although Putty is garbling some of the chars):</FONT></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Verdana size=2><FONT face=Arial>$ telnet 192.168.5.19
3306<BR>Trying 192.168.5.19...<BR>Connected to 192.168.5.19.<BR>Escape character
is '^]'.<BR>@<BR>5.0.75-0ubuntu10.2.7k7mCCh,`,UHIt12GO5]<BR></DIV></FONT>
<DIV><FONT face=Arial>(typing enter closes the connection)</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>5. I tried to redo my grants with single
quotes:</FONT></DIV>
<DIV><FONT color=#660066>mysql> grant all on mythconverg.* to
'mythtv'@'192.168.5.%' identified </FONT>by 'mythtv'; <BR><FONT
color=#660066>mysql> flush privileges;</FONT></DIV>
<DIV><FONT color=#660066>mysql> grant all on mythconverg.* to
'mythtv'@'%.local' identified by 'mythtv'; </FONT></DIV>
<DIV><FONT color=#660066>mysql> flush privileges;<BR></FONT></DIV>
<DIV><FONT color=#660066>Still get the same error: ERROR 1045 (28000): Access
denied for user <A
href="mailto:'mythtv'@'mythtv3.local'">'mythtv'@'mythtv3.local'</A> (using
password: YES)<BR></FONT></DIV>
<DIV><FONT color=#660066>Anyone know how I can turn up some logging on the
connection so I can see what's actually
failing?</DIV></FONT></FONT></BODY></HTML>