Host '192.168.1.5' is not allowed to connect to this MySQL server

[Senthil V]

Hi,

Im trying to connect the MySQL Database from ASP.NET web application to another machine. Im unable to connect that machine using MySQL Workbench.

Connection String:
------------------
<connectionStrings>
<add name="MySqlDBConnection" providerName="MySql.Data.MySqlClient" connectionString="Server=192.168.1.5,Port=3306;database=databasename;Character Set=utf8;User id=root;password=password;"/>
</connectionStrings>

I gave permission to the database im trying to connect as below
mysql> use mysql; // also i gave to current database im connection
mysql> GRANT ALL ON *.* to root@'192.168.1.5' IDENTIFIED BY 'password';
mysql> FLUSH PRIVILEGES;

Please let me know what went wrong in connecting to the database from my ASP.NET application, but the application is connecting by using local MySQL database.

Thnks,
Senthil.