当我的应用程序上传到服务器时发生错误 [英] Error happens when My application uploads to server

问题描述

大家好，

我购买了服务器空间，并将我的应用程序上载到了数据库和数据库(我正在使用MySQL).它工作正常，但是在浏览某些页面时，会出现类似这样的错误，在我的本地系统中效果很好.
错误是:

Hi all,

I purchased server space and uploaded my application to it and database (I am using MySQL) also. It''s working fine but when taking some pages, an error like this is appearing which works well in 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

推荐答案

您需要授予用户访问权限.
MySQL的语法可用在此处

You will need to grant the user access.
The syntax for MySQL is available yhere

这篇关于当我的应用程序上传到服务器时发生错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！