4.2.7 Command-Line Options that Affect Option-File Handling

Most MySQL programs that support option files handle the following options. They affect option-file handling, so 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, you should avoid the use of the ~ shell metacharacter because it might not be interpreted as you expect.