DEFINER on triggers #1165
Description
Adminer version: 5.3.0
Compiled: single file
Driver:. MySQLi
Database version: 8.0.37-google
Plugins used: N/A
Context:
I'm doing a transfers of data from a mysql 8.0.x to 8.0.37-google.
I don't have the full right on cloud@sql for Mysql Instance (Mysql 8.0.37-google), I must use a specific user.
On my old database, I used a user "A" for create table, create trigger, ....
While I imported data, I got an error about my user "A" not exist on new server and mysql cannot execute trigger because the DEFINER not exist. So for resolve that problem, I recreated my account "A" for definer consistency (all function and all trigger use the same definer).
But, I'm testing a script for maintain a valid copy between old server and the new instance and I decided to test a modification of a existing trigger and the result was not OK because the definer was changed.
I know the reason, is because adminer drop the trigger and recreate the trigger.
I don't have problem with that... but is it possible de have a combo for select the definer to apply on the creation of the trigger. This will resolve my problem and add a possibility to DBA to use a specifig definer.
Command for create a trigger with specific definer : CREATE DEFINER=<user>@% TRIGGER ...
Best regards