List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 6 2003 5:50pm
Subject:RE: empty host in user table
View as plain text  
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.
>
>http://www.mysql.com/doc/en/Connection_access.html
>http://www.mysql.com/doc/en/Request_access.html
>
>>  -----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


-- 
Paul DuBois
http://www.kitebird.com/
sql, query
Thread
empty host in user tableThomas Walter6 May
  • RE: empty host in user tableJennifer Goodie6 May
    • RE: empty host in user tablePaul DuBois6 May
      • RE: empty host in user tableJennifer Goodie6 May
        • RE: empty host in user tablePaul DuBois6 May