Just to clarify why I believe this is happening. For these Grants:
GRANT PROXY ON 'dtest'@'localhost' TO 'proxy'@'localhost';
GRANT USAGE ON *.* TO 'proxy'@'localhost';
The GRANT USAGE is for the `proxy`@`localhost` user and not the parent user `dtest`@`localhost`;
Just to clarify why I believe this is happening. For these Grants: @'localhost' ; @'localhost' ;
GRANT PROXY ON 'dtest'@'localhost' TO 'proxy'
GRANT USAGE ON *.* TO 'proxy'
The GRANT USAGE is for the `proxy`@`localhost` user and not the parent user `dtest` @`localhost` ;
Proxy User was set up using mysql's test authentication plugin, process described here: http:// dba.stackexchan ge.com/ questions/ 526/can- you-su- in-mysql/ 4708#4708