mysqlbinlog — Utility for Processing Binary Log Files • --defaults-file= file_name • --defaults-group-suffix= str • --disable-log-bin ,  -D • --exclude-gtids= gtid_set • --force-if-open ,  -F • --force-read ,  -f • --get-server-public-key 608 For information about the  caching_sha2_password  plugin, see Section 6.4.1.2, “Caching SHA-2 Pluggable Authentication” . If  --server-public-key-path= file_name  is given and specifies a valid public key file, it takes precedence over  --get-server-public-key . Request from the server the public key required for RSA key pair-based password exchange. This option applies to clients that authenticate with the  caching_sha2_password  authentication plugin. For that plugin, the server does not send the public key unless requested. This option is ignored for accounts that do not authenticate with that plugin. It is also ignored if RSA-based password exchange is not used, as is the case when the client connects to the server using a secure connection. With this option, if  mysqlbinlog  reads a binary log event that it does not recognize, it prints a warning, ignores the event, and continues. Without this option,  mysqlbinlog  stops if it reads such an event. Read binary log files even if they are open or were not closed properly. Do not display any of the groups listed in the  gtid_set . This option causes  mysqlbinlog  to include a  SET sql_log_bin = 0  statement in its output to disable binary logging of the remaining output. Manipulating the session value of the  sql_log_bin system variable is a restricted operation, so this option requires that you have privileges sufficient to set restricted session variables. See Section 5.1.9.1, “System Variable Privileges” . Disable binary logging. This is useful for avoiding an endless loop if you use the  --to-last-log  option and are sending the output to the same MySQL server. This option also is useful when restoring after an unexpected exit to avoid duplication of the statements you have logged. For additional information about this and other option-file options, see Section 4.2.2.3, “Command-Line Options that Affect Option-File Handling” . Read not only the usual option groups, but also groups with the usual names and a suffix of  str . For example,  mysqlbinlog  normally reads the  [client]  and  [mysqlbinlog]  groups. If this option is given as  --defaults-group-suffix=_other ,  mysqlbinlog  also reads the  [client_other]  and [mysqlbinlog_other]  groups. For additional information about this and other option-file options, see Section 4.2.2.3, “Command-Line Options that Affect Option-File Handling” . Exception: Even with  --defaults-file , client programs read  .mylogin.cnf . Use only the given option file. If the file does not exist or is otherwise inaccessible, an error occurs. If file_name  is not an absolute path name, it is interpreted relative to the current directory.