問題描述

今天在Ubuntu14.04下安裝mysql時遇到了問題。
一開始,我嘗試輸入以下命令：

mysql -u root -p

然后得到如下信息:

The program mysql can be found on the following packages:
mysql-client-core-5.5 
mariadb-client-core-5.5 
mysql-client-core-5.6 
percona-xtrabd-cluster-client-5.5

我鬼使神差地選擇了5.6的安裝包，輸入了

sudo apt-get install mysql-client-core-5.6

安裝完畢后我又一次嘗試連接mysql，得到如下錯誤信息：

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

我嘗試輸入mysqld，得到以下提示：

The program mysql can be found on the following packages:
mysql-server-core-5.5 
mariadb-server-core-5.5 
mysql-server-core-5.6 
percona-xtrabd-cluster-server-5.5

對應(yīng)的我選擇了mysql-server-core-5.6
連接時還是得到上面的錯誤。
查閱資料后，我按照別人的方法依次輸入以下命令：

sudo apt-get clean && sudo apt-get update
sudo apt-get install mysql-server mysql-client

結(jié)果得到了如下信息

Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
 mysql-server : Depends: mysql-server-5.5 but it is not going to be installed
E: Unable to correct problems, you have held broken packages.

解決方法：

經(jīng)過查閱終于找到了問題的解決方法。版本依賴問題，MySQL客戶端5.5和MySQL服務(wù)器5.5是目前Ubuntu 14.04匹配地“最好”版本。

方法一：

移除5.6，安裝5.5

sudo apt-get purge mysql-client-core-5.6
sudo apt-get autoremove
sudo apt-get autoclean
sudo apt-get install mysql-client-core-5.5
sudo apt-get install mysql-server

方法二：

使用aptitude,其實也是移除5.6版本，安裝了5.5版本。未安裝aptitude的話先安裝aptitude

sudo apt-get install aptitude

然后輸入

sudo aptitude install mysql-server