At 10:38 -0700 5/6/03, Jennifer Goodie wrote:
>An empty host in the user table means that permissions get anded with the
The db table, not the user table.
>appropriate entry in the hosts table. We use this method because our server
>set up is very complicated, it seems most people don't. I do not know what
>the expected action would be if the hosts table is empty. I don't think
>that scenerio is a standard set up. The following two pages go into detail
>on how mySQL uses the grant tables to decide what a user can do. Reading
>them should answer your questions.
>> -----Original Message-----
>> From: Thomas Walter [mailto:Thomas.Walter@stripped]
>> Sent: Tuesday, May 06, 2003 5:22 AM
>> To: mysql@stripped
>> Subject: empty host in user table
>> I use the grant tables in the following way:
>> The host and db table are empty.
>> Most of the users are supposed to be able to connect from any host so
>> for most users the host colunm in the user table is set to '%'.
>> Accidently, it happened that in some user table's rows the host name has
>> been set to '' (empty name) by an application's bug or a faulty
>> administrator's action.
>> Now it seems to me that the empty host name '' is treated the same way
>> as '%', i.e. a user with en empty host name can connect from any host.
>> Is this true? If yes: Is this the intentional use of empty host names?
>> Thanks for any help,
> > Thomas