Mysql alter table AUTO_INCREMENT = 0

int Contatore = 0;
            Query = "ALTER TABLE tb_temporary AUTO_INCREMENT = @contatore";
            gesdb.AlterCounter(Query, conn, Contatore); 

public void AlterCounter(string Query, MySqlConnection MyConn2, int contatore)
       {
           try
           {
               MyConn2 = Connection;

               if (MyConn2.State != ConnectionState.Open)
               {
                   MyConn2.Open();
               }

               MySqlCommand cmd = new MySqlCommand(Query, MyConn2); //assegna MySqlCommand

               cmd.Parameters.AddWithValue("@contatore", contatore);

               //trs = MyConn2.BeginTransaction();
               //cmd.Transaction = trs;
               try
               {
                   cmd.ExecuteNonQuery();
                   //trs.Commit();
               }
               catch
               {
                   //trs.Rollback();
               }
           }
           catch
           {

           }
       }