Bug #74377 empty processlist for proxy user
Submitted: 14 Oct 2014 12:58 Modified: 19 Nov 2015 17:30
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Pluggable Authentication Severity:S3 (Non-critical)
Version:5.6.21 OS:Any
Assigned to: CPU Architecture:Any
Tags: authentication, Enterprise, PAM

[14 Oct 2014 12:58] Daniël van Eeden
Description:
The processlist is empty for a proxied user.

mysql> show processlist;
Empty set (0.00 sec)

mysql> select * from information_schema.processlist;
Empty set (0.00 sec)

I would expect to see my own processes.

How to repeat:
create user ''@'' identified with authentication_pam AS 'mysql, pamgrp=mysqlusr';
create user 'mysqlusr'@'localhost' identified by 'my_secret';
GRANT PROXY ON 'mysqlusr'@'localhost' TO ''@'';

Login as some user in the pamgrp group.
[19 Nov 2015 17:30] Georgi Kodinov
thank you for taking the time to report this problem.