0
votes
0answers
4 views

Why/when does creating a mysql trigger require SUPER privileges? [migrated]

I'm attempting to parse and understand what the MySQL doc says about when SUPER privileges are required for creating triggers. They say: If binary logging is enabled, CREATE TRIGGER might require ...
1
vote
1answer
62 views

Trigger actions automatically when package is installed or user is added

When installing mysql-server on Debian Wheezy, the user "mysql" is created without a home directory. In my setup, directly after MySQL was installed, a new task is performed which relies on the mysql ...
3
votes
1answer
2k views

Is a MySQL stored procedure able to insert/update to a remote backup MySQL server?

Is it possible to create a MySQL stored procedure that can execute a given insert or update and then also have it connect to a 2nd server and run the same commands? I want to basically call one server ...
1
vote
1answer
708 views

importing a mysqldump file does not import triggers due to some permission problems

Whenever I try to import a mysqldump export on another server, the triggers are never created, and if I remember correctly, I get an error messages that super user permission is required. IF I remove ...