Olá galera, estou iniciando meus estudos com java, mais estou esbarrando nesse infeliz problema. Estou tentando realizar a conexão com banco de dados MySQL mais toda vez eu recebo o erro de Connection Refused.
Aqui está o programa que eu fiz:
import java.sql.*;
import org.gjt.mm.mysql.Driver;
public class bancoTeste1 {
private static final String STR_DRIVER = "com.mysql.jdbc.Driver";
private static final String DATABASE = "myBase";
private static final String IP = "localhost";
private static final String STR_CON = "jdbc:mysql://" + IP + ":3306/" + DATABASE;
private static final String USER = "root";
private static final String PASSWORD = "abc123";
public static void main(String[] args){
Connection con = null;
try {
Class.forName(STR_DRIVER);
con = DriverManager.getConnection(STR_CON, USER, PASSWORD);
System.out.println("CONECTANDO");
} catch (ClassNotFoundException e) {
System.out.println("CLASS ERROR");
} catch (SQLException e) {
System.out.println("SQL ERROR"+e);
}
}
Detalhes do meu sistema:
Consigo manipular o banco de dados normalmente pelo phpMyAdmin e pelo console.
Não consigo de jeito nenhum conectar no banco de dados com o java. Ja tentei varios IPs (127.0.0.1,localhost,192.168.0.102 (meu ip de rede)), o login e a senha estão corretos, ja tentei com varios usuarios (root e outros), tambem ja tentei com a porta 3306 e sem passar porta nenhuma. Não sei mais o que fazer.
Esse é o erro que recebo:
[code]SQL ERRORcom.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.ConnectException
MESSAGE: Connection refused
STACKTRACE:
java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.(Unknown Source)
at java.net.Socket.(Unknown Source)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)
at com.mysql.jdbc.MysqlIO.(MysqlIO.java:271)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2771)
at com.mysql.jdbc.Connection.(Connection.java:1555)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at SMD.bancoTeste1.main(bancoTeste1.java:21)
** END NESTED EXCEPTION **
Last packet sent to the server was 0 ms ago.
[/code]
Grato desde ja!