This is an automated archive.

The original was posted on /r/mysql by /u/kaeptn99 on 2023-08-03 15:34:56+00:00.


Hi all …

I would like to review log files of MySQL in the workbench but Workbench keeps complaining that “A problem was detected in your current log destination. It is set to none. Please refer …”

Thing is that the server writes logfiles to the location configured in the .ini. [mysqld] section

log-output=FILE
slow-query-log=1
slow_query_log_file = "D:/log/mysql/servername-slow.log"

Global and session variable show the desired values.

I found that the account - a local admin account - does not have read access to the log files on the disk which is very weird. Could it be that workbench creates that message due to read access problems? And why can’t I access the log file even as an admin? I cannot even check the effective rights, all dialogue options are blocked, the owner is not visible to me.

Any help & ideas appreciated.