Comment 2 for bug 1521481

Using binary tar ball testing

1) startup command

/home/ramesh/Percona-Server-5.6.25-rel73.1-d0661a9.Linux.x86_64-debug/bin/mysqld --no-defaults --core-file --innodb_buffer_pool_size=2147483648 --basedir=/home/ramesh/Percona-Server-5.6.25-rel73.1-d0661a9.Linux.x86_64-debug --tmpdir=/home/ramesh/Percona-Server-5.6.25-rel73.1-d0661a9.Linux.x86_64-debug/data --datadir=/home/ramesh/Percona-Server-5.6.25-rel73.1-d0661a9.Linux.x86_64-debug/data --socket=/home/ramesh/Percona-Server-5.6.25-rel73.1-d0661a9.Linux.x86_64-debug/socket.sock --port=12894 --log-error=/home/ramesh/Percona-Server-5.6.25-rel73.1-d0661a9.Linux.x86_64-debug/log/master.err 2>&1 &

2) remove anonymous users

delete from mysql.user where user='';

3) Install PAM plugin and create plam plugin user.

INSTALL PLUGIN auth_pam SONAME 'auth_pam.so';
CREATE USER ''@'' IDENTIFIED WITH auth_pam AS 'xyz, pam_db1=db1_dev';
flush privileges;

4) Run mysql -A -umytest -S/home/ramesh/Percona-Server-5.6.25-rel73.1-d0661a9.Linux.x86_64-debug/socket.sock test -p

PAM configuration

$ cat /etc/pam.d/mysqld
auth required pam_warn.so
auth required pam_unix.so audit
account required pam_unix.so audit
$

Attached strace info