content_image/793374.jpg
Whether to enable automatic activation of all granted roles when users log in to the server: 

•If activate_all_roles_on_login  is enabled, the server activates all roles granted to each account at login time. This takes precedence over default roles specified with SET DEFAULT ROLE . 

•If activate_all_roles_on_login  is disabled, the server activates the default roles specified with SET DEFAULT ROLE , if any, at login time. 

Granted roles include those granted explicitly to the user and those named in the mandatory_roles system variable value. 

activate_all_roles_on_login  applies only at login time, and at the beginning of execution for stored programs and views that execute in definer context. To change the active roles within a session, use SET ROLE . To change the active roles for a stored program, the program body should execute SET ROLE . 

• admin_address 

<img src='content_image/793374.jpg'>

The IP address on which to listen for TCP/IP connections on the administrative network interface (see Section 5.1.12.1, “Connection Interfaces” ). There is no default admin_address  value. If this variable is not specified at startup, the server maintains no administrative interface. The server also has a bind_address  system variable for configuring regular (nonadministrative) client TCP/IP connections. See Section 5.1.12.1, “Connection Interfaces” . 

If admin_address  is specified, its value must satisfy these requirements: 

•The value must be a single IPv4 address, IPv6 address, or host name. 

•The value cannot specify a wildcard address format ( * , 0.0.0.0 , or :: ). 

•As of MySQL 8.0.22, the value may include a network namespace specifier. 

An IP address can be specified as an IPv4 or IPv6 address. If the value is a host name, the server resolves the name to an IP address and binds to that address. If a host name resolves to multiple IP addresses, the server uses the first IPv4 address if there are any, or the first IPv6 address otherwise. 

The server treats different types of addresses as follows: 

•If the address is an IPv4-mapped address, the server accepts TCP/IP connections for that address, in either IPv4 or IPv6 format. For example, if the server is bound to ::ffff:127.0.0.1 , clients can connect using --host=127.0.0.1  or --host=::ffff:127.0.0.1 . 

