title: Error:java.sql.SQLException: Access denied for user 'root@localhost'@'localhost' (using password: YES)
body: <p>I am USING mysql (XAMPP) on my netbeans.</p>
  
  <p>I am trying the query </p>
  
  <pre><code>GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'root' WITH GRANT OPTION; 
  </code></pre>
  
  <p>but cant't connect:</p>
  
  <pre><code>  ERROR: java.sql.SQLException:Access denied for user 'root'@'localhost'
  </code></pre>
  
  <p>Here the whole code:</p>
  
  <pre><code>    public class NextHandler implements ActionListener{
      @Override
      public void actionPerformed (java.awt.event.ActionEvent evt){
      try{
  
          String url="jdbc:mysql://localhost:3306/database2";
          String username= "root";
          String password= " ";
          Connection con=DriverManager.getConnection(url, username,password);
          Statement stat=con.createStatement();
          String Query=
          "INSERT INTO donor_info(donor_id,donor_lastname,donor_firstname,donor_middlename,donor_age,donor_weight,donor_height,donor_gender,donor_contact_number,"
                  + "medical_condition)VALUES ('"+txtdonorid.getText()+"','"+txtlname.getText()+"','"+txtfname.getText()+"','"+txtmname.getText()+"',"
                  + "'"+txtage.getText()+"','"+txtweight.getText()+"','"+txtheight.getText()+"')";
  
          stat.execute(Query);
      JOptionPane.showMessageDialog(null,"Donor Added to Database");
      txtdonorid.setText(null);
      txtlname.setText(null);
      txtfname.setText(null);
      txtmname.setText(null);
      txtage.setText(null);
      txtweight.setText(null);
      txtheight.setText(null);
  
      }
      catch (SQLException ex){
         JOptionPane.showMessageDialog(null,ex.toString());
      }
      bloodtype f=new bloodtype();
      f.setVisible(true);
      dispose();
      f.run();
      }
          }
  
  
       public void run(){
  
      //setUndecorated(true);
  
       setSize(1920, 1200);
       setLocationRelativeTo(null);
       setVisible(true);
       setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        }
  
        public static void main(String[] args) throws Exception{
        Class.forName("com.mysql.jdbc.Driver");
        donorinfo f = new donorinfo();
        f.run();
        }
        }
  </code></pre>