Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : Servlets JDBC connetion with MySql

[Joan]

I'm trying to connect to mysql with a java servlet. I get the mesage below:

java.sql.SQLException: Invalid authorization specification: Access denied for user: 'user@host' (Using password: YES) at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:278)

I don't Know how I could solve this problem.

Thanks
Joan

[kunal]

Are you using the right login and password for the mysqldbase? and dbhost is usually localhost.

[Joan]

Thanks for your answer, I'm using the username and password, and databese name I use to connect via telnet to my mysql database. What I don't know if the port I'm triyin to connect is correcctly configure to accecp my connection. How I could know if is properly configured?.

Thanks

Joan

[mpkapadia]

Joan,

I was having exactly the same problem, My servlet engine was mod jserv of apache.

Inspite of the mm.jdbc driver being in proper classpath i had this prob. Then what i did was just put the entire mm.jdbc drv into the servlets folder of the virtual host.

Then it somehow just started.

If i echoed classpath than it was showing the same in classpath even earlier,

Though this is not the right method to do it. But it works for me as of now, i have no logical reason to it though

Rgds
Manish Kapadia
Bombay-India