Re: Refusing TCP connections from localhost.

[Paul DuBois]

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