1、连接本地mysql数据库没问题,,,可以正常连接2、连接服务器的确不行,,,服务和我的机器在一个局域网内 连接错误如下:Error : java.sql.SQLException: null, message from server: "Host '192.168.0.29' is not allowed to connect to this MySQL server"代码如下:import java.sql.*;public class mysql {
public static void main(String args[]){
try
{
Connection conn;
Statement stmt;
ResultSet res;
//加载Connector/J驱动
//这一句也可写为:Class.forName("com.mysql.jdbc.Driver");
Class.forName("com.mysql.jdbc.Driver").newInstance();
//建立到MySQL的连接
conn = DriverManager.getConnection("jdbc:mysql://192.168.0.60:3306/sale",
"root", "123456");
//执行SQL语句
stmt = conn.createStatement();
res = stmt.executeQuery("select * from users");
//处理结果集
while (res.next())
{
String name = res.getString("name");
System.out.println(name);
}
res.close(); }
catch (Exception ex)
{
System.out.println("Error : " + ex.toString());
}
}}
public static void main(String args[]){
try
{
Connection conn;
Statement stmt;
ResultSet res;
//加载Connector/J驱动
//这一句也可写为:Class.forName("com.mysql.jdbc.Driver");
Class.forName("com.mysql.jdbc.Driver").newInstance();
//建立到MySQL的连接
conn = DriverManager.getConnection("jdbc:mysql://192.168.0.60:3306/sale",
"root", "123456");
//执行SQL语句
stmt = conn.createStatement();
res = stmt.executeQuery("select * from users");
//处理结果集
while (res.next())
{
String name = res.getString("name");
System.out.println(name);
}
res.close(); }
catch (Exception ex)
{
System.out.println("Error : " + ex.toString());
}
}}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货