MySQL Workbench 6.1 for MacOS X has following issues with auth_pam_compat:
1. by default cleartext plugin is not enabled, test connection fails with error "Authentication plugin 'mysql_clear_password' cannot be loaded: plugin not enabled"
2. in order to enable cleartext plugin I started workbench as following:
> LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN=1 /Applications/MySQLWorkbench.app/Contents/MacOS/MySQLWorkbench
3. after 2 done test connection works, but real connection still doesn't. Server-side debugging shows that for test connection workbench sent correct password, while for real connection password sent is empty.
So far it looks like Workbench cannot use cleartext plugin correctly.
MySQL Workbench 6.1 for MacOS X has following issues with auth_pam_compat:
1. by default cleartext plugin is not enabled, test connection fails with error "Authentication plugin 'mysql_ clear_password' cannot be loaded: plugin not enabled"
2. in order to enable cleartext plugin I started workbench as following: ENABLE_ CLEARTEXT_ PLUGIN= 1 /Applications/ MySQLWorkbench. app/Contents/ MacOS/MySQLWork bench
> LIBMYSQL_
3. after 2 done test connection works, but real connection still doesn't. Server-side debugging shows that for test connection workbench sent correct password, while for real connection password sent is empty.
So far it looks like Workbench cannot use cleartext plugin correctly.