MySQL 彻底卸载与安装

今天MYSQL抽风，不知道怎么的就无法连接了总是报Can't connect to local MySQL server through socket ' /var/lib/mysql/mysql.sock'的错误（出现这个问题可以先参照这篇文章），查询了很多资料都无法解决我的问题。只要好重装MySQL，想不到重装也不太顺利。使用sudo apt-get install mysql-server 安装，也报错

 

start: Job failed to start
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.5 (--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.5; however:
  Package mysql-server-5.5 is not configured yet.
dpkg: error processing 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.5
 mysql-server

 

 

仔细查看后发现时没有彻底的把MySQL卸载干净导致的上面的问题。

解决方法*（PS：在删除前记得把数据库文件备份）：

$ sudo apt-get autoremove --purge mysql-server-5.5
$ sudo apt-get autoremove --purge mysql-client-5.5

$ sudo apt-get  autoremove --purge mysql-common

$ sudo rm -rf /var/lib/mysql /etc/mysql ~/.mysql

$ sudo deluser mysql
  #一定要将mysql用户删除，否则在重新安装设置的密码的时候会提示用户已经存在
$ sudo apt-get autoclean

$ sudo apt-get update && sudo apt-get upgrade

$ sudo apt-get install mysql-server-5.5 mysql-client-5.5