Authentication problem using JDBC

[Dan Wellisch]

Hello:

I have a weird problem. I just installed Mysql 4.1.10a under my own login on my host's linux box.

I setup all the permissions for my users: usera@localhost, userb@localhost, etc.
I can start the mysql client and login for each of these users and access the proper
databases.

However, when I try to connect through JDBC, I get an authentication error.

Connecting through JDBC worked fine before when I was using my hosting company installed version of Mysql 3.23.58. One thing that was different about this configuration was that the Mysql 3.23.58 was installed on a different box than the box for which my java client running under tomcat is running.

I wonder if there is a problem since my java client is running on the same box as the mysql client as far as authentication goes. I read somewhere that localhost may not be the right hostname???

Anyone have any ideas here?

Thanks,

Dan