Comment 11 for bug 1166938

I have done a good amount of investigation on this issue since filing the bug. The issue is that workbench does not support the dialog plugin. Ubuntu workbench does work if the shared & client packages are installed. My guess is that workbench in Ubuntu uses the same library directory as mysql/percona while it does not in Windows. I'm not sure what path is used under windows. It's possible windows workbench doesn't support dynamic client plugin loading.

In any case there is a work around. Downloading the Percona or MariaDB source code and modifying auth_pam.c to reference mysql_clear_password instead of dialog and then compiling/installing. I'm not an expert in c or the mysql plugin api so I'm not sure why auth_pam_compat does not work the same.

static struct st_mysql_auth pam_auth_handler=
{
  MYSQL_AUTHENTICATION_INTERFACE_VERSION,
  "mysql_clear_password",
  &authenticate_user_with_pam_server
};

With this modified plugin command line mysql on Ubuntu, CentOS/Redhat, Windows (via 5.6 server install) and workbench on windows, mac, ubuntu as well as sequel pro on mac works. Heidi sql however fails, but does work with the plugin where dialog is used.

Possibly the auth_pam_compat plugin could be cloned from auth_pam and mysql_clear_password referenced directly instead of dialog? I'm not sure if this would break any functionality that the auth_pam_compat plugin currently offers though.