mysql - 用户 "@' localhost' 的访问被拒绝(使用密码 : no)

Question

我正在尝试连接到我的数据库，但我的访问被拒绝，请帮助我

String query= "SELECT * FROM id ";
     try{

       Class.forName("com.mysql.jdbc.Driver").newInstance();
       Connection con=(Connection)DriverManager.getConnection("jdbc:mysql://localhost:3306/xiiip,root,student");
      Statement stmt=con.createStatement();
      ResultSet rs=stmt.executeQuery(query);
      while (rs.next())
       {
           int a=rs.getInt("rollno");
           String b=rs.getString("name");
            int c=rs.getInt("Maths");
            int d=rs.getInt("eng");
            int e=rs.getInt("ip");
            model.addRow(new Object[] {a,b,c});        
      }

       }
       catch (ClassNotFoundException | InstantiationException | IllegalAccessException | SQLException e) {
            JOptionPane.showMessageDialog(this,e.getMessage());
        }

Answer 1

更改此行

Connection con=(Connection)DriverManager.getConnection("jdbc:mysql://localhost:3306/xiiip,root,student");

至

Connection con=(Connection)DriverManager.getConnection("jdbc:mysql://localhost:3306/xiiip'', root,student);

因为 root 是用户名，student 是密码..数据库的名称是xiiip..
引用api文档.. https://docs.oracle.com/javase/7/docs/api/java/sql/DriverManager.html