Mysql – How to check thesql password change and other events logs

MySQLPHPwindows-server

Recently someone change my phpmyadmin password and drop database

I think it was sql injecting.

Now I want to find information about this like when, how and who change my password

Please tell me where I can find my mysql v 5.5 logs (Windows Server 2012)

Thanks

Best Answer

by default MySQL community version not support audit

You have only one build in way - enable general log for log all activity on MySQL server

alternatives for enterprise version - https://www.percona.com/doc/percona-server/5.5/management/audit_log_plugin.html

MariaDB audit plugin You can install and on Linux and on Windows server - https://mariadb.com/kb/en/mariadb/about-the-mariadb-audit-plugin/

Related Solutions

MySQL – How to Output MySQL Logs to Syslog

This is MUCH more simply done this way:

cd to mysql folders:

mkfifo mysql-general.log

in my.cnf tell it:

[mysqld]
general-log-file = /path/to/mysql/dir/mysql-general.log

Then, configure your syslog/syslog-ng to read the FIFO pipe and do with it as it will..

In my case, I pipe it across net to a centralized server with only the error logs and slow query logs however.

In situations where you want to also keep local copy, just set it to output to table and file as described above.

Mysql – Change path for binary logs and scheduling

You should be able to set the binary logs to a new partition by providing the absolute path:

log-bin=/my/other/dir/mysql-bin

You might need to copy the old binary logs to the new directory and update the .index file with the new path information (Do this only when mysql is not running).

Why would you only want to binary log during certain intervals of the day? Doing this could really mess with your ability to restore at any given time.

Best Answer

Related Solutions

MySQL – How to Output MySQL Logs to Syslog

Mysql – Change path for binary logs and scheduling

Related Question