MySQL Java connection denied: Java.sql.SQLException:Access denied for user ' root ' @ ' * * * * (using Password:yes)

An error occurred while the system was running:
Java.sql.SQLException:Access denied for user ' root ' @ ' ***.**.**.** ' (using Password:yes)

MySQL server is deployed on Ubuntu, my public IP is my hidden error.

The following error occurred with the database management tool connection:

this is because "IP is ***.**.**.**, name is root" user does not have permission to access the database

Workaround: "The following two methods are the same principle, but the way is different"

1, if you have connected to the database through the Navicat[Database management tool], do the following:

Grant all privileges on * * to [email protected] '% ' identified by ' ****** '//*** means database connection password

2. If the Navicat database is not connected to the database, use the console to modify MySQL permissions

Here I use Xshell to connect Ubuntu system:

Complete the Modify permission with the following statement:

After the modification, connect again.

MySQL Java connection denied: Java.sql.SQLException:Access denied for user ' root ' @ ' * * * * (using Password:yes)