MYSQL_FIREWALL_WHITELIST 表提供了 MySQL 企业防火墙内存数据缓存的视图。它列出了已注册防火墙账户配置文件的允许列表规则。它与提供防火墙数据持久存储的 mysql.firewall_whitelist 系统表结合使用;参见 MySQL 企业防火墙表。The MYSQL_FIREWALL_WHITELIST table
provides a view into the in-memory data cache for MySQL Enterprise Firewall. It lists
allowlist rules of registered firewall account profiles. It is
used in conjunction with the
mysql.firewall_whitelist system table that
provides persistent storage of firewall data; see
MySQL Enterprise Firewall Tables.
MYSQL_FIREWALL_WHITELIST 表具有以下列:The MYSQL_FIREWALL_WHITELIST table
has these columns:
USERHOST账户配置文件名称。每个账户名称的格式为
。The account profile name. Each account name has the formatuser_name@host_name.user_name@host_nameRULE一个规范化的语句,指示该配置文件可接受的语句模式。配置文件允许列表是其规则的并集。A normalized statement indicating an acceptable statement pattern for the profile. A profile allowlist is the union of its rules.
此表已弃用,并可能在未来的 MySQL 版本中移除。请参阅 将账户配置文件迁移到组配置文件。This table is deprecated and subject to removal in a future MySQL version. See Migrating Account Profiles to Group Profiles.