Bug #76847 The proxy user does not take effect in 5.6.21-log Community
Submitted: 27 Apr 2015 8:54 Modified: 12 Mar 2016 5:09
Reporter: WANG GUANGYOU Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.6.21 OS:Linux (Centos 6.3 X86)
Assigned to: CPU Architecture:Any
Tags: proxy

[27 Apr 2015 8:54] WANG GUANGYOU
Description:
Hi 
   I want to add a proxy user to the account. I try it in MySQL Server 5.6.21 in the following.
CREATE USER 'proxy'@'localhost' IDENTIFIED WITH test_plugin_server AS 'proxy';
CREATE USER 'proxied'@'localhost' IDENTIFIED BY 'proxied';
GRANT PROXY ON 'proxied'@'localhost' TO 'proxy'@'localhost';
FLUSH PRIVILEGES;

Then I connect server from localhost by the following command. 
mysql -uproxy -pproxy

However, It seems that it does not take effect.
mysql> SELECT @@proxy_user;                                                                                                                                            +--------------+
| @@proxy_user |
+--------------+
| NULL         |
+--------------+
1 row in set (0.00 sec)

is it a bug or  misused it ?

How to repeat:
see description

Suggested fix:
No
[12 Mar 2016 5:09] MySQL Verification Team
Hello WANG,

Thank you for the report.
I'm not seeing this issue at my end. Also, the value is NULL if proxying is not used. Otherwise, it indicates the proxy user account.

If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.
Thank you for your interest in MySQL.

Thanks,
Umesh