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

 for ' Root '@'***.**.**.**' (using password:yes)

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

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

Workaround:

Connect to the database via Navicat and perform the following:

Grant all privileges on * * to [email protected]'%'root'

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