In my website, I am using MySQL database. I am using a webservice where in I do all my database related manipulations.

Now In one of the methods of that webservice, I get the following Error.

&gt; select command denied to user &#39;\&lt;userid&gt;&#39;@&#39;\&lt;ip-address&gt;&#39; for table &#39;\&lt;table-name&gt;&#39;

What could be wrong?

Below is the code where I get that error. I tried debugging and found that it fails at the line

`MySqlDataReader result1 = command1.ExecuteReader();`

Here is my code:

            String addSQL = &quot;Select Max(`TradeID`) from `jsontest`.`tbl_Positions&quot;;
            MySqlConnection objMyCon = new MySqlConnection(strProvider);
            objMyCon.Open();
            MySqlCommand command = objMyCon.CreateCommand();

            command.CommandText = addSQL;
             MySqlDataReader result = command.ExecuteReader();
            //int j = command.ExecuteNonQuery();
             while (result.Read())
             {
                 MaxTradeID = Convert.ToInt32(result[0]);
             }
            objMyCon.Close();
            for (i = 1; i &lt;= MaxTradeID; i++)
            {
                String newSQL = &quot;Select `Strike`,`LongShort`,`Current`,`TPLevel`,`SLLevel` from `json`.`tbl_Position` where `TradeID` = &#39;&quot; + i + &quot;&#39;&quot;;
                MySqlConnection objMyCon1 = new MySqlConnection(strProvider);
                objMyCon1.Open();
                MySqlCommand command1 = objMyCon1.CreateCommand();

                command1.CommandText = newSQL;
                MySqlDataReader result1 = command1.ExecuteReader();
               objMyCon2.Close();



All Mysqldatareader Solutions on Gang of Coders

Total of 1 Mysqldatareader Solutions

Error: select command denied to user '<userid>'@'<ip-address>' for table '<table-name>'