Unable to connect to any of the specified MySQL hosts.

See more:

MySQL

C#3.5

Hi All

here i try connect asp.net with online mysql , locally working good by using mysql 5 and workbench(GPL) but when i try to connect with my cpanel database i have faced prob

My Asp Coding :

protected void Page_Load(object sender, EventArgs e)
   {
       if(!IsPostBack)
       {
         string strConstr= ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
           using (MySqlConnection con = new MySqlConnection(strConstr))
           {
               using (MySqlCommand cmd = new MySqlCommand("SELECT * FROM logintb"))
               {
                   using (MySqlDataAdapter sda = new MySqlDataAdapter())
                   {
                       cmd.Connection = con;
                       sda.SelectCommand = cmd;
                       using (DataTable dt = new DataTable())
                       {
                           //Response.Write("Connection String Working");
                           sda.Fill(dt);
                           grdLogin.DataSource = dt;
                           grdLogin.DataBind();
                       }
                   }
               }
           }
       }
   }

webConfig

<add name="constr" connectionString="Server=103.14.120.89;Database=akshayag_db;Uid=aksha_DB;Pwd=root@123!;"/>

ip address from that cpanel and i have created db and table also but not working showing error in sda.Fill(dt);

like

Unable to connect to any of the specified MySQL hosts.

thanks