<!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 size=2><FONT face=Verdana color=#000000>> I'm wondering if mySQL
is matching on a different rule that doesn't <BR>> allow your client in
before it gets to the ones you added to allow it.</FONT></FONT></DIV>
<DIV><FONT face=Verdana size=2></FONT> </DIV>
<DIV><FONT face=Verdana size=2>...</FONT></DIV>
<DIV><FONT face=Verdana size=2></FONT> </DIV>
<DIV><FONT size=2><FONT face=Verdana color=#000000>> I agree... let's take a
look at that user table: <BR>> <BR></FONT><FONT face=Verdana
color=#000000>> mysql> use mysql; <BR>> mysql> select
User,Host,Password from user where User like '%myth%'; <BR>> mysql> select
User,Host,Db from db where User like '%myth%'; </FONT></FONT></DIV>
<DIV><FONT face=Verdana color=#000000 size=2></FONT> </DIV>
<DIV><FONT face=Verdana color=#000000 size=2>Good idea - here it is (I masked
the password data):</FONT></DIV>
<DIV><FONT face=Verdana color=#660066 size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>mysql> select User,Host,Password from user where
User like
'%myth%';<BR>+--------+----------------------+-------------------------------------------+<BR>|
User |
Host
|
Password
|<BR>+--------+----------------------+-------------------------------------------+<BR>|
mythtv |
localhost |
*abunchofstuff|<BR>| mythtv |
%
| *abunchofstuff|<BR>| mythtv |
192.168.50.% |
*abunchofstuff|<BR>| mythtv | desktop.local | *abunchofstuff|<BR>| mythtv |
%.local
|
*abunchofstuff|<BR>+--------+----------------------+-------------------------------------------+<BR>5
rows in set (0.04 sec)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>mysql> select User,Host,Db from db where User
like '%myth%';<BR>+--------+----------------------+-------------+<BR>|
User |
Host
| Db
|<BR>+--------+----------------------+-------------+<BR>| mythtv |
%
| mythconverg |<BR>| mythtv |
%.local
| mythconverg |<BR>| mythtv |
192.168.5.% | mythconverg |<BR>|
mythtv | desktop.local | mythconverg |<BR>| mythtv |
localhost |
mythconverg |<BR>+--------+----------------------+-------------+<BR>5 rows in
set (0.00 sec)<BR></FONT></DIV>
<DIV><FONT face=Arial size=2><FONT face=Verdana>In reading the MySQL docs, it
should evaluate each line until it finds a match. So it should get to the
mythtv/%,which should be evaluated and accepted. Perhaps as a test I should
remove everything but the mythtv/% line? Since this is a system table, I'm a
little squeamish about doing that with my knowledge of SQL, so any tips on a
recommended way to do that would be
appreciated...</FONT></DIV></FONT></BODY></HTML>