Analysis on disguised USER of MySQL 5.5 PROXY USER

MySQL 5.5 proxy user disguised USER analysis since MySQL 5.5 released the first version, a new record is added to the GRANT permission list: PROXY. Do not think this is the previous MySQL Proxy. In fact, this is used as a vest for users. Let's take a look at the specific usage. Here, I am using MYSQL 5.2.23. Install the plug-in. Now let's do the corresponding operation. Create a real USER first: Create proxy user now: OK. Let's exit and try this disguised USER. If the camouflage fails, the read-only variable @ proxy_user is NULL. Let's take a look at the other: OK. As you can see, you have the same permissions as the previous users. From siye's BLOG