PDF (US Ltr)
- 40.4Mb
PDF (A4)
- 40.5Mb
Man Pages (TGZ)
- 259.5Kb
Man Pages (Zip)
- 366.7Kb
Info (Gzip)
- 4.1Mb
Info (Zip)
- 4.1Mb
The following table shows mysqld options and system variables that affect security. For descriptions of each of these, see Section 7.1.7, “Server Command Options”, and Section 7.1.8, “Server System Variables”.
Table 8.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 |