MySQL Forums
Forum List  »  Newbie

root user cannot change system variables?
Posted by: Karl Jenkinson
Date: January 12, 2022 08:00PM

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

Options: ReplyQuote




Sorry, only registered users may post in this forum.

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.