So here is how it works on Ubuntu (and probably also on other Debian based systems).
Please note that the PAM authentication plugin is an enterprise feature.
1. Make sure the plugin is loaded
This can be done by adding the following to the mysqld section of my.cnf (Don't forget to restart). You could also use INSTALL PLUGIN to load it without restart.
plugin-load=authentication_pam.so2. Add a user which will use the plugin
3. Add a pam config file for 'mysql':
mysql> CREATE USER 'dveeden'@'localhost' IDENTIFIED WITH authentication_pam;
Query OK, 0 rows affected (0.00 sec)
Create [Read more...]