// Metadata created by nebel
//

[id="enable-query-log-events-for-cdc_{context}"]
= Enabling query log events for {prodname}

You might want to see the original `SQL` statement for each binlog event. Enabling the `binlog_rows_query_log_events` options in the MySQL configuration file allows you to do this.

NOTE: This options is only available from MySQL 5.6 and later.

.Prerequisites

* You must have a MySQL server.
* You must know basic SQL commands.
* You must have access to the MySQL configuration file.

.Procedure

. Enable `binlog_rows_query_log_events`:
[source,SQL]
----
mysql> binlog_rows_query_log_events=ON
----

== Options explained

[cols="3,7"]
|===
|Permission/item |Description

|`binlog_rows_query_log_events``
a| Boolean which enables/disables support for including the original `SQL` statement in the binlog entry.

* `ON` = enabled
* `OFF` = disabled

|===
