0

Hi,

Can anyone please tell me how to log all activity of my mysql database.
Also do you know if there any tripwire services/products that are available ?

Thanks,

2
Contributors
2
Replies
3
Views
5 Years
Discussion Span
Last Post by felix001
0

Thanks. I add this and some different combinations but I am still only logging errors :

[root@william etc]# cat  /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0
[mysql]
log=/var/log/mysql.log

[mysqld_safe]
long_query_time  = 1
log-queries-not-using-indexes
root      2424  0.0  0.2  63904  1188 pts/2    S    14:44   0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --user=mysql

Can anyone assist ?

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.