maria-discuss team mailing list archive

[brian@xxxxxxxxxxxxxxxxxxxxx]

Hello,

Concerning:
SET GLOBAL general_log_file='/path/to/general.log';

Some locations in the documentation suggests this can only be done by a 
super-user.
https://mariadb.com/kb/en/general-query-log/
"A user with the SUPER privilege can disable logging to the general 
query log for a connection by setting the SQL_LOG_OFF system variable to 
1."

https://mariadb.com/kb/en/grant/#super
SUPER: "Execute superuser statements: ..., SET global system 
variables,...."

Q: Does setting the general_log_file, in fact, require super user 
privileges?


Then, once the setting is made, and the task completed, the desire is to 
restore the setting back to what it was without having to know what it 
was.

https://mariadb.com/kb/en/set/#global-session
DEFAULT: "Setting a global variable to DEFAULT will restore it to the 
server default, and setting a session variable to DEFAULT will restore 
it to the current global value."

Q: By "server default" is this {host_name}.log or is it the value set in 
my.cnf?


Thank you.