Example Analysis of MySQL 5.5 PROXY USER camouflage user

This article shows you a sample analysis of MySQL 5.5 PROXY USER camouflage users, which is concise and easy to understand. I hope you can learn something through the detailed introduction of this article.

A brief Analysis of MySQL 5.5 PROXY USER camouflage users

Since the release of the first version of MySQL 5.5, a new record has been added to the GRANT permission list: PROXY. Don't think this is the old MySQL Proxy. In fact, this is used to make vests for users. Let's take a look at the specific usage.

Here, I use MYSQL 5.2.23.

Install the plug-in

Now let's do the corresponding operation. First create a real user:

Now create the PROXY USER:

All right, let's quit and try this camouflage user. In the following figure, if the camouflage is not successful, the read-only variable @ @ proxy_user is NULL.

Let's take a look at the others:

OK . I see, it has the same permissions as the previous users.

The above is a sample analysis of MySQL 5.5 PROXY USER camouflage users. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.