RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX


Tip: Setting Up a PROXY User in MySQL

See how to set up a proxy user that has the same permissions as the original user.


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.


Visit the DevX Tip Bank


Sridhar M S. is a Java developer from Bangalore, India. He holds a master's degree in Computer Science.
Email AuthorEmail Author
Close Icon
Thanks for your registration, follow us on our social networks to keep up-to-date