<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">Been following this thread and learning a ton - thank you to all for posting in-public like this.<br><br>If I may ask a non-situation-specific question: Does this solution work because in MySQL the user 'root' can have different passwords for each location that is connecting from (localhost vs. 192.168.1.100 vs. [some IP address])?<br><br>Thanks,<br>David<br><br><br><br>--- On <b>Tue, 2/10/09, Frank Paterra <i><fcp@wittykids.com></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;">From: Frank Paterra <fcp@wittykids.com><br>Subject: Re: [Gslug-general] Stuck on what should be easy<br><br><pre>WHAAAAA HOOOOOOOO!<br><br>That was it!<br><br>Thank you, thank you, thank you!<br><br>Thank you all!<br><br>Frank<br><br>On Tue, Feb 10, 2009 at 11:10 AM, Josh Miller
<joshua@itsecureadmin.com><br>wrote:<br>> Frank Paterra wrote:<br>>><br>>> mysql> select user,host,password from mysql.user where user =<br>'root';<br>>> +------+---------------+------------------+<br>>> | user | host | password |<br>>> +------+---------------+------------------+<br>>> | root | localhost | 78901ed626334092 |<br>>> | root | 192.168.1.% | 78901ed626334092 |<br>>> | root | 127.0.0.1 | |<br>>> | root | % | 78901ed626334092 |<br>>> | root | 192.168.1.100 | |<br>>> | root | %.%.%.% | 78901ed626334092 |<br>>> +------+---------------+------------------+<br>>> 6 rows in set (0.09 sec)<br>>><br>>> Does this tell you anything interesting? It just seems to confirm<br>>> that I should have access right?<br>><br>><br>> You have multiple conflicting grants
in place. I recommend that you<br>> simplify things by removing all but root@'%'. Note that any time<br>you have<br>> anything more specific than % as a host designation you may have<br>conflicts.<br>><br>> If you connect from 192.168.1.100, it will use username root with no<br>> password. If you connect from 127.0.0.1, it will also use username root<br>> with no password.<br>><br>> YOu might try this, to normalize your passwords and provide you with a<br>> better chance:<br>><br>> update mysql.user set password = '78901ed626334092' where user =<br>'root' and<br>> password = '';<br>><br>><br>><br>> --<br>> Josh Miller, RHCE/VCP<br>> Seattle, WA<br><br></pre></blockquote></td></tr></table><br>