java - 我有 mysql 连接问题，尽管我使用相同的参数连接到命令行

Question

这个问题已经有答案了:

Exception in thread "main" java.sql.SQLException: Access denied for user ''@'localhost' (using password: NO) (1 个回答)

已关闭 2 年前。

 static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";  
       static final String DB_URL = "jdbc:mysql://localhost:3306/gestionrh";

   //  Database credentials
   static final String USER = "root";
   static final String PASS = "root";
   // connection 
   private Connection conx;

   // requete pour le dialogue
   private Statement stm;

   private void getConnection() {
       try {
        Class.forName(this.JDBC_DRIVER);

        conx = DriverManager.getConnection(DB_URL,USER,PASS);

        stm = conx.createStatement();

    } catch (ClassNotFoundException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();

    } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }

   }

这是异常(exception)

Exception in thread "main" java.sql.SQLException: Access denied for user ''@'localhost' (using password: NO) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:835) at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:455) at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240) at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199) at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677) at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:251) at com.mysql.cj.jdbc.admin.TimezoneDump.main(TimezoneDump.java:70)

Answer 1

该错误表明 root 使用密码NO 的访问被拒绝。这意味着以下内容是不正确的:

1. 用户名
2. 密码
3. 数据库名称