Lukas: Perhaps the MySQL binlog will help you -- I think it logs all non-select queries and can be displayed from the phpMyAdmin interface.
To the devs: There have been a number of requests (3 or 4, IIRC) for this on IRC lately. People wanting an audit log of all actions performed within PMA, some wanting everything including SELECTs, some want everything except SELECTs. Obviously it wouldn't log non-PMA queries, which makes me question how useful it really would be to those users...
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am aware of the bin log, however I am specifically looking for auditing _just_ PMA sql statements. The reason being, that for the application we have other facilities and requirements. However, security rules at the client specify that an audit log exist on a per application basis. Since we are "abusing" PMA as a "cheap" administration tool for some tasks, we need to have an audit log just for PMA on a per user basis. So the bin log would not fullfil our needs really.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Logged In: YES
user_id=835650
Originator: NO
Lukas: Perhaps the MySQL binlog will help you -- I think it logs all non-select queries and can be displayed from the phpMyAdmin interface.
To the devs: There have been a number of requests (3 or 4, IIRC) for this on IRC lately. People wanting an audit log of all actions performed within PMA, some wanting everything including SELECTs, some want everything except SELECTs. Obviously it wouldn't log non-PMA queries, which makes me question how useful it really would be to those users...
Logged In: YES
user_id=2102098
Originator: YES
I am aware of the bin log, however I am specifically looking for auditing _just_ PMA sql statements. The reason being, that for the application we have other facilities and requirements. However, security rules at the client specify that an audit log exist on a per application basis. Since we are "abusing" PMA as a "cheap" administration tool for some tasks, we need to have an audit log just for PMA on a per user basis. So the bin log would not fullfil our needs really.
Logged In: YES
user_id=210714
Originator: NO
Added as a feature requests on http://hackontest.org, please go vote there :) and add your comments if you want.
Logged In: YES
user_id=192186
Originator: NO
I thinks this one is a duplicate of https://sourceforge.net/tracker/index.php?func=detail&aid=910668&group_id=23067&atid=377411