Activities

November 2020
M T W T F S S
« Apr    
 1
2345678
9101112131415
16171819202122
23242526272829
30  

Amazon RDS : Trigger Error – You might want to use the less safe log_bin_trust_function_creators variable

While I’m trying to execute triggers to a RDS Mysql database I got the following errors

ERROR 1419 (HY000) at line #: 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).

I’m using the SUPER root account which will create at […]

mysqldump: Got error: 1556: You can’t use locks with log tables

I got the mysql error 1556 when I was backing up all the database from a remote mysql server (Amazon RDS )using a script.

mysqldump: Got error: 1556: You can’t use locks with log tables. when using LOCK TABLES

Solution :

You may need to disable “–lock-tables” option on your dump statement ie –lock-tables=0 […]