| 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 |