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”.下表显示了影响安全性的mysqld选项和系统变量。关于这些选项的详细描述,请参阅第5.1.7节,“服务器命令选项”和第5.1.8节,“服务器系统变量”。
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 |