Sample Header Ad - 728x90

Track MySQL Procedure Changes in MySQL

0 votes
1 answer
306 views
We want to keep track of changes being done to MySQL procedures only, actually recently our procedures seem to have overwritten to some previous versions and we were unable to track it that who did this. We were able to track thread-id from mysqlbinlog but were not able to determine whose userid was using that thread-id. Is there any way by which we can do following **• Track user-id from mysqlbinlog thread-id • Keep track of every create procedure/drop procedure** We are using MySQL 5.7.20 community edition on windows 10 & CentOS7 and we are using row level bin-logging Any help is greatly appreciated.
Asked by Nawaz Sohail (1480 rep)
Mar 6, 2018, 05:32 PM
Last activity: May 5, 2025, 03:04 AM