You need to use two different cookbooks for managing MySQL (or any other database) on your nodes: the generic
database cookbook and the
database cookbook provides resources for managing databases and database users for MySQL, PostgreSQL, and Microsoft SQL Server. The
mysql cookbook installs a MySQL Client and server.
Let's see how we can install a MySQL server and create a database and a database user.
Make sure you've a cookbook called
my_cookbook and the
run_list of your node includes
my_cookbook as described in the Creating and using cookbooks section in Chapter 1, Chef Infrastructure.
Make sure you've the
berkshelf gem installed as described in the Managing cookbook dependencies ...