[debian-mysql] Bug#805828: Bug#805828: mysql-server-5.6: upgrade didn't work, package unusable, mysql does not start

[jp.pozzi at izzop.net]

Hello,

After creating the "/etc/mysql/conf.d directory" I try to do a fresh
install with :
-----------------------------------------------------------------------
apt-get install mysql-server
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following extra packages will be installed:
  mysql-server-5.6 mysql-server-core-5.6
Suggested packages:
  tinyca
The following NEW packages will be installed:
  mysql-server mysql-server-5.6 mysql-server-core-5.6
0 upgraded, 3 newly installed, 0 to remove and 0 not upgraded.
Need to get 10,2 MB of archives.
After this operation, 79,4 MB of additional disk space will be used.
Do you want to continue? [O/n] 
Ask 2 times for root password
Get:1 http://ftp.fr.debian.org/debian/ stretch/main mysql-server-core-
5.6 amd64 5.6.27-2 [4 379 kB]
Get:2 http://ftp.fr.debian.org/debian/ stretch/main mysql-server-5.6
amd64 5.6.27-2 [5 676 kB]
Get:3 http://ftp.fr.debian.org/debian/ stretch/main mysql-server all
5.6.27-2 [102 kB]
Preconfiguring packages ...
Fetched 10,2 MB in 4s (2 160 kB/s)
Selecting previously unselected package mysql-server-core-5.6.
(Reading database ... 539834 files and directories currently
installed.)
Preparing to unpack .../mysql-server-core-5.6_5.6.27-2_amd64.deb ...
Unpacking mysql-server-core-5.6 (5.6.27-2) ...
Selecting previously unselected package mysql-server-5.6.
Preparing to unpack .../mysql-server-5.6_5.6.27-2_amd64.deb ...
Unpacking mysql-server-5.6 (5.6.27-2) ...
Selecting previously unselected package mysql-server.
Preparing to unpack .../mysql-server_5.6.27-2_all.deb ...
Unpacking mysql-server (5.6.27-2) ...
Processing triggers for man-db (2.7.5-1) ...
Processing triggers for systemd (227-2) ...
Setting up mysql-server-core-5.6 (5.6.27-2) ...
Setting up mysql-server-5.6 (5.6.27-2) ...
update-alternatives: using /etc/mysql/mysql.cnf to provide
/etc/mysql/my.cnf (my.cnf) in auto mode
2015-11-23 12:29:26 0 [Warning] TIMESTAMP with implicit DEFAULT value
is deprecated. Please use --explicit_defaults_for_timestamp server
option (see documentation for more details).
2015-11-23 12:29:26 0 [Note] /usr/sbin/mysqld (mysqld 5.6.27-2)
starting as process 21919 ...
Setting up mysql-server (5.6.27-2) ...
Processing triggers for systemd (227-2) ...
----------------------------------------------------------------------

All is OK, mysql is started and I can connect to the database, the
/etc/mysql directory contains :
----------------------------------------------------------------------
ls -alR
.:
total 40
drwxr-xr-x   4 root root  4096 nov.  23 12:29 .
drwxr-xr-x 218 root root 16384 nov.  23 12:03 ..
drwxr-xr-x   2 root root  4096 nov.  23 12:24 conf.d
-rw-------   1 root root   333 nov.  23 12:03 debian.cnf
-rwxr-xr-x   1 root root  1193 nov.  11 13:18 debian-start
lrwxrwxrwx   1 root root    24 nov.  23 12:29 my.cnf ->
/etc/alternatives/my.cnf
-rw-r--r--   1 root root   682 nov.  10 12:49 mysql.cnf
drwxr-xr-x   2 root root  4096 nov.  23 12:29 mysql.conf.d

./conf.d:
total 8
drwxr-xr-x 2 root root 4096 nov.  23 12:24 .
drwxr-xr-x 4 root root 4096 nov.  23 12:29 ..

./mysql.conf.d:
total 16
drwxr-xr-x 2 root root 4096 nov.  23 12:29 .
drwxr-xr-x 4 root root 4096 nov.  23 12:29 ..
-rw-r--r-- 1 root root 3027 nov.  10 12:49 mysqld.cnf
-rw-r--r-- 1 root root   21 nov.  10 12:49 mysqld_safe_syslog.cnf
-----------------------------------------------------------------------
The "conf.d" directory doesn't contain any file.

I will now reload some data ...


JPP