Setting Up a PROXY User in MySQL

In MySQL, a user is allowed to have a PROXY user. This means that a user can behave the same way as the original user with the same permissions as the original user.

Granting PROXY Access

GRANT PROXY ON original_user TO proxy_user

Revoking PROXY Access

REVOKE PROXY ON original_user FROM proxy_user

In both of the cases above, original_user is the user for which a PROXY is allowed. The proxy_user can imitate all permissions of the original_user.

PS: There could be specific changes in the way the commands are used based on the levels of permissions that you have.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Related Posts