Ubuntu 安装 MySQL 客户端 mysql-workbench

时间:2021-06-27 23:15:06

详细介绍安装 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 安装 MySQL 客户端 mysql-workbench

因为我的系统是 ubuntu 14.04,所以需要点击上图右边的“Looking for previous GA versions?”
然后跳转到如下界面,然后选择相应的软件版本
Ubuntu 安装 MySQL 客户端 mysql-workbench
最后点击右下角的“Download”。

跳转到下面的界面,直接点击“No thanks, just start my download”
Ubuntu 安装 MySQL 客户端 mysql-workbench

然后保存文件,点击“OK”下载。
Ubuntu 安装 MySQL 客户端 mysql-workbench

安装

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

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

Ubuntu 安装 MySQL 客户端 mysql-workbench

如果出现如下提示
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

Ubuntu 安装 MySQL 客户端 mysql-workbench
则执行
“`
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
“`
Ubuntu 安装 MySQL 客户端 mysql-workbench
此时正常安装完成。

启动

搜索“workbench”然后点击对应图标打开
Ubuntu 安装 MySQL 客户端 mysql-workbench

然后点击“Local instance 3306”
Ubuntu 安装 MySQL 客户端 mysql-workbench

在弹出的窗口输入密码
Ubuntu 安装 MySQL 客户端 mysql-workbench

然后就可以看到软件界面
Ubuntu 安装 MySQL 客户端 mysql-workbench