content_image/796616.jpg content_image/796620.jpg content_image/796621.jpg
Default Value 

The path name of the plugin directory. 

BASEDIR/lib/plugin 

If the plugin directory is writable by the server, it may be possible for a user to write executable code to a file in the directory using SELECT ... INTO DUMPFILE . This can be prevented by making plugin_dir  read only to the server or by setting secure_file_priv  to a directory where SELECT writes can be made safely. 

• port 

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

The number of the port on which the server listens for TCP/IP connections. This variable can be set with the --port  option. 

• preload_buffer_size 

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

The size of the buffer that is allocated when preloading indexes. 

As of MySQL 8.0.26, setting the session value of this system variable is a restricted operation. The session user must have privileges sufficient to set restricted session variables. See Section 5.1.9.1, “System Variable Privileges” . 

• print_identified_with_as_hex 

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

