hi, the main issue is that data from one of my database tables mysteriously disappears. This has been happening for at least a few weeks. Sometimes, it is there at night but when I log in the morning, it has disappeared. Sometimes it disappears in the middle of my working day. Has anyone ever reported this issue? It's only from ONE table.
I thought I would add database triggers to track what is happening to that table. But I don't have the correct privileges to do that. I get the below error when I tried to add triggers ERROR 1419 (HY000): 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)
When I try to do something similar to GRANT ALL PRIVILEGES ON mydb.* TO 'myuser'@'%' WITH GRANT OPTION; I get the error ERROR 1044 (42000): Access denied for user 'ccc'@'%' to database 'vvv'
Any suggestions would be much appreciated. Thanks a lot!