gistfile1.txt

class mydb {
  class { 'mysql::server':
    root_password    => 'Pupp3tlabs!',
    override_options => {
      'mysqld' => { 'datadir' => '/tmp/lib/mysql', 'log-error' => '/tmp/log/jeremysql.log' },
    },
  }

  mysql::db { 'mydb':
    user     => 'myuser',
    password => 'Pupp3tlabs!',
    host     => 'localhost',
    grant    => ['SELECT', 'INSERT', 'UPDATE', 'CREATE', 'DELETE'],
  }
}

## $ mysql --user='myuser' --password='Pupp3tlabs!' mydb