Is there a script that I can run to get an email when someone else other than me logs in as root?
I'm new to MySQL. These are my contents of
[mysqld] *Remove leading # and set to the amount of RAM for the most important data cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. *innodb_buffer_pool_size = 128M *Remove leading # to turn on a very important data integrity option: logging *changes to the binary log between backups. *log_bin *Remove leading # to set options mainly useful for reporting servers. *The server defaults are faster for transactions and fast SELECTs. *Adjust sizes as needed, experiment to find the optimal values. *join_buffer_size = 128M *sort_buffer_size = 2M *read_rnd_buffer_size = 2M datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock *Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid port=1433
Please suggest a way to get an email alert if someone logs in as root into MySQL.