Re: Access denied for user 'root'@'localhost' (using password: YES)

[Peter Brawley]

Quote

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.

Quote

java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[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';