Question

java连接mysql 异常 sqlException

java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2847)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:750)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3558)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1151)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1768)
at com.mysql.jdbc.Connection.<init>(Connection.java:430)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.tarena.ems.util.ConnectionFactory.getConnection(ConnectionFactory.java:54)
at com.tarena.ems.util.ConnectionFactory.main(ConnectionFactory.java:63)
Con=>null
数据库是例如我在里面建了create database test 那个test么?

Answer 1

没有连接上
public String connMySQLDateBase(String ip , String prot , String datebase ,
String username , String password){
try {
String driverName="org.gjt.mm.mysql.Driver";
String url="jdbc:mysql://"+ip+":"+prot+"/"+datebase;
Class.forName(driverName);
System.out.println("load driver success");
DriverManager.getConnection(url,username,password);
return "恭喜,连接MySQL数据库成功！";
} catch (Exception e) {
return "连接出现异常";
}

}

Answer 2

检查一下你的url最后写的数据库对么.再检查一下你的密码正确么
数据库就是那个create database test;
你的url应该是jdbc:mysql:///test

Answer 3

应该是用户名密码不正确

Answer 4

估计是 数据库名错误了 数据库名 应该是 test

Answer 5

连接出错，检查下用户名和密码