User "root" cannot change some system variables?
Hello,
I am new to MySQL. I installed 8.0.27 on my Mac running OS X 12.0.1 a few weeks ago. For right now, I am logged in as root, while I create and delete schemas and tables frequently and learn the system. I tried to change a system variable and got this message:
"You need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation."
I looked at root's Admin Roles, and everything is checked. This user is SUPER, although "Schema Privileges" is blank. What am I doing wrong, that "root" is unable to do something?
Regards,
Karl
Subject
Written By
Posted
User "root" cannot change some system variables?
January 17, 2022 12:10AM
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.