Yes, I did "FLUSH PRIVILEGES" and I think I only have one username/host
entry for this user.

Adam


Erik Giberti wrote:
> Did you "FLUSH PRIVILEGES"?
> I'd also check that the username and passwords are the same for each
> host entry, I've had problems if passwords were different for a shared
> username from different hosts.
>
> On Apr 24, 2008, at 8:58 AM, Adam Gerson wrote:
>
>> I set up a user and entered % for the host. I am not able to connect.
>> However, if I change the host value to my FQDN it works fine.
>> Shouldn't the wildcard allow me to connect from any host?
>>
>> Thanks,
>> Adam
>>
>>
>> --
>> Adam Gerson
>> Assistant Director of Technology
>> Apple Certified System Administrator (ACSA)
>> Columbia Grammar and Prep School
>> phone. 212-749-6200 ex. 321
>> fax. 212-428-6806
>> agerson@cgps.org
>> http://www.cgps.org
>> Public key - subkeys.pgp.net
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql?unsub=giberti@mac.com
>>
>
>


--
Adam Gerson
Assistant Director of Technology
Apple Certified System Administrator (ACSA)
Columbia Grammar and Prep School
phone. 212-749-6200 ex. 321
fax. 212-428-6806
agerson@cgps.org
http://www.cgps.org
Public key - subkeys.pgp.net