[debian-mysql] Bug#797004: Bug#797004: mysql-server 5.5.44-0+deb8u1 not installable on fresh install of Stretch

[Norvald H. Ryeng]

On Wed, 26 Aug 2015 21:40:24 +0200, Randy <thejunk.b at gmail.com> wrote:

> Package: mysql-server-5.5
> Version: 5.5.44-0+deb8u1
> Severity: important
>
> Dear Maintainer,
>
>    * What led up to the situation?
> Trying to setup MythTV which requires mysql-server. Tried to install and  
> it
> failed.  This machine is a fresh install of Stretch (testing).  If I  
> remember
> right, been a week since, mariadb was removed so mysql could be installed
>
> I have searched but not found this exact issue.  When the install is  
> attempted
> it asks for a root password then fails.
>
> from /var/log/mysql/error.log
>
> 150826 14:30:29 mysqld_safe Starting mysqld daemon with databases from
> /var/lib/mysql
> 150826 14:30:29 [Warning] Using unique option prefix key_buffer instead  
> of
> key_buffer_size is deprecated and will be removed in a future release.  
> Please
> use the full
> name instead.
> 150826 14:30:29 [Note] /usr/sbin/mysqld (mysqld 5.5.44-0+deb8u1)  
> starting as
> process 30358
> 150826 14:30:29 [Warning] Using unique option prefix myisam-recover  
> instead of
> myisam-recover-options is deprecated and will be removed in a future  
> release.
> Please use
> the full name instead.
> 150826 14:30:29 [Note] Plugin 'FEDERATED' is disabled.
> /usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
> 150826 14:30:29 [ERROR] Can't open the mysql.plugin table. Please run
> mysql_upgrade to create it.
> 150826 14:30:29 InnoDB: The InnoDB memory heap is disabled
> 150826 14:30:29 InnoDB: Mutexes and rw_locks use GCC atomic builtins
> 150826 14:30:29 InnoDB: Compressed tables use zlib 1.2.8
> 150826 14:30:29 InnoDB: Using Linux native AIO
> 150826 14:30:29 InnoDB: Initializing buffer pool, size = 128.0M
> 150826 14:30:29 InnoDB: Completed initialization of buffer pool
> 150826 14:30:29 InnoDB: highest supported file format is Barracuda.
> 150826 14:30:29  InnoDB: Waiting for the background threads to start
> 150826 14:30:30 InnoDB: 5.5.44 started; log sequence number 1595675
> 150826 14:30:30 [ERROR] /usr/sbin/mysqld: unknown variable 'plugin-load-
> add=unix_socket=auth_socket.so'
> 150826 14:30:30 [ERROR] Aborting

This is the problem. The MariaDB packages have put options in  
/etc/mysql/my.cnf that are not valid MySQL options, so the MySQL server  
will refuse to start. An apt-get purge of MariaDB packages before trying  
to install MySQL should fix it.

Regards,

Norvald H. Ryeng