Laurynas, even though the auth_pam_compat plugin uses mysql_clear_password for some reason it fails to work with mysql workbench. The error returned by workbench doesn't refer to cleartext or dialog. It just looks like a normal authentication failure, similar to when you type the wrong password. The auth_pam_compat plugin works properly from the command line in linux or windows though.
I assume there is something in the auth_pam code (which is missing from auth_pam_compat) that performs client/server handshaking in a way that mysql workbench expects.
Laurynas, even though the auth_pam_compat plugin uses mysql_clear_ password for some reason it fails to work with mysql workbench. The error returned by workbench doesn't refer to cleartext or dialog. It just looks like a normal authentication failure, similar to when you type the wrong password. The auth_pam_compat plugin works properly from the command line in linux or windows though.
I assume there is something in the auth_pam code (which is missing from auth_pam_compat) that performs client/server handshaking in a way that mysql workbench expects.