MySql.Data.MySqlClient.MySqlException：“拒绝用户'hobo'@'49.70.207.34‘的访问(使用密码:YES)”

Question

我想使用EntityFramework核心来配置和运行IdentityServer4.I 4的操作数据。我使用了Mysql.An错误，在执行下面的code.The代码是"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

终端模块