How get mail alert from mysql server

Question

How to get mail from mysql, if directly root or someone editing or updating to particular database it should trigger a mail and log the edit.

I have tried Triggers but its not working,

Server specifications:

   OS : ubuntu 10.04 64bit
   mysql : mysql server 5.1.41

I was just wondering if anyone could help me with this problem I'm having. I would really appreciate it.

Answer 1

im doing now similar project with this topic.

My solution for this woud be:

edit:

/etc/mysql/my.cnf
log = /var/log/mysql/mysql.log

that write some perl function:

#!/usr/bin/perl 
use strict;
use warnings;
use File::Tail;
my $name=' /var/log/mysql/mysql.log';
my $file=File::Tail->new(name=>$name,
                        interval=>1,
                        maxinterval=>15,
                        adjustafter=>5,
                        ignore_nonexistant=>1,
                        reset_tail=>1,
                        reset_after=>35,
                        tail=>0
                        );

my $line='';
while ( defined ($line=$file->read)) {
      if ($line =~ /Update/){exec `mail -s $subj < $line`}
}

You should to add functioality for this