dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


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

WEBINAR:

On-Demand

Building the Right Environment to Support AI, Machine Learning and Deep Learning


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
 
Thanks for your registration, follow us on our social networks to keep up-to-date