Install the MySQL client and/or server.

Meta-state that includes all server packages in the correct order.

This meta-state does not include mysql.remove_test_database; see below for details.

Install the MySQL client package.

Install the MySQL server package and start the service.

Debian OS family supports setting MySQL root password during install via debconf.

Create and manage MySQL databases.

Install mysql python bindings.

Create and manage MySQL database users with definable GRANT privileges.

The state accepts MySQL hashed passwords or clear text. Hashed password have priority.

Remove the database called test, normally created as part of a default MySQL installation. This state is not included as part of the meta-state above as this name may conflict with a real database.

The supported_params.yaml file contains the full listing of options that are acceptable in the MySQL options file. On occassion, especially on new releases of MySQL, this file may need to be updated. To update, run the supplied script (requires Python 3.x):

./scripts/parse_supported_params.py -o ./mysql/supported_params.yaml

This script will scrape the options from the official MySQL documentation online, and thus requires web access. Scraping is inherently brittle, though this script has been defensively coded, where possible.

Once the supported_params.yaml file has been updated, commit the result to the repository.

To add support for configuration of other MySQL applications, add the URL and section identifier into the relevant section of the script. Consult the comments in the code to determine where your section should be added.