hi,
thsi is my error ..........******SQL Query failed: Host 'seetharam-NET' is not allowed to connect to this MySQL server **********
iam using below code for remote acess for mysql
using System.Data;
using MySql.Data.MySqlClient;
protected void Button1_Click(object sender, EventArgs e)
{
string strCon = "Data Source=192.168.1.32; User Id=;password=;database=chanti;Persist Security Info=True;PORT=3306";
MySqlConnection con = new MySqlConnection(strCon);
string strSQL = "SELECT * from empdetails";
MySqlCommand cmd = new MySqlCommand(strSQL,con);
try
{
con.Open();
GridView1.DataSource = cmd.ExecuteReader();
GridView1.DataBind();
con.Close();
}
catch (Exception ex)
{
Label1.Text = "SQL Query failed: " + ex.Message;
}
satya