Sto sperimentando la gestione di DB con java. Ho caricato correttamente il driver per MySql. Poi con il seguente codice mi vorrei connettere al db (si noti che al posto di mioDb e miaPass ho messo i valori corretti e che test è il nome del mio db):
codice:
try {
            con = DriverManager.getConnection("jdbc:mysql://87.3.235.149/test?user=mioDB&password=miaPass");
            stmt = con.createStatement();
            stmt.executeUpdate(createString);
            stmt.close();
            con.close();

        } catch(SQLException ex) {
            System.err.println("SQLException: " + ex.getMessage());
        }

La connessione non avviene e ricevo questo output:

codice:
---------- run ----------
SQLException: Unable to connect to any hosts due to exception: java.net.SocketException: java.net.SocketException: Connection reset by peer: connect

** BEGIN NESTED EXCEPTION ** 

java.net.SocketException
MESSAGE: java.net.SocketException: Connection reset by peer: connect

STACKTRACE:

java.net.SocketException: java.net.SocketException: Connection reset by peer: connect
	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:143)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:225)
	at com.mysql.jdbc.Connection.createNewIO(Connection.java:1805)
	at com.mysql.jdbc.Connection.<init>(Connection.java:452)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)
	at java.sql.DriverManager.getConnection(DriverManager.java:525)
	at java.sql.DriverManager.getConnection(DriverManager.java:193)
	at CreateCoffees.main(CreateCoffees.java:24)


** END NESTED EXCEPTION **


Normal Termination
Output completed (21 sec consumed).