Ubuntu重新安装MySQL错误解决

新搭建的服务器,先在Ubuntu上安装mariadb,后来由于很多权限问题,决定安装MySQL,由于在卸载过程中未卸载干净,导致MySQL重新安装过程中出现了很多问题。

Reading package lists...Done
Building dependency tree
Reading state information ... Done
mysql-server is already the newest version(5.7.21-0ubuntu0.16.04.1).
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
mysql-server: depends: mysql-server-5.7 but it is not going to be installed
E: Unmet dependencies.Try 'apt-get -f install' with no packages(or specify a solution).

通过阅读错误信息可知,主要是因为依赖关系出现问题,主要思路是重建依赖关系,然后干净卸载,最后重装。

首先,更新系统

sudo apt-get update

然后,修复安装错误,会提示输入mysql用户名密码

sudo apt-get --fix-broken install

然后,检索mysql安装包,并删除检索出的依赖包,然后是删除/var/lib/mysql,最后重装mysql。

下面我把检索到的解决方法展示给大家:

We excute the following commands to solve the above problem:
    1.Get the list of MySQL packages installed on the system by executing the command sudo dpkg -l grep mysql
    2.Remove the packages shown above by executing the command
      sudo apt-get --purge autoremove <packages from the step 1>
    3. Delete /var/lib/mysql
    4.Try to install mysql again.It should solve your problem.

第二步中的packages如下图所示:

Ubuntu重新安装MySQL错误解决

最后就是更新系统并重装mysql

sudo apt-get update

sudo apt-get install mysql-server mysql-client

总结:

整体思路还是重建依赖关系,干净卸载,更新安装。希望对遇到相同问题不知所措的小伙伴有所启发、帮助。谢谢。

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/d6c73427f77d4965ed791b38545565a7.html