{
    my $db = $cacti{DbDatabase} || 'cacti_sme';
    my $user = $cacti{DbUser} || 'cacti';
    my $pass = $cacti{DbPassword} || 'changeme';
    $OUT .= <<END
#!/bin/bash
    if [ -d /var/lib/mysql/$db ]; then
      /usr/bin/mysql <<EOF
    use $db;
    use mysql;
    ALTER DATABASE $db  COLLATE = 'utf8mb4_unicode_ci';
    GRANT ALL PRIVILEGES ON $db.* TO $user\@localhost
            IDENTIFIED BY '$pass';
    GRANT SELECT ON mysql.time_zone_name TO '$user'\@'localhost';
    flush privileges;
EOF


      exit
    fi
    /usr/bin/mysql <<EOF
    CREATE DATABASE $db DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
    use $db;
    use mysql;
    GRANT ALL PRIVILEGES ON $db.* TO $user\@localhost
            IDENTIFIED BY '$pass';
    GRANT SELECT ON mysql.time_zone_name TO '$user'\@'localhost';
    flush privileges;
EOF
    /usr/bin/mysql_tzinfo_to_sql /usr/share/zoneinfo/ 2>/dev/null |/usr/bin/mysql mysql
    /usr/bin/mysql $db < \$(rpm -ql cacti|grep cacti.sql) 
    #/usr/bin/mysql $db < /etc/e-smith/db/configuration/migrate/80cacti_sme.sql
END
}
