you need (at least one of) the super privilege(s) for this operation mysql code example

Example: add super privilege mysql

grant super on *.* to user@localhost;
FLUSH PRIVILEGES;