Re: Why doesn't % work?

[Paul DuBois]

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       |
>  | cepayne@stripped   |
>  ----------------------------
>
>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