时间戳

首页 > 解决方案 > MySQL SELECT 命令拒绝用户 - MySql.Data.EntityFrameworkCore

c# - MySQL SELECT 命令拒绝用户 - MySql.Data.EntityFrameworkCore

问题描述

我正在使用第三方托管服务。

他们为我提供了一个 MySQL 数据库和一个用户。

我正在运行这个简单的查询

SELECT * FROM db_a4b20a_reales.properties_residental;

我遇到了一些奇怪的情况，当尝试从 MySQL Workbench 运行此查询时它可以工作，但是当我尝试从我的 .Net Core 2.2 应用程序运行它时，我收到以下错误：

SELECT command denied to user 'a4b20a_reales'@'{the server ip...}' for table 'properties_residental'
       at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
--- End of stack trace from previous location where exception was thrown ---
   at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteAsync(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable`1.AsyncEnumerator.BufferlessMoveNext(DbContext _, Boolean buffer, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable`1.AsyncEnumerator.MoveNext(CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.EntityQueryModelVisitor.AsyncSelectEnumerable`2.AsyncSelectEnumerator.MoveNext(CancellationToken cancellationToken)
   at System.Linq.AsyncEnumerable.SelectEnumerableAsyncIterator`2.MoveNextCore(CancellationToken cancellationToken)
   at System.Linq.AsyncEnumerable.AsyncIterator`1.MoveNext(CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.AsyncLinqOperatorProvider.ExceptionInterceptor`1.EnumeratorExceptionInterceptor.MoveNext(CancellationToken cancellationToken)
   at System.Linq.AsyncEnumerable.Aggregate_[TSource,TAccumulate,TResult](IAsyncEnumerable`1 source, TAccumulate seed, Func`3 accumulator, Func`2 resultSelector, CancellationToken cancellationToken)
   at SouthRealEstate.DAL.RealEstateDbServices.GetAllResidentalPropertiesAsync() in C:\omri\work\projects\gitRepo\RealEstateProfessional\SouthRealEstate.DAL\RealEstateDbServices.cs:line 56

更新：

使用时它正在工作MySql.Data.MySqlClient，似乎问题出在MySql.Data.EntityFrameworkCore(8.0.16)连接器上

标签： c#mysqlentity-frameworkasp.net-core

解决方案

替换为Pomelo.EntityFrameworkCore.MySql而不是MySql.Data.EntityFrameworkCore(8.0.16).

推荐阅读