Configure Mysql

• Add this to the configuration file /etc/my.cnf

socket=/var/lib/mysql/mysql.sock
skip-networking

This configures mysql to only communicate via the socket not tcp which is better for security and for performance.

• start mysql, this will initialize the default databases.

 # service mysqld start

• Set the root users password

 # mysqladmin -u root password NEWPASSWORD

• Create the mailwatch database and populate tables

 # mysql -p < /usr/local/src/mailwatch-1.0.4/create.sql

• Create the mysql user for mailwatch and mailscanner logging

 # mysql -p
 mysql> GRANT ALL ON mailscanner.* TO mailwatch@localhost IDENTIFIED BY 'password';

• Create the mailwatch admin user

 # mysql mailscanner -u mailwatch -p
 Enter password: ******
 mysql> INSERT INTO users VALUES ('<username>',md5('<password>'),'<name>','A','0','0','0','0','0');