java 访问远程数据库 mysql_Java实现访问远程数据库的实例

代码是packagedecember21th;importjava.sql.DriverManager;importjava.sql.SQLException;importcom.sun.media.rtsp.Connection;publicclassTest{publicstaticvoidmain(String[]args){...

代码是

package december21th;

import java.sql.DriverManager;

import java.sql.SQLException;

import com.sun.media.rtsp.Connection;

public class Test {

public static void main(String[] args) {

java.sql.Connection conn = null;

try {

Class.forName("com.mysql.jdbc.Driver");

conn = DriverManager.getConnection(

"jdbc:mysql://10.21.0.245:3306/", "", "123456");

System.out.println("远程Mysql连接测试： " + conn);

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

} finally {

try {

conn.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

}

报错是

java.sql.SQLException: null, message from server: "Host '10.21.0.245' is not allowed to connect to this MySQL server

展开