users@glassfish.java.net

Re: mysql - rmi access of datasource = access denied

From: <glassfish_at_javadesktop.org>
Date: Fri, 11 Jan 2008 06:08:31 PST

This seems to be more of a mysql setup related issue as you are able to do lookup of a datasource configured for Oracle.

Could this be due to user permission for MySQL ?
MySQL requires access permission for users as well the client machine names/ip where the user is connecting from.

http://dev.mysql.com/doc/refman/5.0/en/adding-users.html

 GRANT ALL PRIVILEGES ON *.* TO '<USER>'@'<HOST/IP>' IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

should help to grant the permission.

Thanks,
-Jagadish
[Message sent by forum member 'jr158900' (jr158900)]

http://forums.java.net/jive/thread.jspa?messageID=253413