MYSQL ERROR 1045 (28000): Access denied for user ' neeky ' @ ' Nee ' (using Password:yes)

Case

Mysql-h 192.168.1.7-u Neeky-p would have been able to connect to the MySQL service,

But it will report the mistake. "ERROR 1045 (28000): Access denied for user ' neeky ' @ ' Nee ' (using Password:yes)"

Workaround

First step: Log in with the root user to change the host of the neeky corresponding row in the Mysql.user table to%

1, Mysql-uroot-p

2, use MySQL;

3. Update user Set host = '% ' where user = ' Neeky ';

Step two: Restart the MySQL service

1. net stop MySQL

2. net start MySQL

Summarize:

To here the problem is not solved, also said can use Neeky user login.

MYSQL ERROR 1045 (28000): Access denied for user ' neeky ' @ ' Nee ' (using Password:yes)