content_image/683945.jpg content_image/683946.jpg
<img src='content_image/683945.jpg'>

The maximum number of characters permitted in random passwords generated for CREATE USER , ALTER USER , and SET PASSWORD  statements. For more information, see Random Password Generation. 

• group_concat_max_len 

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

The maximum permitted result length in bytes for the GROUP_CONCAT()  function. The default is 1024. 

• have_compress 

YES  if the zlib  compression library is available to the server, NO  if not. If not, the COMPRESS()  and UNCOMPRESS()  functions cannot be used. 

• have_dynamic_loading 

YES  if mysqld  supports dynamic loading of plugins, NO  if not. If the value is NO , you cannot use options such as --plugin-load  to load plugins at server startup, or the INSTALL PLUGIN  statement to load plugins at runtime. 

• have_geometry 

YES  if the server supports spatial data types, NO  if not. 

• have_openssl 

This variable is a synonym for have_ssl . 

As of MySQL 8.0.26, have_openssl  is deprecated and subject to removal in a future MySQL version. For information about TLS properties of MySQL connection interfaces, use the tls_channel_status table. 

• have_profiling 

YES  if statement profiling capability is present, NO  if not. If present, the profiling  system variable controls whether this capability is enabled or disabled. See Section 13.7.7.31, “SHOW PROFILES Statement” . 

