[Original] MySQL5.5PROXYUSER disguise user

Since MySQL5.5 released its first version, a new record is added to the GRANT permission list: PROXY. Do not think this is the previous MySQLProxy. In fact, this is used as a vest for users. Let's come

Since MySQL5.5 released its first version, a new record is added to the GRANT permission list: PROXY. Do not think this is the previous MySQLProxy. In fact, this is used as a vest for users. Let's come

Since MySQL 5.5 released its 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 use MYSQL 5.2.23.

Install plug-ins

Now let's do the corresponding operation. Create real users first:

Create a proxy user:

Now, let's quit and try this disguised user. If the disguise fails, the Hong Kong server and the Hong Kong server, then the read-only variable @ proxy_user is NULL.

Let's take a look at other:

OK. As you can see, you have the same permissions as the previous users.

This article is from "god, let's see it !" Blog, please keep this source

, Hong Kong server