MySQL ERROR 1381 (HY000): You are not using binary logging [Resolved]

The following MySQL error might occur if you are using MySQL replication and binary logs.

mysql> show binary logs;
ERROR 1381 (HY000): You are not using binary logging


I have already discussed the same problem here. If you are still facing issues then it might be possibility that problem is with MySQL my.cnf file.

The my.cnf file structure for replication should be as below:

[mysqld] .



[mysqld_safe] log-error=/var/log/mysqld.log

Make sure that "log-bin" is present under mysld and not mysqld_safe, else it will not have any effect.

Restart the MySQL service.

Check by logging in the MySQL prompt:

mysql> show binary logs;
| Log_name | File_size |
| log-bin.000001 | 106 |
1 row in set (0.03 sec)

That's all!  😉

Share on Facebook0
Share on Google+5Tweet about this on TwitterShare on StumbleUpon0Share on LinkedIn0Share on Tumblr0Digg thisPin on Pinterest0Share on Reddit0Email this to someonePrint this page

About Abhijit Sandhan

Abhijit Sandhan
Loves Linux, Blogging, Traveling, Hiking and sharing knowledge!

One comment

  1. I have done all you said but can't resolv my problem... ;-(

Leave a Reply

Your email address will not be published. Required fields are marked *