Prompt java.sql.SQLException:Access denied for user ' root ' @ ' desktop-n2b2d9a ' (using password:yes) when connecting to MySQL

When you connect to MySQL with root: Access is denied

Check to see if MySQL server is on and the background is running.

Then we checked the MySQL user table and found that root can only be run using local IP (localhost or 127.0.0.1) to connect

Workaround: Open a new permission GRANT all privileges on * * to ' root ' @ '% ' identified by ' JEFFW ' with GRANT OPTION;

Then query: SELECT * from user;

The newly opened Root has already opened the permission, through the code can successfully run again.

Prompt java.sql.SQLException:Access denied for user ' root ' @ ' desktop-n2b2d9a ' (using password:yes) when connecting to MySQL