class mysql::server inherits mysql {

        package {"mysql-server":
                ensure => latest,
        }

        file {"my.cnf":
                path => "/etc/mysql/my.cnf",
                source => "puppet://$server/modules/mysql/my.cnf",
                require => Package ["mysql-server"],

        service {"mysql":
                ensure => running,
                enabled => true,
                require => Package ["mysql-server"],
                subscribe => File ["my.cnf"],
        }

        case $mysql_root_password {
                '': { $mysql_root_password = "default_pass" }
        }

        $mysql_changepass_command = "update user set password=PASSWORD('$mysql_root_password') where User='root'",

        exec {"mysql_setpass":
                command => "/usr/bin/mysql -u debian-sys-maint -p$mysql_debiansysmaint_password mysql -e '$mysql_changepass_command'",
                unless => "/usr/bin/mysql -u root -p$mysql_root_password mysql -e 'use mysql'",
                onlyif => "/usr/bin/pgrep mysqld",
                require => Service ["mysql"],
        }

        exec {"mysql_flush_privileges":
                command => "/usr/bin/mysqladmin -u debian-sys-maint -p$mysql_debiansysmaint_password flush-privileges",
                onlyif => "/usr/bin/pgrep mysqld",
                refreshonly => true,
                subscribe => Exec ["mysql_setpass"],
        }

}