At 9:50 AM -0400 5/17/01, Dave Carter wrote:
>We wanted users to be able to connect to a particular db remotely. Which
>would mean we would have to change their host to "%" This worked fine, but
>when we did that, we could not connect locally. In order to connect locally,
>we to create another user with the host value of localhost to get into the
>db. I took "%" to mean from ANY host??? Am I mistaken or is this a bug?
Not a bug, but it's a confusing scenario that happens often. Check to see
if you have any anonymous-user entries in the user table (entries with
the empty string in the user column: SELECT * FROM user WHERE user = '').
If do, delete them and FLUSH PRIVILEGES.
If you have my book, this is explained in "A Privilege Puzzle, Part I",
page 429, and "A Privilege Puzzle, Part II", pages 464-465.
>
>Version mysql : 3.22.33
>Linux Version : Cobalt 6.0 (RH 6.0)
>
>Dave Carter
>Chief Web Architect
>Accelerated Business Technologies, Inc.
>http://www.abti.cc
>717.464.2970
>
>
>---------------------------------------------------------------------
>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 <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Paul DuBois, [EMAIL PROTECTED]
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php