O'Reilly logo

Chef Infrastructure Automation Cookbook by Matthias Marschall

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating MySQL databases and users

You need to use two different cookbooks for managing MySQL (or any other database) on your nodes: the generic database cookbook and the mysql cookbook.

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.

Getting ready

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required