<div>
Thank you for that excellent explanation - You should consider authoring a book
</div>


Thank you for that excellent explanation - You should consider authoring a book

<div>
Nah, I don't know enough about mysql to compete with the hundreds of books out there :)
</div>


Nah, I don't know enough about mysql to compete with the hundreds of books out there :)

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


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 
mysql>show grants
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?

Re:  MYSQL's  GRANT PROXY ON ''@'' TO 'root'@'localhost' impersonate or spoof? how/why?

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Security is the protection of information systems from theft or damage to the hardware, the software, and the information on them, as well as from disruption or misdirection of the services they provide. The main goal of security is protecting assets, and an asset is anything of value and worthy of protection.  Information Security is a discipline of protecting information assets from threats through safeguards to achieve the objectives of confidentiality, integrity, and availability or CIA for short. On the other hand, disclosure, alteration, and disruption (DAD) compromise the security objectives.