How to know if MySQL binary log is enabled through SQL command?

to know if MySQL binary log is enabled through SQL command, you can use show variables command.

The syntax is as follows

show variables like ‘yourPatternValue’;

In place of ‘yourPatternValue’, you can use log_bin to check the binary log is enabled using SQL command show.

The query is as follows

mysql> show variables like 'log_bin';

The following is the output that displays whether it is enabled or not

+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_bin       | ON    |
+---------------+-------+
1 row in set (0.03 sec)

Arjun Thakur

Published on 16-Jan-2019 12:13:01

• Related Questions & Answers
• Show MySQL host via SQL Command?
• How to redirect if JavaScript is not enabled in a browser?
• Is INNODB enabled by default in MySQL?
• How to enable MySQL Query Log?
• What is the use of update command in SQL?
• How do I know if a MySQL table is using myISAM or InnoDB Engine?
• How do I know which MongoDB version is installed using the Command Line?
• How can I to know if my database MongoDB is 64 bits?
• How can we transfer information between MySQL and data files through command line?
• Checking if a button is enabled or disabled in SAP Application
• How to check if Location Services are enabled in iOS App?
• How to check if Location Services are enabled in Android App?
• How can we establish MySQL database by using MySQL binary at command prompt?
• How to find out if the GPS of an Android device is enabled or not?
• How to know if your child have allergy symptoms?