I would like to use LDAP authentication against a MySQL server via http://www.percona.com/doc/percona-pam-for-mysql. I'm trying to use auth_pam or auth_pam_compat on a Linux server. The Linux clients work great, but the Windows clients such as SQLyog receive an error “Client does not support authentication protocol requested by server; consider upgrading MySQL client”.
Are there any ways to get around this on SQLyog?
If the above is not possible, are there other options for LDAP authentication with Windows clients?
Thanks, yes, I think that would solve my issue too. auth_pam uses dialog.so, but auth_pam_compat uses mysql_clear_password. I was hoping to use auth_pam_compat for authentication and then use SSL connections to encrypt the transmission of the password.