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

Asked Jun 19 '18 at 07:15

Active Jun 20 '18 at 11:58

Viewed 801 times

im trying to connect to mysql db with java, but im getting this error, "Access denied for user 'root'@'localhost' (using password: YES)" im using mysql 5.7V i tried by changing the password, cleaning the project and more but not solved

i tried this also but didn't work

GRANT ALL PRIVILEGES ON * . * TO 'root'@'localhost'

my code:

Class.forName("com.mysql.jdbc.Driver");  
                Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/vikas","root","rass");

edited Jun 20 '18 at 11:58

BalusC

1,082,665
372
3,610
3,555

asked Jun 19 '18 at 07:15

vicky

1,021
2
7
7

see http://stackoverflow.com/a/15707789/2310289 You need to GRANT privilges – Scary Wombat Jun 19 '18 at 07:15
i tried Grant Privilges but it gives warning as: 0 row(s) affected, 1 warning(s): 1287 Using GRANT statement to modify existing user's properties other than privileges is deprecated and will be removed in future release. Use ALTER USER statement for this operation. – vicky Jun 19 '18 at 07:25
Yeah, but did it work? – Scary Wombat Jun 19 '18 at 07:27
no showing the same error – vicky Jun 19 '18 at 07:28
Please show the command that you ran – Scary Wombat Jun 19 '18 at 07:30
grant all privileges on vikas.* to root@localhost identified by 'rass'; – vicky Jun 19 '18 at 07:33
See https://stackoverflow.com/a/20070276/2310289 or try `mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';` and then `FLUSH PRIVILEGES` – Scary Wombat Jun 19 '18 at 07:37
They assume that the user already exists – Scary Wombat Jun 19 '18 at 07:38
i tried alter user command but got same error, i didn't get this error before it worked fine, suddenly after sometime i again run the program without changing anything and not created other user also but getting this error – vicky Jun 19 '18 at 08:41

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

0 Answers0