{
my $db = ${'phplist'}{'DbName'} || 'phplistdb';
my $user = ${'phplist'}{'DbUser'} || 'phplistuser';
my $pass = ${'phplist'}{'DbPassword'} || 'secret';



$OUT .= <<"END";

#! /bin/sh
if [ ! -d /var/lib/mysql/$db ]; then
        /usr/bin/mysql -e 'create database $db'
fi


/usr/bin/mysql <<EOF
USE mysql;

GRANT SELECT , INSERT , UPDATE , DELETE , CREATE , DROP , INDEX , ALTER , CREATE TEMPORARY TABLES , CREATE VIEW , SHOW VIEW , CREATE ROUTINE, ALTER ROUTINE, EXECUTE ON $db . * TO '$user'@'localhost' ;


SET PASSWORD FOR '$user'@'localhost' = PASSWORD( '$pass' );

FLUSH PRIVILEGES;

EOF
END
}