无法升级ubuntu 16.04 - mysql依赖关系问题

Question

ubuntu 16.04.3 -当试图做：

sudo apt-get update 

我得到的是：

Reading package lists... Done
Building dependency tree
Reading state information... Done
Calculating upgrade... Done
The following packages have been kept back:
  libegl1-mesa libgl1-mesa-dri libinput10 libmirclient9 libwayland-egl1-mesa libxatracker2
  linux-headers-generic linux-headers-virtual linux-image-virtual linux-virtual
0 upgraded, 0 newly installed, 0 to remove and 10 not upgraded.
2 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Do you want to continue? [Y/n] Y
Setting up mysql-server-5.7 (5.7.19-0ubuntu0.16.04.1) ...
ERROR: Unable to start MySQL server:
2017-09-04T11:14:27.542500Z 0 [ERROR] unknown variable 'validate_password_check_user_name=1'
2017-09-04T11:14:27.546320Z 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
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-5.7; however:
  Package mysql-server-5.7 is not configured yet.

dpkg: error processing package mysql-server (--configure):
 dependency problems - leaving unconfigured
No apport report written because the error message indicates its a followup error from a previous failure.
      Errors were encountered while processing:
 mysql-server-5.7
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

Answer 1

我也有同样的问题，很可能是因为安装/测试/删除了很多软件。我通过清除和重新安装mysql服务器来解决这个问题。

apt-get purge mysql-common

当然，在清除mysql数据之前要处理好它。我不确定你的数据是否能通过上面的命令行。我不在乎我的数据，因为它只是我用来测试的垃圾。

希望这能有所帮助。

TomTomTom

Answer 2

我需要这样安装mysql：

https://www.digitalocean.com/community/tutorials/how-to-install-the-latest-mysql-on-ubuntu-16-04

现在工作正常了。