List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 28 2002 4:51am
Subject:Re: Why doesn't % work?
View as plain text  
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

Thread
Why doesn't % work?Chuck \"PUP\" Payne28 Mar
  • Re: Why doesn't % work?Paul DuBois28 Mar