Re: Access to Table from any Host on Internet

[Ron Parker]

GRANT SELECT ON DB.TABLE TO serf@'%' IDENTIFIED BY 'readonly';

I did "flush privileges", but still can't  acess DB.TABLE with 'serf' 
unless I use GRANT statement that includes hostname of client from which 
I am executing command.  I get this error using "serf@'%'":

* connect() SQLException: java.sql.SQLException: Invalid authorization 
specification: Access denied for user: ' serf@stripped ' (Using 
password: YES)
* Message: Invalid authorization specification: Access denied for user: 
'serf@stripped ' (Using password: YES)
* SQLState: 28000
* Vendor Info: 1045

I don't get an error if I use, with the same password: "serf@'myhost.com'"

Anything else I should be looking at?  Thanks.

-ron


-- 
Ron Parker
Software Creations            http://www.scbbs.com
Civil War Online Library      http://civilwar.scbbs.com
VSB Interest Group            http://vsb.scbbs.com