MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0 Command-Line Options that Affect Option-File Handling

Most MySQL programs that support option files handle the following options. Because these options affect option-file handling, they must be given on the command line and not in an option file. To work properly, each of these options must be given before other options, with these exceptions:

When specifying file names as option values, avoid the use of the ~ shell metacharacter because it might not be interpreted as you expect.

Table 4.3 Option File Option Summary

Option Name Description
--defaults-extra-file Read named option file in addition to usual option files
--defaults-file Read only named option file
--defaults-group-suffix Option group suffix value
--login-path Read login path options from .mylogin.cnf
--no-defaults Read no option files