Witam. Próbuję się połączyć z moją bazą na serwerze myDevil.net ale wyskakują błędy przy uruchomieniu programu.
package mycarmanagementsystem;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.logging.Logger;
/**
*
* @author Grochu
*//**
*
* @author Grochu
*/
import java.util.logging.Level;
public class MyCarManagementSystem {
/**
* @param args the command line arguments
*/
public static void main(String[] args) throws SQLException {
MyCarManagementSystem mySystem = new MyCarManagementSystem();
mySystem.createConnection();
}
void createConnection() {
try{
Class.forName("com.mysql.cj.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://mysql12.mydevil.net/m1502_orders", "m1502_user", "haslo123");
System.out.println("Database connection success");
}catch(ClassNotFoundException ex){
Logger.getLogger(MyCarManagementSystem.class.getName()).log(Level.SEVERE, null, ex);
} catch (SQLException ex) {
Logger.getLogger(MyCarManagementSystem.class.getName()).log(Level.SEVERE, null, ex);
}
}
}
Oto wynik błędów:
run:
lis 23, 2019 4:41:17 PM mycarmanagementsystem.MyCarManagementSystem createConnection
SEVERE: null
java.sql.SQLException: Access denied for user 'm1502_user'@'182.134.22.253' (using password: YES)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836)
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at mycarmanagementsystem.MyCarManagementSystem.createConnection(MyCarManagementSystem.java:33)
at mycarmanagementsystem.MyCarManagementSystem.main(MyCarManagementSystem.java:28)
Connector pobrałem i dodałem do biblioteki.