Would you mind posting what you tried? Did you put single quotes around the
wildcard like '%' ?
For example: GRANT ALL ON somedb.* TO 'someuser'@'%';
Also see http://dev.mysql.com/doc/refman/5.0/en/grant.html
Cheers....Fish
On Sat, Oct 25, 2008 at 1:40 PM, Joe Auty <[EMAIL PROTECTED]> wrote:
> I'm also having this strange problem just as stated here, anybody find a
> fix for this yet?
>
> Again, using wildcards (%) for the Host don't work while the FQDN does from
> the exact same remote machine, the exact same username, etc. There is
> something about the wildcard ACL that is not working properly for this or
> any other user. I have proper forward and reverse DNS entries for this
> machine I'm connecting from.
>
> Any ideas why this might be and where I ought to look?
>
>
> 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
>>>> [EMAIL PROTECTED]
>>>> 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=1
>>>>
>>>>
>>>
>>>
>>
>> --
>> 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
>> [EMAIL PROTECTED]
>> http://www.cgps.org
>> Public key - subkeys.pgp.net
>>
>
>
>
> --
> Joe Auty
> NetMusician: web publishing software for musicians
> http://www.netmusician.org
> [EMAIL PROTECTED]
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
