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 |
+---------------------------------+-------+
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 |
+---------------------------------+-------+