Documentation Home
MySQL 5.6 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 30.6Mb
PDF (A4) - 30.8Mb
PDF (RPM) - 30.1Mb
EPUB - 7.7Mb
HTML Download (TGZ) - 7.5Mb
HTML Download (Zip) - 7.5Mb
HTML Download (RPM) - 6.4Mb
Eclipse Doc Plugin (TGZ) - 8.2Mb
Eclipse Doc Plugin (Zip) - 10.1Mb
Man Pages (TGZ) - 200.3Kb
Man Pages (Zip) - 311.6Kb
Info (Gzip) - 2.9Mb
Info (Zip) - 2.9Mb
Excerpts from this Manual

MySQL 5.6 Reference Manual  /  ...  /  Security-Related mysqld Options and Variables

6.1.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 Section 5.1.3, “Server Command Options”, and Section 5.1.4, “Server System Variables”.

Table 6.1 Security Option/Variable Summary

NameCmd-LineOption FileSystem VarStatus VarVar ScopeDynamic
allow-suspicious-udfsYesYes
automatic_sp_privileges Yes GlobalYes
chrootYesYes
des-key-fileYesYes
local_infile Yes GlobalYes
old_passwords Yes BothYes
safe-user-createYesYes
secure-authYesYes GlobalYes
- Variable: secure_auth Yes GlobalYes
secure-file-privYesYes GlobalNo
- Variable: secure_file_priv Yes GlobalNo
skip-grant-tablesYesYes
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


User Comments
Sign Up Login You must be logged in to post a comment.