The chancellor of California State University has resigned after being accused of mishandling sexual misconduct allegations.