MySQL study--linux installation MySQL Workbench tool

MySQL study--linux installation MySQL Workbench tool

System environment:

Operating system: RedHat EL6.4 (64)

workbench:mysql-workbench-community-6.0.9

MySQL Workbench is a er/database modeling tool designed for MySQL. It is a successor to the famous database design tool DBDesigner4. You can use MySQL workbench to design and create new database diagrams, create database documents, and perform complex MySQL migrations.

MySQL Workbench is the next generation of Visual Database design, management tools, it also has open source and commercialization of two versions. The software supports Windows and Linux systems.

For Linux System Workbench installation is easy, with RPM installation can be.

Download: MySQL official website

650) this.width=650; "Src=" http://img.blog.csdn.net/20151202142509026?watermark/2/text/ Ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity/center "Style=" Border:none; "/>

Installed version: Mysql-workbench-community-6.0.9-1.el6.x86_64.rpm

First, installation

[Email protected] mysql]# ls-l

Total 124752-rw-rw-r--  1 mysql mysql     2329 nov  23 16:14 join.sql-rw-r-----  1 mysql mysql    38140  oct 27 12:37 libev-4.04-2.el6.x86_64.rpmdrwxr-xr-x  4 root  root       4096 oct 27 11:09 libev-4.15-rw-r--r--  1  mysql mysql   513919 oct 27 11:05 libev-4.15.tar.gz-rw-r-----   1 mysql mysql    43344 Dec  1 18:16  Libzip-0.10.1-1.3.x86_64.rpm-rw-r-----  1 mysql mysql    62768  Dec  1 18:05 libzip-0.11.1-3.fc20.x86_64.rpm-rw-r-----  1 mysql mysql     24145 dec  1 17:33 libzip-0.11.2-3.4.1.x86_64.rpm-rw-r-----   1 mysql mysql    65760 dec  1 17:58 libzip-0.11.2-5.fc22.x86_64.rpm-rw-r--r--   1 mysql mysql 23770696 Dec  1 17:29  mysql-workbench-community-6.0.9-1.el6.x86_64.rpm-rw-r--r--  1 mysql mysql 18748620  dec  1 17:23 mysql-workbench-community-6.2.5-1.el6.x86_64.rpm-rwxrwxr-x. 1  mysql mysql  1593932 sep  6 18:00 openssl-1.0.1e-42.el6.x86_64. rpm-rwxrwxr-x. 1 mysql mysql  6727084 sep  6 17:39  percona-server-client-56-5.6.25-rel73.1.el6.x86_64.rpm-rwxrwxr-x. 1 mysql mysql 20463420  Sep  6 17:40 Percona-Server-server-56-5.6.25-rel73.1.el6.x86_64.rpm-rwxrwxr-x.  1 mysql mysql   742496 sep  6 17:40  percona-server-shared-56-5.6.25-rel73.1.el6.x86_64.rpm-rw-rw-r--  1 root  root   5664452 oct 17 02:50  Percona-xtrabackup-2.3.2-1.el6.x86_64.rpm-rw-r-----  1 MYSQL MYSQL 27453440 OCT  27 11:40 Percona-XtraBackup-2.3.2-r306a2e0-el6-x86_64-bundle.tar-rw-rw-r--  1  root  root  20807976 oct 17 02:50  percona-xtrabackup-debuginfo-2.3.2-1.el6.x86_64.rpm-rw-rw-r--  1 root  root     971264 oct 17 02:50 percona-xtrabackup-test-2.3.2-1.el6.x86_64. Rpm-rw-rw-r--  1 mysql mysql     2286 nov 23 16:34  scott.sqldrwxrwxr-x  2 mysql mysql     4096 Oct  27 10:27 xtrabackup

installation requires Libzip.so.1 (64) Support, Libzip can be downloaded to the following website:

650) this.width=650; "Src=" http://img.blog.csdn.net/20151202142901762?watermark/2/text/ Ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity/center "Style=" Border:none; "/>

Install Libzip:

[email protected] 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 are 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.x8 6_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 Libz Ip-0.10.1-1.3.x86_64

Conflicts with system files, you can use a forced installation:
[Email protected] 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%]

[[email protected] 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

Install Workbench:
[[email  Protected] mysql]# Rpm-ivy mysql-workbench-community-6.0.9-1.el6.x86_64.rpm 
-ivy:unknown option
[[email protected] mysql]# rpm-ivh mysql-workbench-community-6.0.9-1.el6.x86_64.rpm 
Preparing ...                ########################################### [100%]
   1:mysql-workbench-communi########################################### [100%]
 

Second, Workbench will use the MySQL utilities

Install MySQL utilities:(MySQL official website)

[email protected] 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

first to install Connector-python: (MySQL official website)
[Email protected] 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%]
[email protected] 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%]

Third, MySQL Workbench working interface

650) this.width=650; "Src=" http://img.blog.csdn.net/20151202143624869?watermark/2/text/ Ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity/center "Style=" Border:none; "/>

To connect to a database:

650) this.width=650; "Src=" http://img.blog.csdn.net/20151202143722063?watermark/2/text/ Ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity/center "Style=" Border:none; "/>

650) this.width=650; "Src=" http://img.blog.csdn.net/20151202143747075?watermark/2/text/ Ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity/center "Style=" Border:none; "/>

Connection successful, manage database:

650) this.width=650; "Src=" http://img.blog.csdn.net/20151202143840392?watermark/2/text/ Ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity/center "Style=" Border:none; "/>

650) this.width=650; "Src=" http://img.blog.csdn.net/20151202143909142?watermark/2/text/ Ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity/center "Style=" Border:none; "/>

• Previous Article Linux study--redhat EL6 configuring VNC server

This article is from the "Tianya blog," Please make sure to keep this source http://tiany.blog.51cto.com/513694/1718847

MySQL study--linux installation MySQL Workbench tool