[mythtv-users] MYSQL problems on upgrade to ubuntu 16.04

[Jack McGee]

On 08/28/2016 07:09 PM, Bill Meek wrote:
> On 08/28/2016 03:29 PM, Jack McGee wrote:
>
> ...
>
>
> At the risk of mentioning the  obvious, both MariaDB and
> MySQL are installed. I'd double check, but then run the
>
>     sudo apt autoremove
>
> command mentioned in the update messages. Or, at least make
> sure they aren't both running on the same port at the same
> time.
>
mythuser at amethi:~$ sudo apt autoremove
[sudo] password for mythuser:
Reading package lists... Done
Building dependency tree
Reading state information... Done
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
1 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Setting up mysql-server-5.7 (5.7.13-0ubuntu0.16.04.2) ...
Renaming removed key_buffer and myisam-recover options (if present)
ERROR: Unable to start MySQL server:
2016-08-29T00:13:37.621528Z 0 [ERROR] unknown variable 'table_cache=128'
2016-08-29T00:13:37.623814Z 0 [ERROR] Aborting
Please take a look at https://wiki.debian.org/Teams/MySQL/FAQ for tips 
on fixing common upgrade issues.
Once the problem is resolved, run apt-get --fix-broken install to retry.
dpkg: error processing package mysql-server-5.7 (--configure):
  subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
  mysql-server-5.7
E: Sub-process /usr/bin/dpkg returned an error code (1)


Per Mark Perkins, I edited

/etc/mysql/conf.d/mythtv.cnf

and then ran:

and mythuser at amethi:~$ sudo apt-get autoremove
Reading package lists... Done
Building dependency tree
Reading state information... Done
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
1 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Setting up mysql-server-5.7 (5.7.13-0ubuntu0.16.04.2) ...
Renaming removed key_buffer and myisam-recover options (if present)
insserv: warning: script 'K02vncserver' missing LSB tags and overrides
insserv: warning: script 'vncserver.nogood' missing LSB tags and overrides
insserv: warning: script 'vncserver' missing LSB tags and overrides
mysql_upgrade: Got error: 1524: Plugin 'unix_socket' is not loaded while 
connecting to the MySQL server
Upgrade process encountered error and will not continue.
mysql_upgrade failed with exit status 11
dpkg: error processing package mysql-server-5.7 (--configure):
  subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
  mysql-server-5.7
E: Sub-process /usr/bin/dpkg returned an error code (1)




I am not smart enough to know how to put MariaDB and Mysql on different 
ports.  Not sure how or when MariaDB got installed.