List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:December 27 1999 3:35am
Subject:Re: Refusing TCP connections from localhost.
View as plain text  
At 4:18 PM +0200 1999-12-26, <sinisa@stripped> wrote:
>Paul DuBois writes:
>  > At 3:38 PM +0200 1999-12-25, <sinisa@stripped> wrote:
>  > >Hi!
>  > >
>  > >Having host table empty is not recommendable.
>  >
>  >
>  > Why is that?  Or do you mean the db table?
>  >
>  > >
>  > >If you want to force all users to login with password, you should
>  > >delete all anonymous users, the one which have '' in user column of
>  > >the user table.
>  > >
>
>  > >If you have emptied host table, then only users which have '%' in host
>  > >column of the user table can login.
>  >
>  > host table?  Do you mean db table?
>  >
>
>No, I mean host table. If in user table host value is '%', then no
>entry in host table is required. If user has appropriate privileges in
>user table, no db entries are required.


I think you are confusing the db table with the host table.  The host
table is not used at all except in the case of db table entries that
have a blank Host column value.  It can easily be empty without repercussion
on your ability to restrict users only to certain databases.  It is
simply not true to say that "If you have emptied host table, then only
users which have '%' in host column of the user table can login."

-- 
Paul DuBois, paul@stripped
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