I'm trying to enable and see logs in MySQL Workbench. In my my-default.ini file I have added log=filename.log. Saved the file and then restarted the MySQL service.
Now where I can or how can see the actions performed on tables in the log of MySQL?
- 1Execute this command SHOW VARIABLES LIKE "%log%" which will show you all the log files path for the server. I think you are looking for General Query log?Sathish D– Sathish D2016-01-06 07:34:47 +00:00Commented Jan 6, 2016 at 7:34
- 1@SathishD, Yes something like that. If accidentally some records get deleted from Table A, then how I'd be able to check the logs for that specific table ?roy– roy2016-01-06 08:02:44 +00:00Commented Jan 6, 2016 at 8:02
- 1You will have those in General query log.Sathish D– Sathish D2016-01-06 09:20:26 +00:00Commented Jan 6, 2016 at 9:20
Add a comment |
3 Answers
The following image explains what to do. Switch to the admin section and click on the Server Logs entry. 
8 Comments
roy
location of MYSQL configuration file (i.e my.cnf) not specified (Error). How can I fix this ?
Mike Lischke
This is a different question. Difficult to answer in a comment, since I cannot add a screenshot. Look in the connection setting under "System Profile". Note: on some platforms the default installation of a MySQL server does not have a config file and uses default values (e.g. on OSX).
roy
Could you help me for what to write in my-default.ini file so that I could check logs ? And in describe variables do I need to set path to general_log of my-default.ini ?
Mike Lischke
Open a new question at SO instead of hijacking an existing one.
roy
but all these comments goes to this question only !!
|
The below tells the location and for more info visit https://dev.mysql.com/doc/workbench/en/wb-configuring-files.html 
Comments
I had to edit the actual xml config file:
...\AppData\Roaming\MySQL\Workbench\server_instances.xml
changed from:
<value type="string" key="logOutput">NONE</value> to:
<value type="string" key="logOutput">FILE</value> I can now see the logs.
