how to know if mysql binary log is enable through sql command?

Question

I have a mysql instance running and I want to know if binary log is enable for that instance without logging into the machine and check my.cnf file. Is there a way to do that?

Thanks, Sean

Answer 1

After login Execute the following command

SHOW BINARY LOGS

If there is no binary logs then you will get a message similar to 'You are not using binary logging'

Answer 2

SELECT * from information_schema.GLOBAL_VARIABLES WHERE VARIABLE_NAME = 'LOG_BIN';

or

SELECT @@log_bin;

Answer 3

SHOW VARIABLES LIKE 'log_bin';