Cannot Create Triggers in MySQL. Error : TRIGGER command denied to user 'root'@'%' for table / Access denied; you need the SUPER privilege for this operation

When try to create a Trigger in MySQL Server we get Error message like  'TRIGGER command denied to user 'root'@'%' for table ...' or ' Access denied; you need the SUPER privilege for this operation'

This can be fixed by adding the TRIGGER permission to the root account in MySQL.
you can simply run this query on the DB.

GRANT ALL PRIVILEGES on *.* TO 'root'@'localhost'; 
Flush Privileges;

Or

Update the Fields Event_priv,Trigger_priv,Create_ tablespace_priv with value 'Y' where Host is '%' in table 'User' in 'MYSQL' Database

Need to restart MySQL Server to take effect of the changes.