6.1.4 与安全性相关的 mysqld 选项和变量
下 table 显示了影响安全性的mysqld选项和系统变量。有关每一个的描述，请参见第 5.1.6 节“服务器命令选项”和第 5.1.7 节“服务器系统变量”。
table6.1 安全选项和变量摘要
| 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 | ||||
| des-key-file | Yes | Yes | ||||
| local_infile | Yes | Yes | Yes | Global | Yes | |
| old_passwords | Yes | Yes | Yes | Both | Yes | |
| safe-user-create | Yes | Yes | ||||
| secure_auth | Yes | Yes | Yes | Global | 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 | |
