Hmmm, that is strange indeed. Hopefully one of the Level 70+ MySQL Wizards on the list can explain why this might happen.
~~Fish~~ On Sat, Oct 25, 2008 at 4:44 PM, Joe Auty <[EMAIL PROTECTED]> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Fish Kungfu wrote: > | 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. > | > > I just setup the MySQL client on another machine, and was able to > connect just fine... Very odd. So: > > - - local connections as that user: fine > > - - connections from mydomain.com as that user: broken > > - - connections from mydomain.com as that user where is a specific MySQL > user permitting the FQDN of mydomain.com: fine > > - - connections from newserver.mydomain.com (the aforementioned machine I > just setup): fine > > > It's almost as if the local privileges data on mydomain.com is > conflicting or something? There was no data at all on > newserver.mydomain.com - it was a complete virgin install. > > > > > > > | 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] > |> > | > > > - -- > Joe Auty > NetMusician: web publishing software for musicians > http://www.netmusician.org > [EMAIL PROTECTED] > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.7 (Darwin) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org > > iD8DBQFJA4UjCgdfeCwsL5ERArpbAJ9dS6SEc8WOc38fyh+xdcj5B14pjgCghUCm > 1wK5q5CoIKk6A0eigyy5HzE= > =Hum0 > -----END PGP SIGNATURE----- >
