The module is trying to read the cached password from /root/.my.cnf to connect, and since it's empty it tries with no password. (See https://github.com/puppetlabs/puppetlabs-mysql/blob/master/manifests/server/root_password.pp#L7-L19 for what puppet is doing with the root_password).
You could create the file /root/.my.cnf with the contents of https://github.com/puppetlabs/puppetlabs-mysql/blob/master/templates/my.cnf.pass.erb but just add your own info, then it should work and puppet should be able to manage it from there :). -Hunter On Wed, Jul 23, 2014 at 10:07 AM, David Kindle <david.m.kin...@gmail.com> wrote: > based on the below script - My mysql instance has a password of foo > already. I want this script to use my root password to create a new db > and assign a user with privileges to that db. > > What is wrong with this code? Is this trying to SET the root pass vs just > using it to execute the commands? > > the way this is it throws the error "Access denied for user 'root'@'localhost' > (using password: NO)" > > any help greatly appreciated > > > class {'mysql::server': > root_password => 'foo', > } > > #creates a sample db with user with correct permissions -spade > mysql::db { $dbName: > user => $dbUser, > password => $dbPass, > host => 'localhost', > grant => ['SELECT', 'INSERT', 'UPDATE', 'CREATE', 'DELETE'], > } > > -- > You received this message because you are subscribed to the Google Groups > "Puppet Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to puppet-users+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/puppet-users/c11bfb37-2621-4662-9a1e-ece61c8023fe%40googlegroups.com > <https://groups.google.com/d/msgid/puppet-users/c11bfb37-2621-4662-9a1e-ece61c8023fe%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/CAJaQvGA6MsEojAdPMNSnGJAh6%3DVbp8esN6qETV36RHaCo-3teg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
