amritha O

amritha O

  • NA
  • 16
  • 24.7k

Error happens when my application uploads to server

Jan 13 2011 4:59 AM
hi all

I purchase server space and upload my application to it.Database (iam using MySQL ) also.Its working fine but when taking some pages error like this appearing which works well i n my local system.
Error is
MySql.Data.MySqlClient.MySqlException: SELECT command denied to user 'mydbname'@'122.172.119.128' for table 'employeedetails'
   at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
   at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
   at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at dboperation.GetDataTable(String qry) in c:\myapps\App_Code\dboperation.cs:line 101}


Thanks in advance

Answers (1)