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

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, S开发者_如何学Pythonean

SHOW VARIABLES LIKE 'log_bin';

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'

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

or

SELECT @@log_bin;