GRANT SUPER ON *.* TO user@'localhost' IDENTIFIED BY 'password'; code example

Example: add super privilege mysql

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