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: ' [EMAIL PROTECTED] ' (Using password: YES) * Message: Invalid authorization specification: Access denied for user: '[EMAIL PROTECTED] ' (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 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php