☰

在 ubuntu 14.04 上安装 Mysql Workbench

tag-icon • tag-icon 14.04 mysql-workbench mariadb
在 ubuntu 14.04 上安装 Mysql Workbench

我已经安装了 MariaDb，因为它得到了 Ubuntu 社区的支持，在最新 LTS 的发行说明中提到过。

之后我尝试安装 Mariadb-client，也安装成功，之后有了 GUI 工具就好了，所以决定从 Ubuntu 软件中心和终端安装 MySql-workbench，但它提示了下面提到的错误-

Ubuntu 软件中心出现错误

 This error could be caused by required additional software packages which are missing or not installable. Furthermore there could be a conflict between software packages which are not allowed to be installed at the same time.
 mysql-workbench: Depends: libgcc1 (>= 1:4.1.1) but 1:4.9-20140406-0ubuntu1 is to be installed
             Depends: libgtkmm-2.4-1c2a (>= 1:2.24.0) but 1:2.24.4-1ubuntu1 is to be installed
             Depends: libpcrecpp0 (>= 7.7) but 1:8.31-2ubuntu2 is to be installed
             Depends: python:any (>= 2.7.1-0ubuntu2) but it is a virtual package
             Depends: mysql-workbench-data (= 6.0.8+dfsg-2) but 6.0.8+dfsg-2 is to be installed.

终端错误-

 The following packages have unmet dependencies:
    mysql-workbench : Depends: mysql-client
    E: Unable to correct problems, you have held broken packages.

正如所提到的，这个已经成为启动板上确认的错误这里。

在My-sql的官方网站上，workbench的版本只提供到saucy(13.10)，那么我该如何安装它呢？

更新 1

在以下行中添加了/etc/apt/sources.list

# MariaDB 10.0 repository list - created 2014-04-19 11:47 UTC
# http://mariadb.org/mariadb/repositories/
deb http://mirror.mephi.ru/mariadb/repo/10.0/ubuntu trusty main
deb-src http://mirror.mephi.ru/mariadb/repo/10.0/ubuntu trusty main

没有变化，仍然是同样的问题。 Trusty 和 Mariadb 10.1.10 版本之间存在一些问题。所以尝试了

sudo apt-get install libmysqlclient18=10.1.10-mariadb1~trusty mysql-common=10.1.10-mariadb1~trusty

它的输出是 -

E: Version '10.1.10-mariadb1~trusty' for 'libmysqlclient18' was not found
E: Version '10.1.10-mariadb1~trusty' for 'mysql-common' was not found

事情很简单，就是找不到它，尽管它在官方网站上。

更新2

删除了 MariaDB 10.1.10，但是问题仍然与 MariaDB 5.5.37 相同。

答案1

我通过使用最新的社区版本并从依赖中删除 mysql-client 来解决这个问题

假设 mariadb 已经安装

从以下位置下载 mysql workbenchhttp://dev.mysql.com/downloads/tools/workbench/（14.04 上的 13.10 版本就可以）

从下载文件的目录中运行：

sudo apt-get remove mysql-workbench mysql-workbench-data

dpkg-deb -x mysql-workbench-community-6.*.deb tmp_mysql-workbench
dpkg-deb --control mysql-workbench-community-6.*.deb tmp_mysql-workbench/DEBIAN
sed -i -e 's/mysql-client, //' tmp_mysql-workbench/DEBIAN/control
dpkg -b tmp_mysql-workbench mysql-workbench-community_patched.deb

sudo dpkg -i mysql-workbench-community_patched.deb

答案2

14.04 版的直接下载链接在这里http://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-workbench-community-6.1.7-1ubu1404-amd64.deb

答案3

这是一个错误，应该修复，但这只是一个临时解决方案：

  1. 将 mysql-workbench-community-6.1.4-1ubu1310-amd64.deb 解压到文件夹中。
  2. 更改文件“DEBIAN/control”，将“mysql-client”替换为“mysql-client-5.6”。

  3. 进入终端并创建一个新的“.deb”：

    dpkg -b mysql-workbench-community-6.1.4-1ubu1310-amd64/

完成了！现在您可以从新的 deb 文件进行安装。

答案4

我拥有 6.2.3-1ubu1404 版本，其中根本不包含“mysql-server”字符串。但是由于未满足依赖关系，我无法安装。

不知何故，我尝试通过以下方式手动安装要求

# sudo apt-get install libgtkmm-2.4-1c2a libtinyxml2.6.2 libzip2 python-paramiko libproj0 proj-data

我工作。

我的实际错误是这个：

$ sudo dpkg -i mysql-workbench-community-6.2.3-1ubu1404-amd64.deb 
Selecting previously unselected package mysql-workbench-community.
(Reading database ... 221745 files and directories currently installed.)
Preparing to unpack mysql-workbench-community-6.2.3-1ubu1404-amd64.deb ...
Unpacking mysql-workbench-community (6.2.3-1ubu1404) ...
dpkg: dependency problems prevent configuration of mysql-workbench-community:
 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.
 mysql-workbench-community depends on libproj0; however:
  Package libproj0 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 mime-support (3.54ubuntu1) ...
Processing triggers for menu (2.1.46ubuntu1) ...
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
dincer@dincerExp:~/Downloads$ sudo dpkg -i mysql-workbench-community-6.2.3-1ubu1404-amd64.deb 
(Reading database ... 223036 files and directories currently installed.)
Preparing to unpack mysql-workbench-community-6.2.3-1ubu1404-amd64.deb ...
Unpacking mysql-workbench-community (6.2.3-1ubu1404) over (6.2.3-1ubu1404) ...
Setting up mysql-workbench-community (6.2.3-1ubu1404) ...
Processing triggers for gnome-menus (3.10.1-0ubuntu2) ...
Processing triggers for desktop-file-utils (0.22-1ubuntu1) ...
Processing triggers for mime-support (3.54ubuntu1) ...
Processing triggers for menu (2.1.46ubuntu1) ...
Processing triggers for shared-mime-info (1.2-0ubuntu3) ...
Processing triggers for hicolor-icon-theme (0.13-1) ...

相关内容