The following table shows mysqld options and system variables that affect security. For descriptions of each of these, see Section 5.1.7, “Server Command Options”, and Section 5.1.8, “Server System Variables”.
Table 6.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 |