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

Tip of the Day
Language: SQL
Expertise: Intermediate
Jun 14, 2019

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.

M S Sridhar
Close Icon
Thanks for your registration, follow us on our social networks to keep up-to-date