How do I use the mysql cookbook?

Question

I'm trying to use the latest version of the mysql cookbook in the Chef Supermarket:

https://supermarket.chef.io/cookbooks/mysql

(8.3.1)

I've added it as a wrapper cookbook and created a small recipe I'm trying to spin up in Test Ktichen:

include_recipe 'mysql'

mysql_service 'foo' do
  port '3306'
  version '5.7'
  initial_root_password 'change me'
  action [:create, :start]
end

mysql_config 'logging' do
  instance 'instance-1'
  source 'my.cnf.erb'
  action :create
  notifies :restart, 'mysql_service[instance-1]'
end

This quickly fails on converge with:

could not find recipe default for cookbook mysql

The depends 'mysql' is in the cookbook metadata.rb.

I've seen some posts that say this cookbook has undergone major refactoring... but I still don't have a clue as how to actually use it...

Mrigesh Priyadarshi Mrigesh Priyadarshi · Accepted Answer · 2017-04-13T07:31:31

An include_recipe method is used to call the specified recipe. If no recipe given, for example, include_recipe '<cookbook_name>', it will call the default recipe, i.e., default.rb.

https://docs.chef.io/recipes.html#include-recipes

In your case, the mysql is a base cookbook and only have libraries and resources to be used in Wrapper cookbook. Therefore, you can call resources like mysql_config but include_recipe will fail because there is no recipe in that cookbook.

https://github.com/chef-cookbooks/mysql

How do I use the mysql cookbook?

2 Answers