As we know this warning can be serious security issue:
Please note that as this is not supported in the cPanel UI, cPanel support can not provide assistance with or add these grants on your behalf. Additionally, adding grants such as this for users will cause significant issues when attempting to restore backups for users with these privileges as restoring them is a security risk, as such, this is not recommended or supported in cPanel.
It can cause harmful queries to be run. There is no tool in cPanel to enable SUPER privilege for a user.
So, you request to execute a command:
GRANT SUPER ON dbname.* TO user@'localhost' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;