I have this code snippet where I am trying to make a connection with a remote database, located on LAN Ip with wamp.
string myConnectionString = "server=192.9.210.62;port=8088;database=testDB;uid=root;pwd=;";
MySqlConnection con = new MySqlConnection(myConnectionString);
con.Open();
MessageBox.Show("connection open");
con.Close();
But it is failing due to socket exception. here are the error
MySql.Data.MySqlClient.MySqlException: 'Reading from the stream has failed.'
Then, I search for this problem, and it seems that I have to allow a remote connection to my SQL. But remember I have already put my server online already. There is also bind-address setting that need to be set 0.0.0.0 but i am unable to find it in .ini file.