cannot connect to mysql under debian

Classic Servoy
1

I am trying to connect to mysql under debian but with no luck. I can connect to the database just fine directly through mysql or through perl, but when I attempt an auto server setup under servoy, I get the following error:

DBCP borrowObject failed: java.sql.SQLException: Unable to connect to any hosts due to exception: java.net.ConnectException: Connection refused

** BEGIN NESTED EXCEPTION **

java.net.ConnectException
MESSAGE: Connection refused

STACKTRACE:

java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
…

Any thoughts?

2

Perhaps mysql is running on a different port? Are you pointing to the right server? Did you configure mysql to accept connections from that user? If mysql is on a different box than the Servoy Developer by default mysql will not allow connections and you have to grant access to that user@that ip.