使用Pomelo.EntityFrameworkCore.MySql v6从网络上的另一个设备连接时出错

Question

MySqlConnector.MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts.
at MySqlConnector.Core.ServerSession.ConnectAsync(ConnectionSettings cs, MySqlConnection connection, Int32 startTickCount, ILoadBalancer loadBalancer, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 433
at MySqlConnector.Core.ConnectionPool.ConnectSessionAsync(MySqlConnection connection, String logMessage, Int32 startTickCount, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ConnectionPool.cs:line 363
at MySqlConnector.Core.ConnectionPool.GetSessionAsync(MySqlConnection connection, Int32 startTickCount, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ConnectionPool.cs:line 94
at MySqlConnector.Core.ConnectionPool.GetSessionAsync(MySqlConnection connection, Int32 startTickCount, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ConnectionPool.cs:line 124
at MySqlConnector.MySqlConnection.CreateSessionAsync(ConnectionPool pool, Int32 startTickCount, Nullable`1 ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlConnection.cs:line 915
at MySqlConnector.MySqlConnection.OpenAsync(Nullable`1 ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlConnection.cs:line 406
at MySqlConnector.MySqlConnection.Open() in /_/src/MySqlConnector/MySqlConnection.cs:line 369
at Microsoft.EntityFrameworkCore.ServerVersion.AutoDetect(String connectionString)
at MadaSoft.AddDbContextHostBuilderExtensions.<>c__DisplayClass1_0.<GetMySql>b__0(DbContextOptionsBuilder o) in D:VS ProjectsMadaProjectMadaSoftHostBuilderAddDbContextHostBuilderExtensions.cs:line 32
at MadaSoft.ContextFactoryApp.CreateDbContext() in D:VS ProjectsMadaProjectMadaSoft_DbContextContextFactoryApp.cs:line 19
at MadaSoft.App.MigrateContextApp() in D:VS ProjectsMadaProjectMadaSoftApp.xaml.cs:line 63
at MadaSoft.App.OnStartupTask() in D:VS ProjectsMadaProjectMadaSoftApp.xaml.cs:line 55
at MadaSoft.App.OnStartup(StartupEventArgs e) in D:VS ProjectsMadaProjectMadaSoftApp.xaml.cs:line 35

您按照以下方式注册服务

Action<DbContextOptionsBuilder> configureDbContext = o =>
{
o.UseMySql(connectionString,ServerVersion.AutoDetect(connectionString));
o.UseQueryTrackingBehavior(QueryTrackingBehavior.NoTracking);
}; 
services.AddDbContext<ContextApp>(configureDbContext);
services.AddSingleton(new ContextFactoryApp(configureDbContext));

当从同一台计算机连接时，连接是正确的。但是当从另一台计算机连接时，出现问题

这是连接字符串服务器=主机;端口= 3306;数据库= dbName;Uid =根;Pwd =根;sslmode =没有;

CharSet = use utf8;

Answer 1

感谢stackoverflow成员。我一直在努力，直到找到了答案。错误是由于使用默认用户(root)。我在数据库引擎中创建了一个新用户，并赋予它权限。和在在在在好的祝辞祝辞祝辞问题已修复