Tag Info

Hot answers tagged

1

For security concern who executed what queries at what time etc.. you should use "Audit Plugins". You can refer my existing answer here http://dba.stackexchange.com/a/62477/6037 Ofcourse you can find "mysqladmin" using shell histories or tracing "General/Error log" of MySQL server. For example if you have General log enabled either in a "Table" or "File" ...


1

One perfect example why root access even for admins is bad. Maintaining a sudoers file and a centralized database of privileged users and groups(LDAP for example) would help solving problems like this. One note: the wrongdoer might well be a cronjob. I'd check that.


1

Check the secure log in the event it was run via a sudo service call sudo grep mysql /var/log/secure Check to see if there's any mysql related stuff going on in cronjobs sudo grep mysql /var/log/cron Check shell histories for mysqladmin calls cd /home; for u in *: do; sudo grep mysql /home/$u/.bash_history; done Check with people you know that either ...


1

A shutdown is already in progress. You can either Wait Login using su - oracle and then sqlplus / as sysdba and issue the command shutdown abort if that's what you really want.



Only top voted, non community-wiki answers of a minimum length are eligible