MySQL Log File


I am new to MySQL 5.0 database. Can someone tell me where to look for the log file which may be running with my database?

To provide some context MS SQL server creates a log file automatically for all databases.

I am hoping that MySQL ceates a log file which stores all activities for that database i.e. database opened, closed, table updated, deleted, date, time etc.

Any help on this will be appreciated.