详细介绍安装 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/,
然后找到下载地方,如下图所示,在“select Operating System”中选择“Ubuntu Linux”,然后在“Select OS Version”中只有 ubuntu 16 版本,如果你的系统是 ubuntu 16 ,那么可以选择相应的版本进行下载。
因为我的系统是 ubuntu 14.04,所以需要点击上图右边的“Looking for previous GA versions?”
然后跳转到如下界面,然后选择相应的软件版本
最后点击右下角的“Download”。
跳转到下面的界面,直接点击“No thanks, just start my download”
然后保存文件,点击“OK”下载。
安装
为了避免权限问题出错,我这里使用 root 权限,切换到下载目录,执行如下命令
dpkg -i mysql-workbench-community-6.2.5-1ubu1404-amd64.deb
如果出现如下提示
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
则执行
“`
apt-get -f install
![这里写图片描述](http://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
“`
此时正常安装完成。
启动
搜索“workbench”然后点击对应图标打开
然后点击“Local instance 3306”
在弹出的窗口输入密码
然后就可以看到软件界面