Re: Refusing TCP connections from localhost.

[Michael Widenius]

Hi!

>>>>> "Benjamin" == Benjamin Pflugmann <philemon@stripped> writes:

Benjamin> Hi.
Benjamin> On Fri, Dec 24, 1999 at 07:54:08PM -0500, jim@stripped wrote:
>> > OK, then, it's not a TCP/IP problem, it's a MySQL problem.  Have you tried
>> > putting all the host names in the host table?  I wonder who MySQL thinks
>> > you are...obviously not who you think you are! ;)
>> 
>> It's not a problem of mistaken identity, from a grant table perspective
>> at least. My "host" table is completely empty since I want to force
>> everyone to use passwords all the time. (our servers are open enough to
>> warrant this) Each user (other than root) has access to exactly one
>> database, which was set up with GRANT <list> for db@localhost (and %') -
>> cut-n-pasted from the manual. 

<cut>

Could you try doing 'mysqladmin flush-hosts';  If mysqld gets a lot of
broken connections from a host in a row, it will not accept any more
connections from this hosts.  The above command will flush this table.

Just an idea...  In other cases I agree you should try what Benjamin
has suggested..

Regards,
Monty