Error Code: 1419. You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

You must have got mail from application team that they are facing below error while performing operations in database
Error:
Error Code: 1419. You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
Solution:
Check this parameter in database by login to database Click here to check how to login MySQL DB

mysql> show variables like '%log_bin_trust_function_creators%';
+---------------------------------+-------+
| Variable_name                   | Value |
+---------------------------------+-------+
| log_bin_trust_function_creators | OFF   |
+---------------------------------+-------+

we need to set this to 1
go to location of my.cnf , get backup of my.cnf file in case revert is required.

$ cp my.cnf my.cnf_$DATE

open my.cnf file using vi Insert mode and add the parameter log_bin_trust_function_creators in file
save the file and restart the mysql services

command to stop mysql services
$service mysql stop
command to start mysql services
$service mysql start
once restarted you will able to see the changes

mysql> show variables like '%log_bin_trust_function_creators%';
+---------------------------------+-------+
| Variable_name                   | Value |
+---------------------------------+-------+
| log_bin_trust_function_creators | ON    |
+---------------------------------+-------+