Ubuntu 安装 MySQL 客户端 mysql-workbench

矫情吗；* 2022-06-10 07:58 1480阅读 0赞

详细介绍安装 MySQL 客户端 mysql-workbench 的步骤。  
在安装好 MySQL 之后可以需要可视化界面，可以选择官方提供的 mysql-workbench 客户端。

## 实验环境 ##

Ubuntu 版本：ubuntu 14.04  
MySQL版本：MySQL 5.5  
mysql-workbench 版本：mysql-workbench-community-6.2.5-1ubu1404-amd64

## 下载 ##

在火狐Firefox浏览器中输入官方下载地址：[https://dev.mysql.com/downloads/workbench/][https_dev.mysql.com_downloads_workbench]，  
然后找到下载地方，如下图所示，在“select Operating System”中选择“Ubuntu Linux”，然后在“Select OS Version”中只有 ubuntu 16 版本，如果你的系统是 ubuntu 16 ，那么可以选择相应的版本进行下载。  
![这里写图片描述][SouthEast]

因为我的系统是 ubuntu 14.04，所以需要点击上图右边的“Looking for previous GA versions？”  
然后跳转到如下界面，然后选择相应的软件版本  
![这里写图片描述][SouthEast 1]  
最后点击右下角的“Download”。

跳转到下面的界面，直接点击“No thanks, just start my download”  
![这里写图片描述][SouthEast 2]

然后保存文件，点击“OK”下载。  
![这里写图片描述][SouthEast 3]

## 安装 ##

为了避免权限问题出错，我这里使用 root 权限，切换到下载目录，执行如下命令

dpkg -i mysql-workbench-community-6.2.5-1ubu1404-amd64.deb

![这里写图片描述][20170814112610111]

如果出现如下提示  
Selecting previously unselected package mysql-workbench-community.  
(Reading database … 193893 files and directories currently installed.)  
Preparing to unpack mysql-workbench-community-6.2.5-1ubu1404-amd64.deb …  
Unpacking mysql-workbench-community (6.2.5-1ubu1404) …  
dpkg: dependency problems prevent configuration of mysql-workbench-community:  
mysql-workbench-community depends on libctemplate2; however:  
Package libctemplate2 is not installed.  
mysql-workbench-community depends on libgtkmm-2.4-1c2a (>= 1:2.24.0); however:  
Package libgtkmm-2.4-1c2a is not installed.  
mysql-workbench-community depends on libtinyxml2.6.2; however:  
Package libtinyxml2.6.2 is not installed.  
mysql-workbench-community depends on libzip2 (>= 0.10); however:  
Package libzip2 is not installed.  
mysql-workbench-community depends on python-paramiko; however:  
Package python-paramiko is not installed.

dpkg: error processing package mysql-workbench-community (–install):  
dependency problems - leaving unconfigured  
Processing triggers for gnome-menus (3.10.1-0ubuntu2) …  
Processing triggers for desktop-file-utils (0.22-1ubuntu1) …  
Processing triggers for bamfdaemon (0.5.1+14.04.20140409-0ubuntu1) …  
Rebuilding /usr/share/applications/bamf-2.index…  
Processing triggers for mime-support (3.54ubuntu1.1) …  
Processing triggers for shared-mime-info (1.2-0ubuntu3) …  
Processing triggers for hicolor-icon-theme (0.13-1) …  
Errors were encountered while processing:  
mysql-workbench-community

![这里写图片描述][SouthEast 4]  
则执行  
“\`  
apt-get -f install

![这里写图片描述](https://img-blog.csdn.net/20170814113032424?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvdTAxMjMxODA3NA==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast)
    中间会询问一次是否继续，输入 y 即可。
    
    然后重新执行

dpkg -i mysql-workbench-community-6.2.5-1ubu1404-amd64.deb  
“\`  
![这里写图片描述][SouthEast 5]  
此时正常安装完成。

## 启动 ##

搜索“workbench”然后点击对应图标打开  
![这里写图片描述][SouthEast 6]

然后点击“Local instance 3306”  
![这里写图片描述][SouthEast 7]

在弹出的窗口输入密码  
![这里写图片描述][SouthEast 8]

然后就可以看到软件界面  
![这里写图片描述][SouthEast 9]

[https_dev.mysql.com_downloads_workbench]: https://dev.mysql.com/downloads/workbench/
[SouthEast]: /images/20220610/558071e71f8648a9b9e51b0c19e98bdc.png
[SouthEast 1]: /images/20220610/dfd85e8c45964f39b08e2661d835d2d8.png
[SouthEast 2]: /images/20220610/f7f8866a2c8d4136b1bc9b5c86a3c9c7.png
[SouthEast 3]: /images/20220610/fc88afe796e049aabe4b0e3fed9e1a11.png
[20170814112610111]: /images/20220610/2dd7e422acb64d3dae9024a018dae5f8.png
[SouthEast 4]: /images/20220610/24b0b3c0804043279125855555d4dd20.png
[SouthEast 5]: /images/20220610/0580c8f6e38b4103a5bf9ec32aceef75.png
[SouthEast 6]: /images/20220610/52c30a3e1cf147ec8754025348d82a98.png
[SouthEast 7]: /images/20220610/3ef216c3737a431f9687901fd8e1e1a2.png
[SouthEast 8]: /images/20220610/a798ef5dfcd64adc8f11933076da93bf.png
[SouthEast 9]: /images/20220610/deaa5e94ab5443b78b1b7c1e5eb703a3.png