Creating a new database and user(s)

mysql -uroot -p <<MYSQL
Enter password:

drop database if exists mail;
create database mail;

# Privileges are contained in the 'mysql' database.
use mysql;

# The 'identified by' clauses specify passwords for the user@host
# given in the 'to' clauses. Here we create a admin-type role 'mail', and a
# read-only role 'exim'.
grant Select, Insert, Update, Delete, Create, Drop
        on mail.*
        to mail@localhost
        identified by 'mail_setup';
grant Select
        on mail.*
        to exim@localhost
        identified by 'themta';