> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/set-commands/set-sql_log_bin.md).

# SET SQL\_LOG\_BIN

## Syntax

```bnf
SET [SESSION] sql_log_bin = {0|1}
```

## Description

Sets the [sql\_log\_bin](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md#sql_log_bin) system variable, which disables or enables [binary logging](/docs/server/server-management/server-monitoring-logs/binary-log.md) for the current connection, if the client has the `SUPER` [privilege](/docs/server/reference/sql-statements/account-management-sql-statements/grant.md). The statement is refused with an error if the client does not have that privilege.

Note that setting `sql_log_bin=1` has no effect if [log\_bin](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md#log_bin) variable, which enables global binary logging, is not set.

{% tabs %}
{% tab title="Current" %}
You cannot set `sql_log_bin` as a global variable.
{% endtab %}

{% tab title="< 5.6 / 5.5" %}
You can set `sql_log_bin` as a global variable. This is considered dangerous, though, as it can damage replication.
{% endtab %}
{% endtabs %}

<sub>*This page is licensed: GPLv2, originally from*</sub> [<sub>*fill\_help\_tables.sql*</sub>](https://github.com/MariaDB/server/blob/main/scripts/fill_help_tables.sql)

{% @marketo/form formId="4316" %}