Ola galera,
eu semrpe usei o mysql no windows por questoes de licensa agora vamos apssar a usar no linux, instalei o mysql5 no linux pensei q era so migar o banco e das as premissoes e tudo funcinaria, mas acho q esta rolando algum problema na hora da minha aplicação se conectar ao banco, sei q nao problema de rede pq acesso o banco de dados da maquina via sqlyog e vejo as bases de dados, teria q trocar o drive? faço a conexao do jeito a abaixo.
public static Connection getConnection() throws Exception
{
Driver d = (Driver)Class.forName ("com.mysql.jdbc.Driver").newInstance();
String URL = "jdbc:mysql://192.168.0.191:3306/hefesto";
Connection c = DriverManager.getConnection(URL, "sparc", "123");
return c;
}
e estou recebendo o erro
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'hefesto'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1031)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:894)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3823)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1256)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2032)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:729)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:283)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at Connection.MyConnection.getConnection(MyConnection.java:11)
at SQL.SQL_Register_Client.RegisterClient(SQL_Register_Client.java:29)
at Engine.SearchEngine.RegisterClient(SearchEngine.java:112)
at Engine.SearchEngine.<init>(SearchEngine.java:41)
at Exe.Run.main(Run.java:33)
grato.