Documentation Home
MySQL 9.3 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.8Mb
PDF (A4) - 40.9Mb
Man Pages (TGZ) - 261.1Kb
Man Pages (Zip) - 368.3Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb


MySQL 9.3 Reference Manual  / ...  / Security  / General Security Issues  /  Security-Related mysqld Options and Variables

8.1.4 Security-Related mysqld Options and Variables

The following table showsmysqld options and system variables that affect security. For descriptions of each of these, seeSection 7.1.7, “Server Command Options”, andSection 7.1.8, “Server System Variables”.

Table 8.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