mysql_auth_flex will allow an user to login with the native password,
and will fallback to PAM (asking for the cleartext password).