Simple mysql c#

using (var connection = new MySqlConnection("Server=localhost;Database=MyDatabaseName;Uid=root;Pwd=;"))
using (var command = connection.CreateCommand()) {
    connection.Open();
    command.CommandText = "select id, name from widgets";

    using (var reader = command.ExecuteReader())
        while (reader.Read())
            Console.WriteLine(reader.GetString(0) + ": " + reader.GetString(1));
}