系統(tǒng)環(huán)境：

操作系統(tǒng)： RedHat EL6.4(64)

WorkBench：?mysql-workbench-community-6.0.9

MySQL?Workbench是一款專為MySQL設(shè)計(jì)的ER/數(shù)據(jù)庫建模工具。它是著名的數(shù)據(jù)庫設(shè)計(jì)工具DBDesigner4的繼任者。你可以用MySQL Workbench設(shè)計(jì)和創(chuàng)建新的數(shù)據(jù)庫圖示，建立數(shù)據(jù)庫文檔，以及進(jìn)行復(fù)雜的MySQL 遷移。

MySQL Workbench是下一代的可視化數(shù)據(jù)庫設(shè)計(jì)、管理的工具，它同時(shí)有開源和商業(yè)化的兩個(gè)版本。該軟件支持Windows和Linux系統(tǒng)。

對(duì)于Linux系統(tǒng)下的WorkBench安裝比較容易，通過rpm安裝就可以。

下載：MySQL官方網(wǎng)站

安裝版本：mysql-workbench-community-6.0.9-1.el6.x86_64.rpm

一、安裝

[root@rh64 mysql]# ls -l

安裝需要libzip.so.1(64)的支持，libzip可以到以下網(wǎng)站下載：

安裝libzip：

[root@rh64 mysql]# rpm -ivh libzip-0.9-1.el5.rf.x86_64.rpm

warning: libzip-0.9-1.el5.rf.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 6b8d79e6: NOKEY

Preparing... ? ? ? ? ? ? ? ?########################################### [100%]

package libzip-0.10.1-1.3.x86_64 (which is newer than libzip-0.9-1.el5.rf.x86_64) is already installed

file /usr/bin/zipcmp from install of libzip-0.9-1.el5.rf.x86_64 conflicts with file from package libzip-0.10.1-1.3.x86_64

file /usr/bin/zipmerge from install of libzip-0.9-1.el5.rf.x86_64 conflicts with file from package libzip-0.10.1-1.3.x86_64

file /usr/bin/ziptorrent from install of libzip-0.9-1.el5.rf.x86_64 conflicts with file from package libzip-0.10.1-1.3.x86_64

file /usr/share/man/man1/zipcmp.1.gz from install of libzip-0.9-1.el5.rf.x86_64 conflicts with file from package libzip-0.10.1-1.3.x86_64

file /usr/share/man/man1/zipmerge.1.gz from install of libzip-0.9-1.el5.rf.x86_64 conflicts with file from package libzip-0.10.1-1.3.x86_64

file /usr/share/man/man1/ziptorrent.1.gz from install of libzip-0.9-1.el5.rf.x86_64 conflicts with file from package libzip-0.10.1-1.3.x86_64

與系統(tǒng)文件沖突，可以采用強(qiáng)制安裝：

[root@rh64 mysql]# rpm -ivh libzip-0.9-1.el5.rf.x86_64.rpm --force

warning: libzip-0.9-1.el5.rf.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 6b8d79e6: NOKEY

Preparing... ? ? ? ? ? ? ? ?########################################### [100%]

1:libzip ? ? ? ? ? ? ? ? ########################################### [100%]

[root@rh64 mysql]# find / -name "libzip.so*"

/u01/app/oracle/product/11.2.0/db_1/jdk/jre/lib/amd64/libzip.so/usr/lib64/libzip.so.1

/usr/lib64/libzip.so.1.0.0

/usr/lib64/libzip.so.2.1.0

/usr/lib64/libzip.so.2

/usr/lib/jvm/java-1.7.0-openjdk-1.7.0.9.x86_64/jre/lib/amd64/libzip.so

/usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0.x86_64/jre/lib/amd64/libzip.so安裝WorkBench：

[root@rh64 mysql]# rpm -ivy mysql-workbench-community-6.0.9-1.el6.x86_64.rpm

-ivy: unknown option

[root@rh64 mysql]# rpm -ivh mysql-workbench-community-6.0.9-1.el6.x86_64.rpm

Preparing... ? ? ? ? ? ? ? ?########################################### [100%]

1:mysql-workbench-communi########################################### [100%]

二、Workbench會(huì)用到mysql utilities

安裝mysql utilities：(下載地址mysql官方網(wǎng)站)

[root@rh64 mysql]# rpm -ivh mysql-utilities-1.5.6-1.el6.noarch.rpm

warning: mysql-utilities-1.5.6-1.el6.noarch.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

error: Failed dependencies:

mysql-connector-python >= 2.0.4 is needed by mysql-utilities-1.5.6-1.el6.noarch首先要安裝connector-python：(下載地址mysql官方網(wǎng)站)

[root@rh64 mysql]# rpm -ivh mysql-connector-python-2.1.3-1.el6.x86_64.rpm

warning: mysql-connector-python-2.1.3-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

Preparing... ? ? ? ? ? ? ? ?########################################### [100%]

1:mysql-connector-python ########################################### [100%][root@rh64 mysql]# rpm -ivh mysql-utilities-1.5.6-1.el6.noarch.rpm

warning: mysql-utilities-1.5.6-1.el6.noarch.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

Preparing... ? ? ? ? ? ? ? ?########################################### [100%]

1:mysql-utilities ? ? ? ?########################################### [100%]

三、MySQL WorkBench工作界面

連接數(shù)據(jù)庫：

連接成功，管理數(shù)據(jù)庫：

創(chuàng)作挑戰(zhàn)賽新人創(chuàng)作獎(jiǎng)勵(lì)來咯，堅(jiān)持創(chuàng)作打卡瓜分現(xiàn)金大獎(jiǎng)

總結(jié)

以上是生活随笔為你收集整理的mysql bench linux_MySQL Study之--Linux下安装MySQL workbench工具的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。