//驱动程序名
String driver = "com.mysql.jdbc.Driver";
//url指向要访问的数据库名
String url = "jdbc:mysql://localhost:3306/test";
//mysql配置时的用户名
String user = "root";
//mysql配置时的密码
String password = "123456";
try{
//加载驱动程序
Class.forName(driver);
System.out.println("驱动加载成功");
}catch(ClassNotFoundException e){
System.out.println("找不到驱动程序");
e.printStackTrace();
}
try{
//链接数据库
Connection connection = DriverManager.getConnection(url, user, password); ------27行
if(connection != null){
System.out.println("链接成功");
}
}catch (SQLException e){
System.out.println("链接失败");
e.printStackTrace();
}
------------------------------------------------------------------
驱动加载成功
链接失败
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:927)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4689)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1304)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2486)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2519)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2304)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at First.main(First.java:27)
---------------------------------------------------------------------------
Connection connection = DriverManager.getConnection(url, user, password);
一直说这一行有问题 各种方法都试了 用户名和密码保证没有错 权限也没有问题 防火墙也关了 求大神