Geronimo DB Pool only working with 'root'

[ken abe]

Hi All!

I'm running Geronimo 2.0.2 and trying to configure a connection pool to use MySQL with a non-root user and my apps fail to get a working connection. (The same works when I provide 'root' and the MySQL root password in the pool configuration)
Please note:
- the non-root user I created can connect and use MySQL without any problems when I connect using any other MySQL client (command-line, Navicat, MySQL Query Browser, etc...)
- I made sure permissions are granted to <user>@localhost
- I also added <user>@<hostname> and <user>@127.0.0.1 and also <user>@% but without success

Thank you in advance for any pointers...