Set and view MySQL logs

Check whether logs are enabled in Linux.

Display binary logs

Use shell to view logs

Configure MySql in Linux

Note:

Enable slow Query 
Long_query_time = 2 -- indicates how long the SQL statement will be logged after execution. Here, it is 2 seconds. 
Log-Slow-queries =/usr/local/MySQL/log/slowquery. log -- Records slow statements returned by the query. 
Log-queries-not-using-indexes = nouseindex. log -- it is a literal meaning that the query with no index is used in the log. 
Log = mylog. log -- Record all execution statements