How to create Mysql user/grants using Chef

Chef has official support to managing users and grants through a community maintained module. Click here for documentation. There's more modules to manage different aspects of Mysql, you can definitely do a lot more as code using Chef. Make sure to read the documentation to know all the features, know every input option and all the use cases supported.

Create a user


mysql_user 'disenfranchised' do
  password 'super_secret'
  action :create
end

Drop a user


mysql_user 'foo_user' do
  action :drop
end

Grant SELECT, UPDATE, INSERT permissions to user


mysql_user 'foo_user' do
  password 'super_secret'
  database_name 'foo'
  host '%'
  privileges [:select,:update,:insert]
  action :grant
end

Grant ALL permissions to user


mysql_user 'foo_user' do
  password 'super_secret'
  database_name 'foo'
  host '%'
  privileges [:all]
  action :grant
end

Why Chef for managing Mysql users/grants

Chef is a Configuration Management tool used to manage the configuration of software applications and devices. It enables you to define the desired state of your systems and then automatically ensures that they are brought into that state. Chef can be used to manage both physical and virtual machines, as well as cloud instances.