4.0.1

Release Summary

This is a patch release of the community.mysql collection.
This changelog contains all breaking changes to the modules in this collection
that have been added after the previous release.

Bugfixes

• mysql_info - Fix slave status for source terminology introduced in MySQL 8.0.23 (#682).
• mysql_user, mysql_role - fix not existent grant when revoking perms on user/role which do not have any other perms than grant option (#664).

3.16.1

Release Summary

This is a patch release of the community.mysql collection.
This changelog contains all changes to the modules and plugins in this collection
that have been made after the previous release.

Bugfixes

• mysql_info - Fix slave status for source terminology introduced in MySQL 8.0.23 (#682).
• mysql_user, mysql_role - fix not existent grant when revoking perms on user/role which do not have any other perms than grant option (#664).

4.0.0

Release Summary

This is a major release of the community.mysql collection.
This changelog contains all breaking changes to the modules in this collection
that have been added after the release of community.mysql 3.16.0.

Breaking Changes / Porting Guide

• Since version 4.0.0, the collection accepts code written in Python 3. Modules aren't tested against Python 2 and might not work in Python 2 environments.
• collection - stop testing against mysqlclient connector as its support was deprecated in this collection - use PyMySQL connector instead! It'll stop working in 5.0.0 when we remove all related code (#654).
• mysql_db - the pipefail argument's default value is set to true. If your target machines do not use bash as a default interpreter, set pipefail to false explicitly. However, we strongly recommend setting up bash as a default and pipefail=true as it will protect you from getting broken dumps you don't know about (#407).
• mysql_info - The users_info filter does not return the plugin_auth_string field anymore. Use the plugin_hash_string return value instead (#629).
• mysql_role - the column_case_sensitive argument's default value has been changed to true. If your playbook expected the column to be automatically uppercased for your users privileges, you should set this to false explicitly (#578).
• mysql_user - the column_case_sensitive argument's default value has been changed to true. If your playbook expected the column to be automatically uppercased for your users privileges, you should set this to false explicitly (#577).

3.16.0

Release Summary

This is the minor release of the community.mysql collection.
This changelog contains all changes to the modules and plugins in this collection
that have been made after the previous release.

Minor Changes

• mysql_query - add new session_vars argument, similar to #489.

3.15.0

Release Summary

This is a minor release of the community.mysql collection.
This changelog contains all changes to the modules and plugins in this collection
that have been made after the previous release.'

Minor Changes

• mysql_db - Add support for sql_log_bin option (#700).

Bugfixes

• mysql_query - fix a Python 2 compatibility issue caused by the addition of execution_time_ms in version 3.12 (see #716).
• mysql_user - fix a crash (unable to parse the MySQL grant string: SET DEFAULT ROLE somerole FOR someuser@%) when using the mysql_user module with a DEFAULT role present in MariaDB. The DEFAULT role is now ignored by the parser (#710).

3.14.0

Release Summary

This is a minor release of the community.mysql collection.
This changelog contains all changes to the modules and plugins in this
collection that have been made after the previous release.

Minor Changes

• mysql_replication - change default value for primary_ssl_verify_server_cert from False to None. This should not affect existing playbooks by @laurent-indermuehle in #707
• Add action group containing all modules by @JockeTF in #704

Bugfixes

• mysql_info - fix a crash (ERROR 1141, There is no such grant defined for user 'PUBLIC' on host '%') when using the users_info filter with a PUBLIC role present in MariaDB 10.11+. by @laurent-indermuehle in #712
• mysql_replication - fixed an issue where setting primary_ssl_verify_server_cert to false had no effect by @ldangeard-orange in #689

3.13.0

Release Summary

This is a minor release of the community.mysql collection.
This changelog contains all changes to the modules and plugins in this
collection that have been made after the previous release.

Minor Changes

• Integration tests for MariaDB 11.4 have replaced those for 10.5. The previous version is now 10.11.
• mysql_user - add locked option to lock/unlock users, this is mainly used to have users that will act as definers on stored procedures.

Bugfixes

• mysql_db - fix dump and import to find MariaDB binaries (mariadb and mariadb-dump) when MariaDB 11+ is used and symbolic links to MySQL binaries are absent.

3.12.0

Release Summary

This is a minor release of the community.mysql collection.
This changelog contains all changes to the modules and plugins in this
collection that have been made after the previous release.

Minor Changes

• mysql_db - added zstd (de)compression support for import/dump states (#696).
• mysql_query - returns the execution_time_ms list containing execution time per query in milliseconds.

3.11.0

Release Summary

This is a minor release of the community.mysql collection.
This changelog contains all changes to the modules and plugins in this collection that have been made after the previous release.

Minor Changes

• mysql_info - adds the count of tables for each database to the returned values. It is possible to exclude this new field using the db_table_count exclusion filter. (#691)

Bugfixes

• mysql_user,mysql_role - The sql_mode ANSI_QUOTES affects how the modules mysql_user and mysql_role compare the existing privileges with the configured privileges, as well as decide whether double quotes or backticks should be used in the GRANT statements. Pointing out in issue 671, the modules mysql_user and mysql_role allow users to enable/disable ANSI_QUOTES in session variable (within a DB session, the session variable always overwrites the global one). But due to the issue, the modules do not check for ANSI_MODE in the session variable, instead, they only check in the GLOBAL one.That behavior is not only limiting the users' flexibility, but also not allowing users to explicitly disable ANSI_MODE to work around such bugs like https://bugs.mysql.com/bug.php?id=115953. (#671)

3.10.3

Release Summary

This is a bugfix release of the community.mysql collection.
This changelog contains all changes to the modules and plugins in this
collection that have been made after the previous release.

Bugfixes

• mysql_user - add correct ed25519 auth plugin handling when creating a user (#676).