mysql.proxies_priv Table

The mysql.proxies_priv table manages proxy user privileges, defining which accounts are authorized to proxy as other users.

1. PARTITION BY SYSTEM_TIME is not supported for transaction-precise system-versioned tables. Attempting

The mysql.proxies_priv table contains information about proxy privileges. The table can be queried and although it is possible to directly update it, it is best to use GRANT for setting privileges.

This table uses the Aria storage engine.

The mysql.proxies_priv table contains the following fields:

Field	Type	Null	Key	Default	Description
Host	char(60)	NO	PRI
User	char(80)	NO	PRI
Proxied_host	char(60)	NO	PRI
Proxied_user	char(80)	NO	PRI
With_grant	tinyint(1)	NO		0
Grantor	char(141)	NO	MUL
Timestamp	timestamp	NO		CURRENT_TIMESTAMP

The Acl_proxy_users status variable indicates how many rows the mysql.proxies_priv table contains.

_{This page is licensed: CC BY-SA / Gnu FDL}