MySQL 8.0 Reference Manual
MySQL 8.0 Release Notes
The following table shows mysqld options and system variables that affect security. For descriptions of each of these, see Server Command Options, and Server System Variables.
Table 2.1 Security Option and Variable Summary
| Name | Cmd-Line | Option File | System Var | Status Var | Var Scope | Dynamic |
|---|---|---|---|---|---|---|
| allow-suspicious-udfs | Yes | Yes | ||||
| automatic_sp_privileges | Yes | Yes | Yes | Global | Yes | |
| chroot | Yes | Yes | ||||
| local_infile | Yes | Yes | Yes | Global | Yes | |
| safe-user-create | Yes | Yes | ||||
| secure_file_priv | Yes | Yes | Yes | Global | No | |
| skip-grant-tables | Yes | Yes | ||||
| skip_name_resolve | Yes | Yes | Yes | Global | No | |
| skip_networking | Yes | Yes | Yes | Global | No | |
| skip_show_database | Yes | Yes | Yes | Global | No |