Cheat Sheet

Configuration

Forbid external connections

bind-address = 127.0.0.1

Activate query log

This will log every query executed by the MySQl daemon. Activate the log parameter and comment out log-bin if active.

root# > /var/log/mysqld-detailed.log
# chown mysql /var/log/mysqld-detailed.log
# vi /etc/my.cnf

# /etc/init.d/mysqld restart

MySQL (last edited 2010-04-09 16:16:30 by JaumeSola)