Java能连上数据库不,java配置驱动成功,但是连不上数据库

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

package windowbuilder;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

public class Driverdemo {

public static final String DBDRIVER="com.mysql.jdbc.Driver";

public static final String DBURL="jdbc:mysql://localhost:3306/student";

public static final String DBUSER="root";

public static final String DBPASS="root";

public static void main(String[] args) {

Connection conn=null;

try {

Class.forName(DBDRIVER);

}catch(ClassNotFoundException e) {

e.printStackTrace();

}

try {

conn=DriverManager.getConnection(DBURL, DBUSER, DBPASS);

}catch(SQLException e) {

e.printStackTrace();

}

System.out.println(conn);

try {

conn.close();

}catch(SQLException e) {

e.printStackTrace();

}

}

}

控制台:

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

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)

at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1095)

at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2031)

at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:718)

at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:46)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

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:282)

at java.sql.DriverManager.getConnection(DriverManager.java:664)

at java.sql.DriverManager.getConnection(DriverManager.java:247)

at windowbuilder.Driverdemo.main(Driverdemo.java:21)

Exception in thread "main" java.lang.NullPointerException

at windowbuilder.Driverdemo.main(Driverdemo.java:27)

null

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值