mysql (187) Versions 12.0.0 Follow781

Provides mysql_service, mysql_config, and mysql_client resources

Policyfile

Berkshelf

Knife

cookbook 'mysql', '~> 12.0.0', :supermarket

cookbook 'mysql', '~> 12.0.0'

knife supermarket install mysql

knife supermarket download mysql

README

Dependencies

Changelog

Quality 50%

MySQL cookbook

Manage Oracle MySQL instances, configuration, clients, databases and accounts with unified custom resources. Requires Chef Infra 17 or later and systemd. MySQL 8.4 LTS is the default. Repository configuration remains the caller's responsibility; this cookbook does not substitute MariaDB or Percona.

mysql_service 'application' do
  version '8.4'
  initial_root_password secret_store.fetch('mysql-root-password')
  bind_address '127.0.0.1'
  action [:create, :start]
end

mysql_database 'application' do
  socket '/run/mysql-application/mysqld.sock'
  password secret_store.fetch('mysql-root-password')
  encoding 'utf8mb4'
  collation 'utf8mb4_0900_ai_ci'
end

Use your existing secret store; secret_store above represents your own integration. Password properties are sensitive. SQL runs through the vendor client with a temporary private options file, without shell interpolation or password arguments. Errors report the MySQL error number without query text or credentials.

Resources

[mysql_service](documentation/resource_mysql_service.md)
[mysql_client](documentation/resource_mysql_client.md)
[mysql_client_config](documentation/resource_mysql_client_config.md)
[mysql_config](documentation/resource_mysql_config.md)
[mysql_database](documentation/resource_mysql_database.md)
[mysql_user](documentation/resource_mysql_user.md)

The installation aliases mysql_client_installation, mysql_client_installation_package, mysql_server_installation and mysql_server_installation_package remain available. Server installation supports :install and :delete; client installation supports :create and :delete.

Platforms

Retains AlmaLinux, Amazon Linux, CentOS Stream, Debian, Fedora, openSUSE Leap, Oracle Linux, RHEL, Rocky Linux and Ubuntu support. See metadata for minimum versions. Operators must provide compatible Oracle MySQL packages or use install_method 'none' with a preinstalled server. Oracle's package availability varies by distribution and architecture.

On hosts with a vendor AppArmor profile, the service adds instance-specific access rules and reloads that profile. It preserves existing policy and does not disable confinement. Configure SELinux policy for custom instance paths in your wrapper cookbook; the cookbook does not disable SELinux.

The explicit apparmor_mode 'validate' option parses policy without loading it for image/container builds. Production defaults remain enforce; failed live loads still fail convergence. Docker tests use offline policy validation and isolated copies of package executables to avoid runner-global profiles. They verify package/bootstrap behaviour, not live host kernel confinement.

Migration to version 12

This is a full migration from library resource inheritance to flat custom resources. Resource names, instance paths, SQL actions and installation aliases remain. There are no root recipes or node attribute defaults.

The default server series is 8.4. Set version explicitly for an existing 8.0 installation. This does not authorise an engine or data upgrade: the service refuses an installed-series mismatch and starts with --upgrade=NONE. Plan and perform upgrades separately using Oracle's procedure.
New databases require an explicit, non-empty initial_root_password. The property is sensitive. Existing databases retain their credentials; this property is not a password rotation mechanism.
Current server authentication replaces implicit mysql_native_password. Set use_native_auth true or explicitly pass MysqlCookbook::HashedPassword only when you deliberately enable legacy authentication on the server. MySQL 8.4 disables that plugin by default.
Systemd replaces SysV, Upstart and Solaris service managers. These obsolete managers are not available on the retained supported platforms.
mysql_service :delete stops and removes its unit and configuration. It preserves the data directory, logs, shared packages and system account. Remove data or uninstall shared packages explicitly if required.
Configuration uses an explicit defaults file. The cookbook no longer deletes global vendor configuration, stops unrelated vendor instances or modifies global SQL mode. Vendor package post-install scripts may create a default instance; operators own that instance separately.
Explicit SQL :query actions always execute and report an update. Use Chef guards for application-specific idempotency.

Testing

Run chef install, chef exec cookstyle, chef exec rspec and KITCHEN_LOCAL_YAML=kitchen.dokken.yml kitchen test. Kitchen performs two converges and verifies a real server, scoped grants, current authentication and private files. The default suite uses checksum-pinned Oracle binaries to exercise all retained Linux families independently of repository availability; package suites exercise Oracle repositories on Ubuntu and AlmaLinux. Optional real SQL specs require an isolated test client configured through MYSQL_REAL_TEST_CLI; never point these tests at a production server.

Licence

Apache-2.0. Maintained by Sous Chefs.

Dependent cookbooks

This cookbook has no specified dependencies.

Contingent cookbooks

Changelog

All notable changes to this project will be documented in this file.

Standardise files with files in sous-chefs/repo-management
Standardise files with files in sous-chefs/repo-management

12.0.0 (2026-11-12)

⚠ BREAKING CHANGES

default to MySQL 8.4, require an explicit sensitive root bootstrap password, use current server authentication, and replace library resource inheritance and obsolete service managers with unified custom resources. Preserve instance data and retain explicit legacy authentication only when selected.

Features

add support for ubuntu 22.04 (#685) (8c1678a)
migrate MySQL resources to secure 8.4 instances (#739) (a1af381)

Bug Fixes

ci: Update workflows to use release pipeline (#734) (46cb7a1)

11.1.11 (2025-10-15)

Bug Fixes

ci: Update workflows to use release pipeline (#734) (46cb7a1)

11.1.7 - 2024-11-18

Standardise files with files in sous-chefs/repo-management

11.1.4 - 2023-10-03

Standardise files with files in sous-chefs/repo-management

11.1.0 - 2023-08-23

feat: add support for ubuntu 22.04

11.0.15 - 2023-07-10

Update sous-chefs/.github action to v2.0.5

11.0.14 - 2023-05-17

Update sous-chefs/.github action to v2.0.4

11.0.13 - 2023-04-04

Standardise files with files in sous-chefs/repo-management

11.0.12 - 2023-04-01

Standardise files with files in sous-chefs/repo-management

11.0.11 - 2023-04-01

Standardise files with files in sous-chefs/repo-management

11.0.10 - 2023-04-01

Standardise files with files in sous-chefs/repo-management

11.0.9 - 2023-03-13

Standardise files with files in sous-chefs/repo-management

11.0.8 - 2023-02-14

Standardise files with files in sous-chefs/repo-management

11.0.7 - 2022-12-21

Fix CI issues

11.0.6 - 2022-12-05

Standardise files with files in sous-chefs/repo-management

11.0.5 - 2022-04-20

Standardise files with files in sous-chefs/repo-management

11.0.4 - 2022-02-09

Allow run_query to take a database name as an argument

11.0.3 - 2022-02-02

Remove delivery and move to calling RSpec directly via a reusable workflow
Update tested platforms

11.0.2 - 2022-01-27

resolved cookstyle error: spec/mysql_client_installation_package_spec.rb:6:46 warning: Chef/Deprecations/DeprecatedChefSpecPlatform
resolved cookstyle error: spec/mysql_server_installation_package_spec.rb:6:46 warning: Chef/Deprecations/DeprecatedChefSpecPlatform
Stop specifying the Fedora version, so we default to latest

11.0.1 - 2022-01-08

resolved cookstyle error: test/cookbooks/test/libraries/helpers.rb:14:31 convention: Style/FileRead
resolved cookstyle error: test/cookbooks/test/libraries/helpers.rb:26:31 convention: Style/FileRead

11.0.0 - 2021-09-16

resolved cookstyle error: libraries/mysql_service_base.rb:44:20 refactor: Chef/Modernize/UseChefLanguageSystemdHelper
Chef 17 updates: enable unified_mode on all resources
Bump required Chef Infra Client to >= 15.5
resolved cookstyle error: resources/mysql_database.rb:1:1 refactor: Chef/Deprecations/ResourceWithoutUnifiedTrue
resolved cookstyle error: resources/mysql_user.rb:1:1 refactor: Chef/Deprecations/ResourceWithoutUnifiedTrue

10.1.4 - 2021-08-30

Standardise files with files in sous-chefs/repo-management

10.1.3 - 2021-06-01

Standardise files with files in sous-chefs/repo-management

10.1.2 - 2021-03-26

Fix ctrl_user always set as root for mysql_user resource

10.1.1 - 2021-03-11

Fix db initialization status correctly on MySQL 8.0

10.1.0 - 2021-03-11

Add dependency on apparmor cookbook to fix #660

10.0.2 - 2021-02-25

Update README.md to reflect dropping ubuntu 16.04 support and fixing the cookbook version in the usage section

10.0.0 - 2021-01-25

Add mysql_database resource for creating, querying and removing databases
Add mysql_user resource for creating, modifying and removing database users
Remove Ubuntu 16.04 support

9.0.0 - 2020-11-27

resolved cookstyle error: libraries/helpers.rb:201:9 convention: Style/CommentAnnotation
Add support for MySQL 8
Add support for CentOS 8 and Ubuntu 20.04
Remove support for MySQL 5.1 and 5.5
Remove support for Centos 6 and Ubuntu 14.04

8.7.4 - 2020-09-16

resolved cookstyle error: spec/mysql_client_installation_package_spec.rb:4:48 warning: ChefDeprecations/DeprecatedChefSpecPlatform
resolved cookstyle error: spec/mysql_server_installation_package_spec.rb:4:48 warning: ChefDeprecations/DeprecatedChefSpecPlatform
Use mysql_test cookbook attributes for testing
Cookstyle Bot Auto Corrections with Cookstyle 6.17.6

8.7.3 - 2020-07-22

restore resource_name in mysql_service for Chef Infra Client < 16
resolved cookstyle error: libraries/mysql_client_installation_package.rb:8:5 warning: ChefDeprecations/ResourceUsesOnlyResourceName
resolved cookstyle error: libraries/mysql_client_installation_package.rb:9:1 convention: Layout/IndentationConsistency
resolved cookstyle error: libraries/mysql_client_installation_package.rb:9:1 convention: Layout/IndentationWidth
resolved cookstyle error: libraries/mysql_client_installation_package.rb:9:3 convention: Layout/IndentationWidth
resolved cookstyle error: libraries/mysql_client_installation_package.rb:9:9 convention: Layout/IndentationConsistency
resolved cookstyle error: libraries/mysql_server_installation_package.rb:4:5 warning: ChefDeprecations/ResourceUsesOnlyResourceName
resolved cookstyle error: libraries/mysql_server_installation_package.rb:5:1 convention: Layout/IndentationConsistency
resolved cookstyle error: libraries/mysql_server_installation_package.rb:5:1 convention: Layout/IndentationWidth
resolved cookstyle error: libraries/mysql_server_installation_package.rb:5:3 convention: Layout/IndentationWidth
resolved cookstyle error: libraries/mysql_server_installation_package.rb:5:9 convention: Layout/IndentationConsistency
resolved cookstyle error: libraries/mysql_service_manager_systemd.rb:3:5 warning: ChefDeprecations/ResourceUsesOnlyResourceName
resolved cookstyle error: libraries/mysql_service_manager_systemd.rb:4:1 convention: Layout/IndentationConsistency
resolved cookstyle error: libraries/mysql_service_manager_systemd.rb:4:1 convention: Layout/IndentationWidth
resolved cookstyle error: libraries/mysql_service_manager_systemd.rb:4:3 convention: Layout/IndentationWidth
resolved cookstyle error: libraries/mysql_service_manager_systemd.rb:4:9 convention: Layout/IndentationConsistency
resolved cookstyle error: libraries/mysql_service_manager_sysvinit.rb:3:5 warning: ChefDeprecations/ResourceUsesOnlyResourceName
resolved cookstyle error: libraries/mysql_service_manager_sysvinit.rb:4:1 convention: Layout/IndentationConsistency
resolved cookstyle error: libraries/mysql_service_manager_sysvinit.rb:4:1 convention: Layout/IndentationWidth
resolved cookstyle error: libraries/mysql_service_manager_sysvinit.rb:4:3 convention: Layout/IndentationWidth
resolved cookstyle error: libraries/mysql_service_manager_sysvinit.rb:4:9 convention: Layout/IndentationConsistency
resolved cookstyle error: libraries/mysql_service_manager_upstart.rb:3:5 warning: ChefDeprecations/ResourceUsesOnlyResourceName
resolved cookstyle error: libraries/mysql_service_manager_upstart.rb:4:1 convention: Layout/IndentationConsistency
resolved cookstyle error: libraries/mysql_service_manager_upstart.rb:4:1 convention: Layout/IndentationWidth
resolved cookstyle error: libraries/mysql_service_manager_upstart.rb:4:3 convention: Layout/IndentationWidth
resolved cookstyle error: libraries/mysql_service_manager_upstart.rb:4:9 convention: Layout/IndentationConsistency

8.7.2 - 2020-06-02

resolved cookstyle error: libraries/mysql_service.rb:4:5 warning: ChefDeprecations/ResourceUsesOnlyResourceName

8.7.1 - 2020-05-20

resolved cookstyle error: spec/mysql_client_installation_package_spec.rb:7:46 warning: ChefDeprecations/DeprecatedChefSpecPlatform
resolved cookstyle error: spec/mysql_server_installation_package_spec.rb:7:46 warning: ChefDeprecations/DeprecatedChefSpecPlatform

8.7.0 - 2020-05-05

migration to Github Actions
Ability to include "none" as an installation method in mysql_service
resolved cookstyle error: libraries/helpers.rb:57:48 refactor: ChefStyle/UnnecessaryOSCheck
resolved cookstyle error: libraries/helpers.rb:58:41 refactor: ChefStyle/UnnecessaryOSCheck

[8.6.0] - 2019-12-03

Fix the failing linting tests
Add mysql57 support for Amazon Linux AMI
Fix installation and testing on Ubuntu 18.04 bionic, EL7, Fedora and Opensuse
Ensure compatibility with mysql 5.7 on Ubtuntu 16.04
Add apparmor profile for ubuntu 16.04
Allow instance with 'mysql' as name
Add a helper for Ubuntu 18.04
Remove support for Debian 7
Remove ChefSpec matchers
Set apparmor tmp_dir permissions on directory itself
Run latest cookstyle
Circleci, Yaml and markdown lint updates

[8.5.1] - 2017-08-23

Fix the remainder of the namespace collision deprecation warnings
Remove the class_eval in the action class as this causes issues with some releases of Chef 12

[8.5.0] - 2017-08-23

Require Chef 12.7+ since 12.5/12.6 has custom resource action_class issues
Resolve several Chef 14 deprecation warnings

[8.4.0] - 2017-05-30

Fix client/server install on Amazon Linux and add testing
Remove support for Ubuntu Precise since it's EOL
Add Amazon Linux testing

[8.3.1] - 2017-04-04

Fix an ignoring of 'cookbook' attribute by 'mysql_config' resource
Remove unused helper method
Call out the supported platform versions in the metadata
Switch to Delivery Local and rename the docked config
Remove mention of the EOL opensuse 13.x in the readme

[8.3.0] - 2017-03-20

Refactor mysql_service_manager_upstart.rb to eliminate use of cloned resource

[8.2.0] - 2016-12-03

Include client development packages on RHEL/SUSE platforms

[8.1.1] - 2016-10-31

Fixing CVE-2016-6662 - Reverting execure bit on mysql config

[8.1.0] - 2016-10-29

Drop hardcoded, specific package version logic that broke many users

[8.0.4] - 2016-09-26

Bump debian version
Updated packages for 12.04 and 14.04 too
Add chef_version metadata
Update platforms in the kitchen file
Add selinux to the Berksfile for testing
Make sure yum repos are setup in local Test Kitchen

[8.0.3] - 2016-09-14

[GH-390] Fix #390 incorrect escaping of initial_root_password
Updated package versions for Ubuntu 16.04
Testing updates

[8.0.2] - 2016-08-25

Various bug fixed and updates to package version strings

[8.0.1] - 2016-07-20

Fixed a regression in the mysql_client resource where the action was changed from create to install in the 8.0 release
Added oracle, opensuse, and opensuseleap as supported platforms in the metadata

[8.0.0] - 2016-07-11

Converting from LWRP to custom resources
Removing yum-mysql and other dependencies.
^ BREAKING CHANGE: RHELish users are now responsible for including a recipe from the "yum-mysql" or equivalent cookbook before utilizing the mysql_* resources.
More thoughtful ChefSpec
Renaming "replication" test suite to "smoke"
Moving to Inspec

[7.2.0] - 2016-06-30

Support openeSUSE leap
Support Fedora 24

[7.1.2] - 2016-06-30

Avoid deprecation warnings on the upcoming Chef 12.12 release

[7.1.1] - 2016-06-03

Fix apparmor blocking writes to non-default tmp_dirs
Updated apparmor config to allow read & write to sock.lock file
Use cookstyle instead of Rubocop directly

[7.1.0] - 2016-05-11

Added support for Ubuntu 16.04

[7.0.0] - 2016-04-19

Removed support for legacy distros: Ubuntu 10.04/13.04/14.10/15.04, Fedora 20/21, OmniOS r151006, opensuse 11.3/12.0
Added support for Fedora 23, suse 13.X, and Ubuntu 16.04
Updated the systemd support to create unit files in /etc/systemd and not /usr/lib/systemd
Adding umask to bash resource that sets root password PR #386 @gziskind
Cleaned up the Test Kitchen config to test the right platform version + mysql pairings
Added Travis CI Test Kitchen testing on Fedora 22/23 and removed Fedora 21
Updated the platforms used in the specs

[6.1.3] - 2016-03-14

Added support for Ubuntu 15.10
Added support for Amazon Linux 2016-03
Updated Kitchen testing configs

[6.1.2] - 2015-10-05

Added support for Amazon Linux 2015.09

[6.1.1] - 2015-09-24

Completing ChefSpec matchers

[6.1.0] - 2015-07-17

Adding tunables for tmp_dir, error_log, and pid_file
Adding mysqld_options hash interface for main my.cnf template

[6.0.31] - 2015-07-13

Reverting create_stop_system_service checks

[6.0.30] - 2015-07-13

Ubuntu 15.04 support
Check for scripts and unit files during create_stop_system_service

[6.0.29] - 2015-07-12

Patch to allow blank root password
Adding package information for Suse 12.0

[6.0.28] - 2015-07-10

Fixes for 12.4.x

[6.0.27] - 2015-07-09

Allowing integer value for port number

[6.0.26] - 2015-07-07

Reverting breaking changes introduced in 6.0.25

[6.0.25] - 2015-07-06

Fixes for 12.4.1

[6.0.24] - 2015-06-27

341 - Changing default GRANT for root from '%' to 'localhost' and '127.0.0.1'

[6.0.23] - 2015-06-21

354 Better handling of long MySQL startup times

[6.0.22] - 2015-05-07

Debian 8 (Jessie) support

[6.0.21] - 2015-04-08

Fix to Upstart prestart script when using custom socket
Adding --explicit_defaults_for_timestamp mysql_install_db_cmd for
5.6 and above

[6.0.20] - 2015-03-27

318 - Fixing Upstart pre-start script to handle custom socket paths

[6.0.19] - 2015-03-25

Adding support for Amazon Linux 2015.03

[6.0.18] - 2015-03-24

Adding support for 5.6 and 5.7 packages from dotdeb repos on Debian 7

[6.0.17] - 2015-03-13

Updated for MySQL 5.7.6.
Handing removal of mysql_install_db and mysqld_safe

[6.0.16] - 2015-03-10

Moved --defaults-file as first option to mysql_install_db_script

[6.0.15] - 2015-02-26

Updating docker detection fix to pass specs

[6.0.14] - 2015-02-26

Fixed debian system service :disable action. Now survives reboot
Fixing centos-7 instance :enable action. Now survives
Not applying Apparmor policy if running in a Docker container

[6.0.13] - 2015-02-15

Adding support for special characters in initial_root_password
Fixing failure status bug in sysvinit script

[6.0.12] - 2015-02-30

No changes. Released a 6.0.11 that was identical to 6.0.10.
Git before coffee.

[6.0.11] - 2015-02-30

Adding support for configurable socket files

[6.0.10] - 2015-01-19

Fix #282 - Fixing up data_dir template variable

[6.0.9] - 2015-01-19

Fix #282 - undefined method `parsed_data_dir' bug

[6.0.8] - 2015-01-19

Refactoring helper methods out of resource classes

[6.0.7] - 2015-01-14

Fixing timing issue with Upstart provider :restart and :reload
actions where service returns before being available

[6.0.6] - 2014-12-26

Fixing subtle bug where MysqlCookbook::Helper methods were polluting Chef::Resource

[6.0.5] - 2014-12-25

Using 'include_recipe' instead of 'recipe_eval' in LWRP
Fixing type checking on package_name attribute in mysql_client resource.

[6.0.4] - 2014-12-21

Suggest available versions if current is not available for current platform.

[6.0.3] - 2014-12-17

Adding bind_address parameter to mysql_service resource

[6.0.2] - 2014-12-17

Fixing sysvinit provider to survive reboots

[6.0.1] - 2014-12-16

Fixing Upstart template to survive reboots

[6.0.0] - 2014-12-15

Major version update
Cookbook now provides LWRPs instead of recipes
Platform providers re-factored into init system providers
Separated :create and :start actions for use in recipes that build containers
mysql_service now supports multiple instances on the same machine
mysql_service no longer attempts to manage user records
Removal of debian-sys-maint
Unified Sysvinit script that works on all platforms
mysql_config resource introduced
mysql_client fixed up
Refactored acceptance tests
Temporarily dropped FreeBSD support

[5.6.1] - 2014-10-29

Use Gem::Version instead of Chef::Version

[5.6.0] - 2014-10-29

Changing default charset to utf8
Quoting passwords in debian.cnf.erb
Amazon 2014.09 support
Ubuntu 14.10 support
Only hide passwords from STDOUT via "sensitive true" in chef-client higher than 11.14
Updating test harness

[5.5.4] - 2014-10-07

Adding sensitive flag to execute resources to protect passwords from logs

[5.5.3] - 2014-09-24

Reverting back to Upstart on Ubuntu 14.04

[5.5.2] - 2014-09-8

Reverting commit that broke Debian pass_string

[5.5.1] - 2014-09-2

Switching Ubuntu service provider to use SysVinit instead of Upstart

[5.5.0] - 2014-08-27

Adding package version and action parameters to mysql_service resource
Fixing Debian pass_string

[5.4.4] - 2014-08-27

Changing module namespace to MysqlCookbook

[5.4.3] - 2014-08-25

More refactoring. Moving helper function bits into resource parsed_parameters

[5.4.2] - 2014-08-25

Moving provider local variables into definitions for RHEL provider

[5.4.1] - 2014-08-25

Refactoring resources into the LWRP style with parsed parameters
Moving provider local variables into definitions

[5.4.0] - 2014-08-25

212 - support for centos-7 (mysql55 and mysql56)
Adding (untested) Debian-6 support
Adding Suse support to metadata.rb
Adding ability to change MySQL root password
Added libmysqlclient-devel package to SuSE client provider
Appeasing AppArmor
Reducing duplication in client provider

[5.3.6] - 2014-06-18

Fixing pid path location. Updating tests to include real RHEL

[5.3.4] - 2014-06-16

Fixing specs for Amazon Linux server package names

[5.3.2] - 2014-06-16

Fixing Amazon Linux support

[5.3.0] - 2014-06-11

189 - Fix server_repl_password description
191 - Adding support for server55 and server56 on el-6
193 - Fix syntax in mysql_service example
199 - Adding Suse support

[5.2.12] - 2014-05-19

PR #192 - recipes/server.rb should honor parameter node['mysql']['version']

[5.2.10] - 2014-05-15

COOK-4394 - restore freebsd support

[5.2.8] - 2014-05-15

[COOK-4653] - Missing mySQL 5.6 support for Ubuntu 14.04

[5.2.6] - 2014-05-07

[COOK-4625] - Fix password resource parameter consumption on Debian and Ubuntu
Fix up typos and version numbers in PLATFORMS.md
Fix up specs from COOK-4613 changes

[5.2.4] - 2014-05-02

[COOK-4613] - Fix permissions on mysql data_dir to allow global access to mysql.sock

[5.2.2] - 2014-04-24

[COOK-4564] - Using positive tests for datadir move

[5.2.0] - 2014-04-22

[COOK-4551] - power grants.sql from resource parameters

[5.1.12] - 2014-04-21

[COOK-4554] - Support for Debian Sid

[5.1.10] - 2014-04-21

[COOK-4565] Support for Ubuntu 14.04
[COOK-4565] Adding Specs and TK platform
Removing non-LTS 13.10 specs and TK platform

[5.1.8] - 2014-04-12

Adding Ubuntu 13.04 to Platforminfo

[5.1.6] - 2014-04-11

[COOK-4548] - Add template[/etc/mysql/debian.cnf] to Ubuntu provider

[5.1.4] - 2014-04-11

[COOK-4547] - Shellescape server_root_password

[5.1.2] - 2014-04-09

[COOK-4519] - Fix error in run_dir for Ubuntu
[COOK-4531] - Fix pid and run_dir for Debian

[5.1.0] - 2014-04-08

[COOK-4523] - Allow for both :restart and :reload

[5.0.6] - 2014-04-07

[COOK-4519] - Updating specs to reflect pid file change on Ubuntu

[5.0.4] - 2014-04-07

[COOK-4519] - Fix path to pid file on Ubuntu

[5.0.2] - 2014-04-01

Moving server_deprecated into recipes directory

[5.0.0] - 2014-03-31

Rewriting as a library cookbook
Exposing mysql_service and mysql_client resources
User now needs to supply configuration
Moving attribute driven recipe to server-deprecated

[4.1.2] - 2014-02-28

[COOK-4349] - Fix invalid platform check
[COOK-4184] - Better handling of Ubuntu upstart service
[COOK-2100] - Changing innodb_log_file_size tunable results in inability to start MySQL

[4.1.1] - 2014-02-25

*[COOK-2966] - Address foodcritic failures'
*[COOK-4182] - Template parse failure in /etc/init/mysql.conf (data_dir)'
*[COOK-4198] - Added missing tunable'
*[COOK-4206] - create root@127.0.0.1, as well as root@localhost'

[4.0.20] - 2014-01-18

[COOK-3931] - MySQL Server Recipe Regression for Non-LTS Ubuntu Versions
[COOK-3945] - MySQL cookbook fails on Ubuntu 13.04/13.10
[COOK-3966] - mysql::server recipe can't find a template with debian 7.x
[COOK-3985] - Missing /etc/mysql/debian.cnf template on mysql::_server_debian.rb recipe (mysql 4.0.4)
[COOK-3974] - debian.cnf not updated
[COOK-4001] - Pull request: Fixes for broken mysql::server on Debian
[COOK-4071] - Mysql cookbook doesn't work on debian 7.2

[4.0.14]

Fixing style cops

[4.0.12]

Bug

[COOK-4068] - rework MySQL Windows recipe

Improvement

[COOK-3801] - Add innodb_adaptive_flushing_method and innodb_adaptive_checkpoint

[4.0.10]

fixing metadata version error. locking to 3.0

[4.0.8]

Locking yum dependency to '< 3'

[4.0.6]

Bug

[COOK-3943] Notifying service restart on grants update

[4.0.4]

[COOK-3952] - Adding 'recursive true' to directory resources

[4.0.2]

BUGS

Adding support for Amazon Linux in attributes/server_rhel.rb
Fixing bug where unprivileged users cannot connect over a local socket. Adding integration test.
Fixing bug in mysql_grants_cmd generation

[4.0.0]

[COOK-3928] Heavily refactoring for readability. Moving platform implementation into separate recipes
Moving integration tests from minitest to serverspec, removing "improper" tests
Moving many attributes into the ['mysql']['server']['whatever'] namespace
[COOK-3481] - Merged Lucas Welsh's Windows bits and moved into own recipe
[COOK-3697] - Adding security hardening attributes
[COOK-3780] - Fixing data_dir on Debian and Ubuntu
[COOK-3807] - Don't use execute[assign-root-password] on Debian and Ubuntu
[COOK-3881] - Fixing /etc being owned by mysql user

[3.0.12]

Bug

[COOK-3752] - mysql service fails to start in mysql::server recipe

[3.0.10]

Fix a failed release attempt for v3.0.8

[3.0.8]

Bug

[COOK-3749] - Fix a regression with Chef 11-specific features

[3.0.6]

Bug

[COOK-3674] - Fix an issue where the MySQL server fails to set the root password correctly when data_dir is a non-default value
[COOK-3647] - Fix README typo (databas => database)
[COOK-3477] - Fix log-queries-not-using-indexes not working
[COOK-3436] - Pull percona repo in compilation phase
[COOK-3208] - Fix README typo (LitenPort => ListenPort)
[COOK-3149] - Create my.cnf before installing
[COOK-2681] - Fix log_slow_queries for 5.5+
[COOK-2606] - Use proper bind address on cloud providers

Improvement

[COOK-3498] - Add support for replicate_* variables in my.cnf

[3.0.4]

Bug

[COOK-3310] - Fix missing GRANT option
[COOK-3233] - Fix escaping special characters
[COOK-3156] - Fix GRANTS file when remote_root_acl is specified
[COOK-3134] - Fix Chef 11 support
[COOK-2318] - Remove redundant if block around node.mysql.tunable.log_bin

[3.0.2]

Bug

[COOK-2158]: apt-get update is run twice at compile time
[COOK-2832]: mysql grants.sql file has errors depending on attrs
[COOK-2995]: server.rb is missing a platform_family comparison value

Sub-task

[COOK-2102]: innodb_flush_log_at_trx_commit value is incorrectly set based on CPU count

[3.0.0]

Note This is a backwards incompatible version with previous versions of the cookbook. Tickets that introduce incompatibility are COOK-2615 and COOK-2617.

[COOK-2478] - Duplicate 'read_only' server attribute in base and tunable
[COOK-2471] - Add tunable to set slave_compressed_protocol for reduced network traffic
[COOK-1059] - Update attributes in mysql cookbook to support missing options for my.cnf usable by Percona
[COOK-2590] - Typo in server recipe to do with conf_dir and confd_dir
[COOK-2602] - Add lower_case_table_names tunable
[COOK-2430] - Add a tunable to create a network ACL when allowing remote_root_access
[COOK-2619] - mysql: isamchk deprecated
[COOK-2515] - Better support for SUSE distribution for mysql cookbook
[COOK-2557] - mysql::percona_repo attributes missing and key server typo
[COOK-2614] - Duplicate innodb_file_per_table
[COOK-2145] - MySQL cookbook should remove anonymous and password less accounts
[COOK-2553] - Enable include directory in my.cnf template for any platform
[COOK-2615] - Rename key_buffer to key_buffer_size
[COOK-2626] - Percona repo URL is being constructed incorrectly
[COOK-2616] - Unneeded attribute thread_cache
[COOK-2618] - myisam-recover not using attribute value
[COOK-2617] - open-files is a duplicate of open-files-limit

[2.1.2]

[COOK-2172] - Mysql cookbook duplicates binlog_format configuration

[2.1.0]

[COOK-1669] - Using platform("ubuntu") in default attributes always returns true
[COOK-1694] - Added additional my.cnf fields and reorganized cookbook to avoid race conditions with mysql startup and sql script execution
[COOK-1851] - Support server-id and binlog_format settings
[COOK-1929] - Update msyql server attributes file because setting attributes without specifying a precedence is deprecated
[COOK-1999] - Add read_only tunable useful for replication slave servers

[2.0.2]

[COOK-1967] - mysql: trailing comma in server.rb platform family

[2.0.0]

Important note for this release

Under Chef Solo, you must set the node attributes for the root, debian and repl passwords or the run will completely fail. See COOK-1737 for background on this.

[COOK-1390] - MySQL service cannot start after reboot
[COOK-1610] - Set root password outside preseed (blocker for drop-in mysql replacements)
[COOK-1624] - Mysql cookbook fails to even compile on windows
[COOK-1669] - Using platform("ubuntu") in default attributes always returns true
[COOK-1686] - Add mysql service start
[COOK-1687] - duplicate innodb_buffer_pool_size attribute
[COOK-1704] - mysql cookbook fails spec tests when minitest-handler cookbook enabled
[COOK-1737] - Fail a chef-solo run when server_root_password, server_debian_password, and/or server_repl_password is not set
[COOK-1769] - link to database recipe in mysql README goes to old chef/cookbooks repo instead of chef-cookbook organization
[COOK-1963] - use platform_family

[1.3.0]

Important note for this release

This version no longer installs Ruby bindings in the client recipe by default. Use the ruby recipe if you'd like the RubyGem. If you'd like packages from your distribution, use them in your application's specific cookbook/recipe, or modify the client packages attribute. This resolves the following tickets:

COOK-932
COOK-1009
COOK-1384

Additionally, this cookbook now has tests (COOK-1439) for use under test-kitchen.

The following issues are also addressed in this release.

[COOK-1443] - MySQL (>= 5.1.24) does not support innodb_flush_method = fdatasync
[COOK-1175] - Add Mac OS X support
[COOK-1289] - handle additional tunable attributes
[COOK-1305] - add auto-increment-increment and auto-increment-offset attributes
[COOK-1397] - make the port an attribute
[COOK-1439] - Add MySQL cookbook tests for test-kitchen support
[COOK-1236] - Move package names into attributes to allow percona to free-ride
[COOK-934] - remove deprecated mysql/libraries/database.rb, use the database cookbook instead.
[COOK-1475] - fix restart on config change

[1.2.6]

[COOK-1113] - Use an attribute to determine if upstart is used
[COOK-1121] - Add support for Windows
[COOK-1140] - Fix conf.d on Debian
[COOK-1151] - Fix server_ec2 handling /var/lib/mysql bind mount
[COOK-1321] - Document setting password attributes for solo

[1.2.4]

[COOK-992] - fix FATAL nameerror
[COOK-827] - mysql:server_ec2 recipe can't mount data_dir
[COOK-945] - FreeBSD support

[1.2.2]

[COOK-826] mysql::server recipe doesn't quote password string
[COOK-834] Add 'scientific' and 'amazon' platforms to mysql cookbook

[1.2.1]

[COOK-644] Mysql client cookbook 'package missing' error message is confusing
[COOK-645] RHEL6/CentOS6 - mysql cookbook contains 'skip-federated' directive which is unsupported on MySQL 5.1

[1.2.0]

[COOK-684] remove mysql_database LWRP

[1.0.8]

[COOK-633] ensure "cloud" attribute is available

[1.0.7]

[COOK-614] expose all mysql tunable settings in config
[COOK-617] bind to private IP if available

[1.0.6]

[COOK-605] install mysql-client package on ubuntu/debian

[1.0.5]

[COOK-465] allow optional remote root connections to mysql
[COOK-455] improve platform version handling
externalize conf_dir attribute for easier cross platform support
change datadir attribute to data_dir for consistency

[1.0.4]

fix regressions on debian platform
[COOK-578] wrap root password in quotes
[COOK-562] expose all tunables in my.cnf

Collaborator Number Metric

12.0.0 passed this metric

Contributing File Metric

12.0.0 failed this metric

Failure: To pass this metric, your cookbook metadata must include a source url, the source url must be in the form of https://github.com/user/repo, and your repo must contain a CONTRIBUTING.md file

Cookstyle Metric

12.0.0 passed this metric

No Binaries Metric

12.0.0 passed this metric

Testing File Metric

12.0.0 failed this metric

Failure: To pass this metric, your cookbook metadata must include a source url, the source url must be in the form of https://github.com/user/repo, and your repo must contain a TESTING.md file

Version Tag Metric

12.0.0 failed this metric

Failure: To pass this metric, your cookbook metadata must include a source url, the source url must be in the form of https://github.com/user/repo, and your repo must include a tag that matches this cookbook version number

Adoptable Cookbooks List

Supermarket Belongs to the Community

View our collection of guides, documentation, and articles

Select Badges

Select Supported Platforms

Select Status

MySQL cookbook

Resources

Platforms

Migration to version 12

Testing

Licence

Dependent cookbooks

Contingent cookbooks

Changelog

12.0.0 (2026-11-12)

⚠ BREAKING CHANGES

Features

Bug Fixes

11.1.11 (2025-10-15)

Bug Fixes

11.1.7 - 2024-11-18

11.1.4 - 2023-10-03

11.1.0 - 2023-08-23

11.0.15 - 2023-07-10

11.0.14 - 2023-05-17

11.0.13 - 2023-04-04

11.0.12 - 2023-04-01

11.0.11 - 2023-04-01

11.0.10 - 2023-04-01

11.0.9 - 2023-03-13

11.0.8 - 2023-02-14

11.0.7 - 2022-12-21

11.0.6 - 2022-12-05

11.0.5 - 2022-04-20

11.0.4 - 2022-02-09

11.0.3 - 2022-02-02

11.0.2 - 2022-01-27

11.0.1 - 2022-01-08

11.0.0 - 2021-09-16

10.1.4 - 2021-08-30

10.1.3 - 2021-06-01

10.1.2 - 2021-03-26

10.1.1 - 2021-03-11

10.1.0 - 2021-03-11

10.0.2 - 2021-02-25

10.0.0 - 2021-01-25

9.0.0 - 2020-11-27

8.7.4 - 2020-09-16

8.7.3 - 2020-07-22

8.7.2 - 2020-06-02

8.7.1 - 2020-05-20

8.7.0 - 2020-05-05

[8.6.0] - 2019-12-03

[8.5.1] - 2017-08-23

[8.5.0] - 2017-08-23

[8.4.0] - 2017-05-30

[8.3.1] - 2017-04-04

[8.3.0] - 2017-03-20

[8.2.0] - 2016-12-03

[8.1.1] - 2016-10-31

[8.1.0] - 2016-10-29

[8.0.4] - 2016-09-26

[8.0.3] - 2016-09-14

[8.0.2] - 2016-08-25

[8.0.1] - 2016-07-20

[8.0.0] - 2016-07-11

[7.2.0] - 2016-06-30

[7.1.2] - 2016-06-30

[7.1.1] - 2016-06-03

[7.1.0] - 2016-05-11

[7.0.0] - 2016-04-19

[6.1.3] - 2016-03-14

[6.1.2] - 2015-10-05

[6.1.1] - 2015-09-24

[6.1.0] - 2015-07-17

[6.0.31] - 2015-07-13

[6.0.30] - 2015-07-13

[6.0.29] - 2015-07-12

[6.0.28] - 2015-07-10