c# - MySql.Data.MySqlClient.MySqlException :“Access denied for user ' hobo' @'49.70.207.34'(使用密码 : YES)”

Question

我想使用EntityFramework Core为IdentityServer4配置和操作数据。我使用Mysql。执行以下代码时发生错误。代码是"serviceScope.ServiceProvider.GetRequiredService<PersistedGrantDbContext>().Database.Migrate();"错误是

MySql.Data. MySqlClient. MySqlException: 'Access denied for user 'seen' @ '49.70.207.34' (using password: YES)' error.

但是我不知道地址49.70.207.34来自哪里，在我配置的数据库连接字符串中是另一个地址；我的连接字符串是'server=47......;database=IdentityServer4.Configuration;user=hobo;password=123456'.

Answer 1

您可以尝试这个方法

导入MySql.Data.MySqlClient

Public cn As New MySqlConnection()

Public Sub openconnection()
    If cn.State <> ConnectionState.Open Then
        cn.ConnectionString = "Server=website.com; Database=YourDatabaseName; Uid=YourUsername; Pwd=YourPassword"
        cn.Open()
    End If
End Sub

Public Sub closeconnection()
    cn.Close()
End Sub

结束模块