Documentation Home
MySQL 9.1 Reference Manual
Related Documentation Download this Manual
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


MySQL 9.1 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