List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:December 28 1999 2:30am
Subject:Re: Refusing TCP connections from localhost.
View as plain text  
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
Thread
mysql and presidential debatetpryor16 Dec
  • Re: mysql and presidential debateAsk Bjoern Hansen16 Dec
  • Re: mysql and presidential debateScott Hess16 Dec
  • Re: mysql and presidential debateSasha Pachev16 Dec
    • Re: mysql and presidential debatePeter J. Schoenster17 Dec
  • mysql and presidential debateMichael Widenius21 Dec
  • Re: mysql and presidential debatetpryor23 Dec
    • Refusing TCP connections from localhost.Jim Sander23 Dec
      • Re: Refusing TCP connections from localhost.Benjamin Pflugmann24 Dec
        • Re: Refusing TCP connections from localhost.Ed Carp24 Dec
          • Re: Refusing TCP connections from localhost.Jim Sander24 Dec
            • Re: Refusing TCP connections from localhost.Ed Carp24 Dec
              • Re: Refusing TCP connections from localhost.Jim Sander25 Dec
                • Re: Refusing TCP connections from localhost.sinisa25 Dec
                  • Re: Refusing TCP connections from localhost.Benjamin Pflugmann25 Dec
                    • Re: Refusing TCP connections from localhost.sinisa26 Dec
                      • Re: Refusing TCP connections from localhost.Benjamin Pflugmann26 Dec
                  • Re: Refusing TCP connections from localhost.Paul DuBois26 Dec
                    • Re: Refusing TCP connections from localhost.sinisa26 Dec
                      • Re: Refusing TCP connections from localhost.Paul DuBois27 Dec
                        • Re: Refusing TCP connections from localhost.sinisa27 Dec
                • Re: Refusing TCP connections from localhost.Benjamin Pflugmann25 Dec
                  • Re: Refusing TCP connections from localhost.Michael Widenius28 Dec
                    • Re: Refusing TCP connections from localhost.Jim Sander28 Dec
              • Re: Refusing TCP connections from localhost.Stephen Johnson26 Dec
RE: mysql and presidential debateTed Rolle16 Dec
  • RE: mysql and presidential debateEd Carp16 Dec
  • RE: mysql and presidential debateOrlando Andico17 Dec
    • Re: mysql and presidential debateTonu Samuel17 Dec
      • Re: mysql and presidential debateOrlando Andico17 Dec
        • Re: mysql and presidential debateTonu Samuel17 Dec
        • Re: mysql and presidential debateChristopher E. Brown17 Dec
          • Re: mysql and presidential debateOrlando Andico19 Dec
            • Re: mysql and presidential debateEd Carp19 Dec
              • Re: mysql and presidential debateOrlando Andico19 Dec
                • Re: mysql and presidential debateEd Carp19 Dec
                  • Re: mysql and presidential debateOrlando Andico19 Dec
                    • Re: mysql and presidential debateEd Carp19 Dec
                      • Re: mysql and presidential debateAaron19 Dec
                        • Re: mysql and presidential debateEd Carp19 Dec
                        • Re: mysql and presidential debateTim Bunce20 Dec
                          • Re: mysql and presidential debateAaron Abelard20 Dec
                            • Re: mysql and presidential debateMatthias Urlichs20 Dec
                            • Re: mysql and presidential debateTim Bunce20 Dec
                              • Re: mysql and presidential debateMichael Widenius22 Dec
                                • beginner questionsrepett022 Dec
                                  • Re: beginner questionsJeff Urban22 Dec
                                  • Re: beginner questionsJames Lyon22 Dec
                        • Re: mysql and presidential debateChristopher E. Brown21 Dec
                          • Re: mysql and presidential debateEd Carp21 Dec
                      • Re: mysql and presidential debateScott Hess20 Dec
                    • Re: mysql and presidential debateJan Dvorak20 Dec
              • Re: mysql and presidential debateDylan Neild20 Dec
            • Re: mysql and presidential debateChristopher E. Brown21 Dec
              • Re: mysql and presidential debateScott Hess21 Dec
                • Re: mysql and presidential debateChristopher E. Brown21 Dec
    • RE: mysql and presidential debateJeff Urban17 Dec
      • RE: mysql and presidential debateOrlando Andico17 Dec
        • RE: mysql and presidential debateMichael Widenius21 Dec
          • RE: mysql and presidential debateOrlando Andico22 Dec
RE: mysql and presidential debateTed Rolle16 Dec
RE: mysql and presidential debateEric Cholet17 Dec