连接到mysql数据库失败

Question

当我尝试执行以下代码以在文本框中输入值时，出现一个错误:使用方法'mysql_native_password‘对用户'’的主机'‘进行身份验证失败，并显示消息:用户''@'Adam-PC’的访问被拒绝(使用密码: NO)

公有子TextBox1_TextChanged(发送者作为对象，e作为EventArgs)处理Datetxt.TextChanged Dim ConnectionString作为字符串Dim con作为新MySqlConnection

    ConnectionString = "server=localhost;user id=root;database=river_data;allowuservariables=True"";Integrated Security=True;MultipleActiveResultSets=True;"

    Dim cmd As MySqlCommand
    Dim query As String = "SELECT date FROM river-derwent-keswick-portinscale WHERE(`date` = '01.01.2013') "
    cmd = New MySqlCommand(query, con)
    con.Open()

    Dim myreader As MySqlDataReader = cmd.ExecuteReader()
    If myreader.Read() Then
        Datetxt.Text = myreader.GetValue(0)
    Else
        Me.Close()
        HomeForm.Show()
    End If
    myreader.Close()

Answer 1

ConnectionString = "server=localhost;user id=root;database=river_data;allowuservariables=True"";Integrated Security=True;MultipleActiveResultSets=True;"

看起来用户部分是错误的。尝试：

ConnectionString = "server=localhost;user=root;database=river_data;allowuservariables=True"";Integrated Security=True;MultipleActiveResultSets=True;"