Problem with Database Connection

Question

Could you help me figure out why you’re making this mistake?

Code:

using (_connection = new MySqlConnection("Database=test;Data Source=localhost;User Id=root;Password=teste;SslMode=None;"))
{
    _connection.Open();
    var cmd = new MySqlCommand("select name from user where id=1", _connection);
    using (var reader = cmd.ExecuteReader())
    {
        if (reader.Read())
        {
            textBlock.Text = (reader.GetString("name"));
        }
    }
}

Answer 1

Add the code below before opening the connection:

System.Text.EncodingProvider ppp;
ppp = System.Text.CodePagesEncodingProvider.Instance;
Encoding.RegisterProvider(ppp);

---

Response based in that reply.