{
my $db = $phpmyadmin{'DbName'} || 'phpmyadmin';
my $user = $phpmyadmin{'DbUser'} || 'phpmyadmin';
my $pass = $phpmyadmin{'DbPassword'} || 'phpmyadmin';
my $admpass = $phpmyadmin{'sqladminPassword'} || 'adminpass';

my $dbstruct = `rpm -qd smeserver-phpmyadmin | grep phpmyadmin.sql`;

$OUT .= <<"END";
#! /bin/sh
if [ ! -d /var/lib/mysql/$db ]; then
        /usr/bin/mysql -e 'create database $db'
        /usr/bin/mysql $db < $dbstruct
fi

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

CREATE OR REPLACE USER '$user'\@'localhost' IDENTIFIED VIA mysql_native_password USING PASSWORD ('$pass');

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON $db.* TO '$user'\@'localhost';

GRANT ALL ON *.* TO 'sqladmin'\@'localhost' IDENTIFIED BY '$admpass'
    WITH GRANT OPTION;

FLUSH PRIVILEGES;
EOF
END
}

