root user cannot change system variables?
Hello,
I am new to MySQL Workbench, using 8.0.27 with the same MySQL server version, on MacOS 12.0.1. I logged in as root. When I look at the roles and global privileges, everything is checked. But when I try to change one, "secure_file_priv", I get an error message.
"You need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation."
I read an earlier thread about changing the "Options File". I opened that menu item, and was told "Location of MySQL configuration file (ie: my.cnf) not specified". But there is no way to select one. The entire window is greyed out. I am willing to share a screenshot if someone will show me how.
Can anyone help?
Regards,
Karl Jenkinson
Subject
Written By
Posted
root user cannot change system variables?
January 12, 2022 08:00PM
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.