1 class { 'mysql::server':

     2   root_password => 'password'

     3 }

     4 mysql::db{ ['test1', 'test2', 'test3']:

     5   ensure  => present,

     6   charset => 'utf8',

     7   require => Class['mysql::server'],

     8 }

     9 mysql::db{ 'test4':

    10   ensure  => present,

    11   charset => 'latin1',

    12 }

    13 mysql::db{ 'test5':

    14   ensure  => present,

    15   charset => 'binary',

    16   collate => 'binary',

    17 }