Resources and parameters

gistfile1.txt

  database { $name:
    ensure   => $ensure,
    charset  => $charset,
    provider => 'mysql',
    require  => Class['mysql::server'],
  }

In lib/puppet/provider/database/mysql.rb if I want to use the mysql root password
  mysql('-p #{@something['mysql::config::root_password']} -NBe', "create database `#{@resource[:name]}` character set #{resource[:charset]}")

I would actually have to add the type parameter and :
  database { $name:
    ensure   => $ensure,
    charset  => $charset,
    provider => 'mysql',
    root_password => mysql::config::root_password,
    require  => Class['mysql::server'],
  }

then 

  mysql('-p #{@resource[:root_password]} -NBe', "create database `#{@resource[:name]}` character set #{resource[:charset]}")

Right?