Debian Codegraph @

debian/NEWS

raw
1 mysql-5.7 (5.7.20-2) unstable; urgency=medium
2
3 Further to the change described in the previous NEWS entry, we now no
4 longer prompt for the root password by default; the debconf priority
5 for this question has been lowered to "medium".
6
7 Rationale: in the "localhost" case, setting a root password is no
8 longer appropriate security practice. Unix socket authentication
9 should be used instead, and this operates automatically and by default
10 when the root password is not set.
11
12 Users who require remote access to the MySQL server can still set a
13 root password by requesting lower priority debconf prompts.
14
15 -- Robie Basak <[email protected]> Fri, 12 Jan 2018 11:45:00 +0100
16
17 mysql-5.7 (5.7.13-1~exp1) experimental; urgency=medium
18
19 Password behaviour when the MySQL root password is empty has
20 changed. Packaging now enables socket authentication when the MySQL
21 root password is empty. This means that a non-root user can't log in
22 as the MySQL root user with an empty password. The new logic is as
23 follows:
24
25 - The auth_socket plugin will be installed automatically only if it
26 is to be activated for the root user.
27
28 - The auth_socket plugin will be activated for the root user:
29
30 + If you had a database before with an empty root password.
31
32 + If you create a new database with an empty root password.
33
34 - The auth_socket plugin will NOT be activated for the root user:
35
36 + If you had a database before with a root password set.
37
38 + If you create a new database with a root password set.
39
40 - The auth_socket plugin will NOT be activated for any other user.
41
42 - If you do not want the new behaviour, set the MySQL root password
43 to be non-empty.
44
45
46 The MySQL server now uses strict mode by default. See
47 http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sql-mode-strict
48 for details. See
49 http://dev.mysql.com/doc/refman/5.6/en/sql-mode.html#sql-mode-setting
50 for details about the default settings in older versions.
51
52 -- Robie Basak <[email protected]> Fri, 15 Jul 2016 03:15:14 +0200