I have been taught that:
GRANT ALL on *.* to 'ed'@'xyz.com' identified by 'mypasswd';
grants all privileges except with grant option but since proxy on seems to be yet another privilege not included in the all or all privilege privilege what is the deal here???
however I see when I do a
another privilege I would like to better understand namely the one in the subject here:
I read the manual but please tell me you can fully digest this text in a meaningful way
I mean impersonate as in act like a legal proxy? are we talking permissions to
connect as someone else from my account if so how?
Why and how do I use this privilege and can I bestow it on another user?
what are the security considerations with this privilege?