Why doesn't % work?

2002-03-27 Thread Chuck \PUP\ Payne

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?

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




Re: Why doesn't % work?

2002-03-27 Thread 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   |
  | [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