Mecklenburg County Chief Magistrate resigns from office