Mysql-access denied for user ' username ' @ ' localhost ' (using Password:yes) Resolution

When you save a new MySQL user with navicat, you are prompted to Access denied for user ' username ' @ ' localhost ' (using Password:yes):

Workaround:

Please log in to MySQL using the root account and execute the following command line:

1. MySQL creates a new user, username username, password is password, change localhost to% allows the user to log on to all hosts
   CREATE USER ' username ' @ ' localhost ' identified by ' password ';
2. To authorize this user, this example grants all permissions to the user, and you can change all privileges to a specific permission option.
   *. * represents all data tables under all databases, or can be specified as specific database tables
   GRANT all privileges on *. * to ' username ' @ ' localhost ' with GRANT OPTION
3. Authorization to take effect

FLUSH privileges;

You can log in again.

Mysql-access denied for user ' username ' @ ' localhost ' (using Password:yes) Resolution