MySQL Forums
Forum List  »  Connector/ODBC

Re: MYSQL ERRORS ON SPECIFIC COMPUTERS
Posted by: Abba Lustgarten
Date: October 06, 2021 08:01PM

Thanks again, Peter, for the link.

I see that I can get the server to log queries in a table and it seems like I should be able to query the table to see the log entries.

I am trying to turn on the logging with
SET global general_log = 1;
SET global log_output = 'table';

But I am getting this message:
Error Code: 1227. Access denied; you need (at least one of) the SUPER privilege(s) for this operation

I am using MYSQL Workbench, connected as the root user, which I assumed had all the necessary privileges.

Any ideas to get over this hitch?

Abba

Options: ReplyQuote


Subject
Written By
Posted
Re: MYSQL ERRORS ON SPECIFIC COMPUTERS
October 06, 2021 08:01PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.