At 23:37 -0500 3/27/02, Chuck \"PUP\" Payne wrote:
>Hi,
>
>I have set up a user call FooBar and I have set up the host that FooBar can
>access from %, but everytime I go to a different machine I get an error that
>FooBar can't access mysql from that machine IP address. Why isn't the
>wildcard (%) working?

Delete the records from the user table that have blank User fields:

DELETE FROM mysql.user WHERE User = '';
FLUSH PRIVILEGES;

Then try again.

>
>I am using 3.23.44 with mysql-max. Any clues would be great. Thanks.
>
>
>  ----------------------------
>  | Chuck Payne              |
>  | Magi Design and Support  |
>  | www.magidesign.com       |
>  | [EMAIL PROTECTED]   |
>  ----------------------------
>
>BeOS, Macintosh 68K, Classic, and OS X, Linux Support.
>Web Design you can afford.
>
>"Never be bullied into silence. Never allow yourself to be made a victim.
>Accept no one's definition of your life; define yourself."- Harvey Fierstein
>
>sql


---------------------------------------------------------------------
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

Reply via email to