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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
