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