Try MySQL migration Tool Kit:
http://downloads.mysql.com/archives.php?p=mysql-migration-toolkit[
^]
Also validate why to move frpm the article below:
http://dev.mysql.com/tech-resources/articles/move_from_microsoft_SQL_Server.html[
^]
Check your connection string:
<add name="connstring" connectionString="server=192.168.1.2;User Id=root;Persist Security Info=True;database=test;password=password" providerName="MySql.Data.MySqlClient"/>
Then your code should look like:
using (MySqlConnection dbConn = new MySqlConnection(ConfigurationManager.ConnectionStrings["connstring"].ConnectionString))
{
}