How to create multiple users? about psick

[alvagante]

Yes, you can use the mysql::user define to create users and mysql::grant define to manage permissions.

[wgregorian]

Sorry, I was not very descriptive. I need to be able to setup multiple users so, I used this:

    mysql::user { "db1":
            mysql_password_hash => "db1",
            mysql_user => "db1",
            mysql_host => "host"
    }
    mysql::grant { "db1":
            mysql_privileges => "ALL",
            mysql_password => "pwd",
            mysql_db => "db1",
            mysql_user => "db1",
            mysql_host => "host"
    }

But, if I use the same for db2, it won't work since mysql::user would be repeated twice. I guess, I'm looking for a way to handle multiple users for multiple databases more gracefully.

[alvagante]

Uhm, not so sure I've understood well, but you should be able to create 2 different users for the same db with just 2 different mysql::grant :

mysql::grant { "db1":
        mysql_privileges => "ALL",
        mysql_password => "pwd",
        mysql_db => "db1",
        mysql_user => "db1",
        mysql_host => "host"
}
mysql::grant { "db2":
        mysql_privileges => "ALL",
        mysql_password => "pwd",
        mysql_db => "db1",
        mysql_user => "db2",
        mysql_host => "host"
}

or maybe I still haven't understood what you need :-)
Anyway, take a look at the templates user by these defines:
mysql::grant uses this:

<% if mysql_db != "" then %>
CREATE DATABASE IF NOT EXISTS <%= mysql_db %> ;
<% end %>
GRANT <%= mysql_privileges %> ON <%= mysql_db %>. TO '<%= mysql_user %>'@'<%= mysql_host %>' IDENTIFIED BY '<%= mysql_password %>';
FLUSH PRIVILEGES ;

mysql::user uses this:

GRANT USAGE ON .
TO '<%= mysql_user %>'@'<%= mysql_host %>'
IDENTIFIED BY
<% if has_variable?('mysql_password_hash') && mysql_password_hash then %>
PASSWORD '<%= mysql_password_hash %>'
<% else %>
'<%= mysql_password %>';
<% end %>
;
FLUSH PRIVILEGES ;

So actually mysql::user is somehow a subset of mysql::grant

[welly]

Hi guys,

I'm very new to puppet and have just been trying to change the configuration that I got from puphpet.com to automatically add a new user. In my default.pp manifest, I've added:

mysql::grant { "db1":
mysql_privileges => "ALL",
mysql_password => "password",
mysql_user => "root",
mysql_host => "%",
}

however, vagrant fails to build reporting:

Must pass mysql_db to Mysql::Grant[db1] at /tmp/vagrant-puppet/modules-0/mysql/manifests/grant.pp:1 on node precise32

Any help would be appreciated!

Thanks

[alvagante]

Try to explicitely pass the parameter mysql_db => 'db1'