The SUPER privilege is powerful, and it controls many aspects of server operation. It allows a user to perform operations like setting global system variables, killing or inspecting sessions for other users, and performing actions that could potentially impact the entire server.
The error message "Access denied; you need (at least one of) the SUPER privilege(s) for this operation" indicates that the MySQL/MariaDB user used in your PHP application does not have the necessary permissions to perform a specific operation.
In order to fix this, in your SSH, as root, run:
Code: Select all
mysql
Code: Select all
GRANT ALL PRIVILEGES ON DBNAME.* to 'DBUSER'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON DBNAME.* to 'DBUSER'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;