I have. Not much time to reply, but one major thing I had to do form my notes:
4. modify my.cnf and add line with: pam_use_cleartext_plugun
requires restart!!!!
For Old Workbench to work with this, set the environment variable
LIB_MYSQL_CLEARTEXT_PLUGIN=1
For recet Workbench, in the connections dialog, on the Advanced tab, check
Enable Cleartext Authentication Plugin
Problem: Password is sent uncrypted!!!!
If
i remember correclty, nothing needs to happen on JDBC-side to get this
to work. But, I had the LIB_MYSQL_CLEARTEXT_PLUGIN=1 in the
environment. YMMV.
HTH,