Unanswered: java.sql.SQLException: Communication failure during handshake.
I am running windows2000 with a tomcat apache server. I have donwloaded and installed mysql4.1. I am trying to access the database via a java application runnning on the tomcat server. Both the tomcat server and the mysql server are running on the same computer.
java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306?
is the error I am getting, I know the server is running as when I perform a netstat and I get
TCP localhost:3306 localhost:2906 ESTABLISHED
TCP localhost:3306 localhost:2907 TIME_WAIT
this only exists when the server is running. I used the installation tool that came with the mySQL server to set up the server and the root password is set to my password.