Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

how to check logs in mysql workbench?

I'm trying to enable and see logs in mysql workbench.

In my my-default.ini file added log=filename.log.

Saved--->services stopped and started

Now where I can or how can see the actions performed on table in log of mysql ?

like image 445
roy Avatar asked Jan 06 '16 07:01

roy


People also ask

How do I view MySQL logs from Workbench?

MySQL Workbench start up and SQL actions are logged and stored in the log/ directory. This directory is in the user's MySQL Workbench directory. To find these text files, select Show Log Files from the Help menu.

Does MySQL have a log file?

MySQL Server has several logs that can help you find out what activity is taking place. By default, no logs are enabled, except the error log on Windows. (The DDL log is always created when required, and has no user-configurable options; see Section 5.4.


Video Answer


1 Answers

The following image explains what to do. Switch to the admin section and click on the Server Logs entry. enter image description here

like image 161
Mike Lischke Avatar answered Sep 25 '22 14:09

Mike Lischke