I think I see the typo. If that's an exact copy & paste of your GRANT statement, then the problem is the spaces in the database designation:
You have: GRANT ALL PRIVILEGES ON * . * TO....etc But it should be: GRANT ALL PRIVILEGES ON *.* TO....etc There shouldn't be any spaces in the *.* part. I hope this fixes it for you. Cheers....Fish -------------------- ~ Second Life addict On Sat, Oct 25, 2008 at 3:15 PM, Joe Auty <[EMAIL PROTECTED]> wrote: > Fish Kungfu wrote: > >> 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 >> >> > Sure! > > On what I'll call "mynewserver" > > CREATE USER 'testuser'@'%' IDENTIFIED BY '***'; > > GRANT ALL PRIVILEGES ON * . * TO 'testuser'@'%' IDENTIFIED BY '***' WITH > GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 > MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; > > > FLUSH PRIVILEGES ; > > > $ mysql -h mynewserver -u testuser -p > Enter password: <I entered the password> > ERROR 1045 (28000): Access denied for user 'testuser'@'myoldserver' (using > password: YES) > > > > > > >> >> 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] >>> >>> >>> >> > > -- > Joe Auty > NetMusician: web publishing software for musicians > http://www.netmusician.org > [EMAIL PROTECTED] >
