mysqlbinlog — Utility for Processing Binary Log Files Do not read any option files. If program startup fails due to reading unknown options from an option file, --no-defaults  can be used to prevent them from being read. The exception is that the  .mylogin.cnf  file is read in all cases, if it exists. This permits passwords to be specified in a safer way than on the command line even when  --no-defaults  is used. To create .mylogin.cnf , use the  mysql_config_editor  utility. See Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility” . For additional information about this and other option-file options, see Section 4.2.2.3, “Command-Line Options that Affect Option-File Handling” . Skip the first  N  entries in the log. Specify the number of open file descriptors to reserve. The password of the MySQL account used for connecting to the server. The password value is optional. If not given,  mysqlbinlog  prompts for one. If given, there must be  no space  between  --password=  or -p  and the password following it. If no password option is specified, the default is to send no password. Specifying a password on the command line should be considered insecure. To avoid giving the password on the command line, use an option file. See Section 6.1.2.1, “End-User Guidelines for Password Security” . To explicitly specify that there is no password and that  mysqlbinlog  should not prompt for one, use the --skip-password  option. The directory in which to look for plugins. Specify this option if the  --default-auth  option is used to specify an authentication plugin but  mysqlbinlog  does not find it. See Section 6.2.17, “Pluggable Authentication” . The TCP/IP port number to use for connecting to a remote server. Print the program name and all options that it gets from option files. For additional information about this and other option-file options, see Section 4.2.2.3, “Command-Line Options that Affect Option-File Handling” . Print table related metadata from the binary log. Configure the amount of table related metadata binary logged using  binlog-row-metadata . • --no-defaults • --offset= N ,  -o  N • --open-files-limit= N • --password[= password ] ,  -p[ password ] • --plugin-dir= dir_name • --port= port_num ,  -P  port_num • --print-defaults • --print-table-metadata 610