asp.net - HOST 192.168.--- not allowed to connect Mysql server

Question

Currently I am using VS 2010 and MySQL Workbench, but when I run the code I see this error:

'Host 'localhost' is not allowed to connect to this MySQL server'.

I have installed MySQL Workbench in Windows Server 2012 r2, when I tried to login using IP address I am getting error like

Host xxx is not allowed to connect to this MYSQL server.

Answer 1

Thats a security issue i think.

Please recreate new user on the mysql database.

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' WITH GRANT OPTION;

CREATE USER 'username'@'%' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;

FLUSH PRIVILEGES;

After that, please restart MYSQL Services.