There are 2 issues here
1. Setting an empty value for the connection pool. While creating the pool in GUI, i do not face a trouble creating the pool with an empty password. But while pinging or setting a password with empty string, i get the "No Password Credential found" and "Property password cannot be removed" errors respectively. This seems to be a bug that was raised sometime back :
https://glassfish.dev.java.net/issues/show_bug.cgi?id=912.
2. The access denied is got as there are no privileges for the user. You should try to grant privileges using
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '' ;
to connect from any host. Please refer
http://dev.mysql.com/doc/refman/5.0/en/adding-users.html for more information on GRANT.
On a generic note, asadmin create-password-alias command can be used to create an alias for your database password.
HTH,
Shalini.
[Message sent by forum member 'sm157516' (sm157516)]
http://forums.java.net/jive/thread.jspa?messageID=321248