MySQL SHOW TRIGGERS produces bug

2 posts
[expired user #9073]'s profile image [expired user #9073] posted 9 years ago in General Permalink
When I was running HeidiSQL 9.1.4867 with a MySQL server, at the time I logged in (and then the SHOW TRIGGERS query) was executed, for some reason the ownership (DEFINER) of all TRIGGERS in my Database changed to the user I used to connect to the database via HeidiSQL.

Then the triggers stopped working due to this.

I'm installing the 9.2 version now. If this issue was already done, my apologies for the entry.

Kind Regards,
Rodrigo.
2 posts
[expired user #9073]'s profile image [expired user #9073] posted 9 years ago Permalink
**Note: to solve this, I accessed the server via phpmyadmin and changed the definer of the triggers to the admin user (one by one). After that, the definer remains unchanged.

Please login to leave a reply, or register at first.