Implement client auth switch and mysql_old_password.

See https://github.com/dimitri/pgloader/issues/95 for another use case
where supporting mixed password policies is needed.