RE: GRANT'ing for localhost and %

[Christopher Book <cbook@xxxxxxx>]

>>I would tend to think that granting access to user@'%' would also allow
connections from localhost

It depends...if you connect from the local machine specifying 'localhost',
or without specifying a hostname, then mysql looks for the localhost
permission.  If you connect through the localhost, but specify the actual
hostname, it often uses the @hostname permission.
That's the way it works for me connecting via php, and from the mysql
command line, but you'll have to play around with it.

Chris


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread92263@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php