Eclipse : java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)

Asked Oct 08 '19 at 01:42

Active Oct 08 '19 at 01:42

Viewed 169 times

This question has been asked before but none of the solutions are working for me. I'm getting the following error

java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)

when I'm executing the following code

import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;



public class MyFirstDBConn {
    static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";  
    static final String DB_URL = "jdbc:mysql://localhost/repository";

//  Database credentials
   static final String USER = "root";
   static final String PASS = "pass";

    public static void main(String[] args) {

        try{
            System.out.println("Register the DriverManager with DB driver");


            Class.forName(JDBC_DRIVER );    

            Connection conn = DriverManager.getConnection(DB_URL, USER, PASS);

            Statement statement = conn.createStatement();

            ......
            }
    }
}

Please help.

asked Oct 08 '19 at 01:42

user1232138

5,451
8
37
64

see http://stackoverflow.com/a/15707789/2310289 – Scary Wombat Oct 08 '19 at 01:44
@ScaryWombat When I try to execute those statements, I get SQL syntax error – user1232138 Oct 08 '19 at 01:54
Pardon? What do you mean? Please show your input and errors. – Scary Wombat Oct 08 '19 at 01:56
@ScaryWombat When I try to excute this statement `grant all privileges on repository.* to 'Cortana'@'localhost' identified by 'pass';` I get `Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'identified by 'pass'' at line 1` – user1232138 Oct 08 '19 at 01:58
What version of mysql are you using? – Scary Wombat Oct 08 '19 at 02:02
@ScaryWombat 8.0 – user1232138 Oct 08 '19 at 02:02
Follow the syntax as per https://dev.mysql.com/doc/refman/8.0/en/grant.html – Scary Wombat Oct 08 '19 at 02:04
@ScaryWombat That's what I'm trying. Do you think there is something wrong with this statement `grant all privileges on repository.* to 'Cortana'@'localhost' identified by 'pass';` – user1232138 Oct 08 '19 at 02:06
maybe lose the `identified..` bit – Scary Wombat Oct 08 '19 at 02:08
@ScaryWombat What do you mean by loose – user1232138 Oct 08 '19 at 02:09
See duplicate link – Scary Wombat Oct 08 '19 at 02:10
@ScaryWombat Now it says `Error Code: 1410. You are not allowed to create a user with GRANT` – user1232138 Oct 08 '19 at 02:12
As per the link, *Starting with MySQL 8 you no longer can (implicitly) create a user using the GRANT command. Use CREATE USER instead, followed by the GRANT statement:* – Scary Wombat Oct 08 '19 at 02:13
@ScaryWombat Still not working – user1232138 Oct 08 '19 at 02:21
*Still not working* - Again, Please show your input and errors. – Scary Wombat Oct 08 '19 at 02:26
@ScaryWombat I'm still getting the same error as the one mentioned above in the post. – user1232138 Oct 08 '19 at 02:31
Make sure you sql is running on default port 3306 else add the port info in the url and verify that the username and password is correct and user have access to the db – Ravik Oct 08 '19 at 02:43

Eclipse : java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)

0 Answers0