MySQL Forums
Forum List  »  General

Re: Access denied for user 'root'@'localhost' (using password: YES)
Posted by: Peter Brawley
Date: May 26, 2021 12:10PM


am using root@localhost to log in to MySQL workbench.

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql -u root -p

That's not WorkBench you're logging into, it's the mysql commandline client program.


java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException( ~[mysql-connector-java-8.0.23.jar:8.0.23]

Let's see the result, once you've logged in to the commandline client, of ...

select host,authentication_string,plugin from mysql.user
where user='root';

Options: ReplyQuote

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.