Security in MySQL  /  General Security Issues  /  Security-Related mysqld Options and Variables

2.4 Security-Related mysqld Options and Variables

The following table shows mysqld options and system variables that affect security. For descriptions of each of these, see Server Command Options, and Server System Variables.

Table 2.1 Security Option/Variable Summary

NameCmd-LineOption FileSystem VarStatus VarVar ScopeDynamic
automatic_sp_privileges Yes GlobalYes
local_infile Yes GlobalYes
old_passwords Yes BothYes
secure-authYesYes GlobalYes
- Variable: secure_auth Yes GlobalYes
secure-file-privYesYes GlobalNo
- Variable: secure_file_priv Yes GlobalNo
skip-name-resolveYesYes GlobalNo
- Variable: skip_name_resolve Yes GlobalNo
skip-networkingYesYes GlobalNo
- Variable: skip_networking Yes GlobalNo
skip-show-databaseYesYes GlobalNo
- Variable: skip_show_database Yes GlobalNo

Download this Excerpt
PDF (US Ltr) - 1.2Mb
PDF (A4) - 1.2Mb
EPUB - 366.5Kb
HTML Download (TGZ) - 284.8Kb
HTML Download (Zip) - 294.6Kb
User Comments
Sign Up Login You must be logged in to post a comment.