1======================================== 2Community MySQL Collection Release Notes 3======================================== 4 5.. contents:: Topics 6 7 8v2.3.0 9====== 10 11Release Summary 12--------------- 13 14This is the minor release of the ``community.mysql`` collection. 15This changelog contains all changes to the modules in this collection that 16have been added after the release of ``community.mysql`` 2.2.0. 17 18Minor Changes 19------------- 20 21- mysql_user - replace VALID_PRIVS constant by get_valid_privs() function (https://github.com/ansible-collections/community.mysql/pull/217). 22 23Bugfixes 24-------- 25 26- mysql_info - fix TypeError failure when there are databases that do not contain tables (https://github.com/ansible-collections/community.mysql/issues/204). 27 28v2.2.0 29====== 30 31Release Summary 32--------------- 33 34This is the minor release of the ``community.mysql`` collection. 35This changelog contains all changes to the modules in this collection that 36have been added after the release of ``community.mysql`` 2.1.1 37 38New Modules 39----------- 40 41- mysql_role - Adds, removes, or updates a MySQL role 42 43v2.1.1 44====== 45 46Release Summary 47--------------- 48 49This is the patch release of the ``community.mysql`` collection. 50This changelog contains all changes to the modules in this collection that 51have been added after the release of ``community.mysql`` 2.1.0. 52 53Minor Changes 54------------- 55 56- mysql_query - correctly reflect changed status in replace statements (https://github.com/ansible-collections/community.mysql/pull/193). 57 58v2.1.0 59====== 60 61Release Summary 62--------------- 63 64This is the minor release of the ``community.mysql`` collection. 65This changelog contains all changes to the modules in this collection 66that have been added after the release of ``community.mysql`` 2.0.0. 67 68Major Changes 69------------- 70 71- mysql_replication - add deprecation warning that the ``Is_Slave`` and ``Is_Master`` return values will be replaced with ``Is_Primary`` and ``Is_Replica`` in ``community.mysql`` 3.0.0 (https://github.com/ansible-collections/community.mysql/pull/147). 72- mysql_replication - the choices of the ``state`` option containing ``master`` will be finally replaced with the alternative ``primary`` choices in ``community.mysql`` 3.0.0, add deprecation warnings (https://github.com/ansible-collections/community.mysql/pull/150). 73 74Minor Changes 75------------- 76 77- mysql_replication - add alternative (``primary``) choices to the ``state`` option choices containing ``master`` (https://github.com/ansible-collections/community.mysql/pull/150). 78- mysql_replication - add the ``Is_Primary`` and ``Is_Replica`` alternatives to the ``Is_Slave`` and ``Is_Master`` return values as a preparation for replacement in ``community.mysql`` 3.0.0 (https://github.com/ansible-collections/community.mysql/pull/147). 79- mysql_replication - change ``master_`` options to ``primary_`` options, add aliases to keep compatibility (https://github.com/ansible-collections/community.mysql/pull/150). 80 81Bugfixes 82-------- 83 84- mysql - revert changes of connector arguments made in pull request 116 causing the invalid keyword argument error (https://github.com/ansible-collections/community.mysql/pull/116). 85 86v2.0.0 87====== 88 89Release Summary 90--------------- 91 92This is release 2.0.0 of the ``community.mysql`` collection, released on 2021-04-15. 93 94Major Changes 95------------- 96 97- mysql_replication - the return value ``Is_Slave`` and ``Is_Master`` will be replaced with ``Is_Replica`` and ``Is_Primary`` in ``community.mysql`` 3.0.0 (https://github.com/ansible-collections/community.mysql/issues/145). 98- mysql_replication - the word ``master`` in messages returned by the module will be replaced with ``primary`` in ``community.mysql`` 3.0.0 (https://github.com/ansible-collections/community.mysql/issues/145). 99- mysql_replication - the word ``slave`` in messages returned by the module replaced with ``replica`` (https://github.com/ansible-collections/community.mysql/issues/98). 100- mysql_user - the ``REQUIRESSL`` is an alias for the ``ssl`` key in the ``tls_requires`` option in ``community.mysql`` 2.0.0 and support will be dropped altogether in ``community.mysql`` 3.0.0 (https://github.com/ansible-collections/community.mysql/issues/121). 101 102Minor Changes 103------------- 104 105- mysql module utils - change deprecated connection parameters ``passwd`` and ``db`` to ``password`` and ``database`` (https://github.com/ansible-collections/community.mysql/pull/116). 106- mysql_collection - introduce codebabse split to handle divergences between MySQL and MariaDB (https://github.com/ansible-collections/community.mysql/pull/103). 107- mysql_info - add `version.full` and `version.suffix` return values (https://github.com/ansible-collections/community.mysql/issues/114). 108- mysql_user - deprecate the ``REQUIRESSL`` privilege (https://github.com/ansible-collections/community.mysql/issues/101). 109 110Bugfixes 111-------- 112 113- mysql_user - add support for ``REPLICA MONITOR`` privilege (https://github.com/ansible-collections/community.mysql/issues/105). 114 115v1.3.0 116====== 117 118Release Summary 119--------------- 120 121This is the minor release of the ``community.mysql`` collection. 122This changelog contains all changes to the modules in this collection 123that have been added after the release of ``community.mysql`` 1.2.0. 124 125Major Changes 126------------- 127 128- mysql_replication - the mode options values ``getslave``, ``startslave``, ``stopslave``, ``resetslave``, ``resetslaveall` and the master_use_gtid option ``slave_pos`` are deprecated (see the alternative values) and will be removed in ``community.mysql`` 3.0.0 (https://github.com/ansible-collections/community.mysql/pull/97). 129- mysql_replication - the word ``SLAVE`` in messages returned by the module will be changed to ``REPLICA`` in ``community.mysql`` 2.0.0 (https://github.com/ansible-collections/community.mysql/issues/98). 130 131Minor Changes 132------------- 133 134- mysql_replication - deprecate offending terminology, add alternative choices to the ``mode`` option (https://github.com/ansible-collections/community.mysql/issues/78). 135 136Bugfixes 137-------- 138 139- mysql_user - fix handling of INSERT, UPDATE, REFERENCES on columns (https://github.com/ansible-collections/community.mysql/issues/106). 140- mysql_user - the module is not idempotent when SELECT on columns granted (https://github.com/ansible-collections/community.mysql/issues/99). 141 142v1.2.0 143====== 144 145Release Summary 146--------------- 147 148This is the minor release of the ``community.mysql`` collection. 149This changelog contains all changes to the modules in this collection 150that have been added after the release of ``community.mysql`` 1.1.2. 151 152Minor Changes 153------------- 154 155- mysql_user - refactor to reduce cursor.execute() calls in preparation for adding query logging (https://github.com/ansible-collections/community.mysql/pull/76). 156 157Bugfixes 158-------- 159 160- mysql_user - add ``SHOW_ROUTINE`` privilege support (https://github.com/ansible-collections/community.mysql/issues/86). 161- mysql_user - fixed creating user with encrypted password in MySQL 8.0 (https://github.com/ansible-collections/community.mysql/pull/79). 162 163v1.1.2 164====== 165 166Release Summary 167--------------- 168 169This is the patch release of the ``community.mysql`` collection. 170This changelog contains all changes to the modules in this collection that 171have been added after the release of ``community.mysql`` 1.1.1. 172 173Minor Changes 174------------- 175 176- mysql_query - simple refactoring of query type check (https://github.com/ansible-collections/community.mysql/pull/58). 177- mysql_user - simple refactoring of priv type check (https://github.com/ansible-collections/community.mysql/pull/58). 178 179Bugfixes 180-------- 181 182- mysql_db - fix false warning related to ``unsafe_login_password`` option (https://github.com/ansible-collections/community.mysql/issues/33). 183- mysql_replication - fix crashes of mariadb >= 10.5.1 and mysql >= 8.0.22 caused by using deprecated terminology (https://github.com/ansible-collections/community.mysql/issues/70). 184- mysql_user - fixed change detection when using append_privs (https://github.com/ansible-collections/community.mysql/pull/72). 185 186v1.1.1 187====== 188 189Release Summary 190--------------- 191 192This is the patch release of the ``community.mysql`` collection. 193This changelog contains all changes to the modules in this collection that 194have been added after the release of ``community.mysql`` 1.1.0. 195 196 197Bugfixes 198-------- 199 200- mysql_query - fix failing when single-row query contains commas (https://github.com/ansible-collections/community.mysql/issues/51). 201 202v1.1.0 203====== 204 205Release Summary 206--------------- 207 208This is the minor release of the ``community.mysql`` collection. 209This changelog contains all changes to the modules in this collection that have been added after the release of ``community.mysql`` 1.0.2. 210 211 212Minor Changes 213------------- 214 215- mysql modules - add the ``check_hostname`` option (https://github.com/ansible-collections/community.mysql/issues/28). 216- mysql modules - patch the ``Connection`` class to add a destructor that ensures connections to the server are explicitly closed (https://github.com/ansible-collections/community.mysql/pull/44). 217 218Bugfixes 219-------- 220 221- mysql modules - fix crash when ``!includedir`` option is in config file (https://github.com/ansible-collections/community.mysql/issues/46). 222 223v1.0.2 224====== 225 226Release Summary 227--------------- 228 229This is the patch release of the ``community.mysql`` collection. 230This changelog contains all changes to the modules in this collection that have been added after the release of ``community.mysql`` 1.0.1. 231 232 233Bugfixes 234-------- 235 236- mysql_user - fix module's crash when modifying a user with ``host_all`` (https://github.com/ansible-collections/community.mysql/issues/39). 237 238v1.0.1 239====== 240 241Release Summary 242--------------- 243 244This is the patch release of the ``community.mysql`` collection. 245This changelog contains all changes to the modules in this collection that have been added after the release of ``community.mysql`` 1.0.0. 246 247 248Bugfixes 249-------- 250 251- mysql_db - fix false warning related to ``unsafe_login_password`` option (https://github.com/ansible-collections/community.mysql/issues/33). 252- mysql_user - added tests to verify that TLS requirements are removed with an empty ``tls_requires`` option (https://github.com/ansible-collections/community.mysql/issues/20). 253- mysql_user - correct procedure to check existing TLS requirements (https://github.com/ansible-collections/community.mysql/pull/26). 254- mysql_user - minor syntax fixes (https://github.com/ansible-collections/community.mysql/pull/26). 255 256v1.0.0 257====== 258 259Release Summary 260--------------- 261 262This is the first proper release of the ``community.mysql`` collection. 263This changelog contains all changes to the modules in this collection that were added after the release of Ansible 2.9.0. 264 265 266Minor Changes 267------------- 268 269- mysql_db - add ``master_data`` parameter (https://github.com/ansible/ansible/pull/66048). 270- mysql_db - add ``skip_lock_tables`` option (https://github.com/ansible/ansible/pull/66688). 271- mysql_db - add the ``check_implicit_admin`` parameter (https://github.com/ansible/ansible/issues/24418). 272- mysql_db - add the ``dump_extra_args`` parameter (https://github.com/ansible/ansible/pull/67747). 273- mysql_db - add the ``executed_commands`` returned value (https://github.com/ansible/ansible/pull/65498). 274- mysql_db - add the ``force`` parameter (https://github.com/ansible/ansible/pull/65547). 275- mysql_db - add the ``restrict_config_file`` parameter (https://github.com/ansible/ansible/issues/34488). 276- mysql_db - add the ``unsafe_login_password`` parameter (https://github.com/ansible/ansible/issues/63955). 277- mysql_db - add the ``use_shell`` parameter (https://github.com/ansible/ansible/issues/20196). 278- mysql_info - add ``exclude_fields`` parameter (https://github.com/ansible/ansible/issues/63319). 279- mysql_info - add ``global_status`` filter parameter option and return (https://github.com/ansible/ansible/pull/63189). 280- mysql_info - add ``return_empty_dbs`` parameter to list empty databases (https://github.com/ansible/ansible/issues/65727). 281- mysql_replication - add ``channel`` parameter (https://github.com/ansible/ansible/issues/29311). 282- mysql_replication - add ``connection_name`` parameter (https://github.com/ansible/ansible/issues/46243). 283- mysql_replication - add ``fail_on_error`` parameter (https://github.com/ansible/ansible/pull/66252). 284- mysql_replication - add ``master_delay`` parameter (https://github.com/ansible/ansible/issues/51326). 285- mysql_replication - add ``master_use_gtid`` parameter (https://github.com/ansible/ansible/pull/62648). 286- mysql_replication - add ``queries`` return value (https://github.com/ansible/ansible/pull/63036). 287- mysql_replication - add support of ``resetmaster`` choice to ``mode`` parameter (https://github.com/ansible/ansible/issues/42870). 288- mysql_user - ``priv`` parameter can be string or dictionary (https://github.com/ansible/ansible/issues/57533). 289- mysql_user - add TLS REQUIRES parameters (https://github.com/ansible-collections/community.mysql/pull/9). 290- mysql_user - add ``plugin_auth_string`` parameter (https://github.com/ansible/ansible/pull/44267). 291- mysql_user - add ``plugin_hash_string`` parameter (https://github.com/ansible/ansible/pull/44267). 292- mysql_user - add ``plugin`` parameter (https://github.com/ansible/ansible/pull/44267). 293- mysql_user - add the resource_limits parameter (https://github.com/ansible-collections/community.general/issues/133). 294- mysql_variables - add ``mode`` parameter (https://github.com/ansible/ansible/issues/60119). 295 296Bugfixes 297-------- 298 299- mysql - dont mask ``mysql_connect`` function errors from modules (https://github.com/ansible/ansible/issues/64560). 300- mysql_db - fix Broken pipe error appearance when state is import and the target file is compressed (https://github.com/ansible/ansible/issues/20196). 301- mysql_db - fix bug in the ``db_import`` function introduced by https://github.com/ansible/ansible/pull/56721 (https://github.com/ansible/ansible/issues/65351). 302- mysql_info - add parameter for __collect to get only what are wanted (https://github.com/ansible-collections/community.general/pull/136). 303- mysql_replication - allow to pass empty values to parameters (https://github.com/ansible/ansible/issues/23976). 304- mysql_user - Fix idempotence when long grant lists are used (https://github.com/ansible/ansible/issues/68044) 305- mysql_user - Remove false positive ``no_log`` warning for ``update_password`` option 306- mysql_user - add ``INVOKE LAMBDA`` privilege support (https://github.com/ansible-collections/community.general/issues/283). 307- mysql_user - add missed privileges to support (https://github.com/ansible-collections/community.general/issues/617). 308- mysql_user - fix ``host_all`` arguments conversion string formatting error (https://github.com/ansible/ansible/issues/29644). 309- mysql_user - fix overriding password to the same (https://github.com/ansible-collections/community.general/issues/543). 310- mysql_user - fix support privileges with underscore (https://github.com/ansible/ansible/issues/66974). 311- mysql_user - fix the error No database selected (https://github.com/ansible/ansible/issues/68070). 312- mysql_user - make sure current_pass_hash is a string before using it in comparison (https://github.com/ansible/ansible/issues/60567). 313- mysql_variable - fix the module doesn't support variables name with dot (https://github.com/ansible/ansible/issues/54239). 314