该楼层疑似违规已被系统折叠隐藏此楼查看此楼
navicat可以连上mysql，在cmd中mysql也可以正常使用，但是eclipse连接不上mysql，报错Exception in thread "main" java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)，mysql是8.0.13，jdbc驱动是8.0.13的，代码：
package com.imooc.db;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
//连接数据库
public class DBUtil {
private static final String URL = "jdbc:mysql://localhost:3306/imooc? useSSL=false&useUnicode=true&characterEncoding=UTF8&serverTimezone=GMT";
public static void main(String[] args) throws Exception {
//1.加载驱动程序，反射的方式，
Class.forName("com.mysql.cj.jdbc.Driver");
//2.获得数据库连接
//三个参数：数据库地址，用户名，密码
Connection conn = DriverManager.getConnection(URL, "root", "root");
//3.通过数据库的连接操作数据库，实现增删改查创建Statement对象
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select user_name, age from imooc_gooddess");
while(rs.next()) {
System.out.println(rs.getString("user_name") + "," + rs.getInt("age"));
}
}
}
