6.1.4 Security-Related mysqld Options and Variables与安全相关的mysqld选项和变量

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安全选项和变量摘要

NameCmd-LineOption FileSystem VarStatus VarVar ScopeDynamic
allow-suspicious-udfsYesYes
automatic_sp_privilegesYesYesYesGlobalYes
chrootYesYes
local_infileYesYesYesGlobalYes
safe-user-createYesYes
secure_file_privYesYesYesGlobalNo
skip-grant-tablesYesYes
skip_name_resolveYesYesYesGlobalNo
skip_networkingYesYesYesGlobalNo
skip_show_databaseYesYesYesGlobalNo