在rhel7.5上安装mysql-workbench

郑全

1.默认情况下，我们运行以下命令来安装 wokbench,

yum install  mysql-workbench-community-6.3.8-1.el7.x86_64.rpm


Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager
This system is not registered with an entitlement server. You can use subscription-manager to register.
Examining mysql-workbench-community-6.3.8-1.el7.x86_64.rpm: mysql-workbench-community-6.3.8-1.el7.x86_64
Marking mysql-workbench-community-6.3.8-1.el7.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package mysql-workbench-community.x86_64 0:6.3.8-1.el7 will be installed
--> Processing Dependency: python-paramiko >= 1.15.1 for package: mysql-workbench-community-6.3.8-1.el7.x86_64
--> Processing Dependency: tinyxml for package: mysql-workbench-community-6.3.8-1.el7.x86_64
--> Processing Dependency: libzip for package: mysql-workbench-community-6.3.8-1.el7.x86_64
--> Processing Dependency: proj for package: mysql-workbench-community-6.3.8-1.el7.x86_64
--> Processing Dependency: libGLU.so.1()(64bit) for package: mysql-workbench-community-6.3.8-1.el7.x86_64
--> Processing Dependency: libodbc.so.2()(64bit) for package: mysql-workbench-community-6.3.8-1.el7.x86_64
--> Processing Dependency: libodbcinst.so.2()(64bit) for package: mysql-workbench-community-6.3.8-1.el7.x86_64
--> Processing Dependency: libpq.so.5()(64bit) for package: mysql-workbench-community-6.3.8-1.el7.x86_64
--> Running transaction check
---> Package libzip.x86_64 0:0.10.1-8.el7 will be installed
---> Package mesa-libGLU.x86_64 0:9.0.0-4.el7 will be installed
---> Package mysql-workbench-community.x86_64 0:6.3.8-1.el7 will be installed
--> Processing Dependency: python-paramiko >= 1.15.1 for package: mysql-workbench-community-6.3.8-1.el7.x86_64
--> Processing Dependency: tinyxml for package: mysql-workbench-community-6.3.8-1.el7.x86_64
--> Processing Dependency: proj for package: mysql-workbench-community-6.3.8-1.el7.x86_64
---> Package postgresql-libs.x86_64 0:9.2.23-3.el7_4 will be installed
---> Package unixODBC.x86_64 0:2.3.1-11.el7 will be installed
--> Finished Dependency Resolution
Error: Package: mysql-workbench-community-6.3.8-1.el7.x86_64 (/mysql-workbench-community-6.3.8-1.el7.x86_64)
           Requires: python-paramiko >= 1.15.1
Error: Package: mysql-workbench-community-6.3.8-1.el7.x86_64 (/mysql-workbench-community-6.3.8-1.el7.x86_64)
           Requires: proj
Error: Package: mysql-workbench-community-6.3.8-1.el7.x86_64 (/mysql-workbench-community-6.3.8-1.el7.x86_64)
           Requires: tinyxml
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest

但报错了，其实，就是找不到
python-paramiko
proj
tinyxml

2.主要是这三个包在 epel源里，因此，需要增加这个源，方法如下：
-- 具体是这个地址 http:// dl.fedoraproject.org /pub /epel /7 / x86_64/ Packages/ e / epel-release-7-11.noarch.rpm  
wget http://dl.fedoraproject.org/pub/ ... ase-7-11.noarch.rpm   
rpm -ivh epel-release-7-11.noarch.rpm

检查一下epel是否可用。
yum repolist enabled

再去安装，就可以了了。

[root@dbserver tools]# yum install mysql-workbench-community-6.3.10-1.el7.x86_64.rpm
Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager
This system is not registered with an entitlement server. You can use subscription-manager to register.
Examining mysql-workbench-community-6.3.10-1.el7.x86_64.rpm: mysql-workbench-community-6.3.10-1.el7.x86_64
Marking mysql-workbench-community-6.3.10-1.el7.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package mysql-workbench-community.x86_64 0:6.3.10-1.el7 will be installed
--> Processing Dependency: python-paramiko >= 1.15.1 for package: mysql-workbench-community-6.3.10-1.el7.x86_64
--> Processing Dependency: libzip for package: mysql-workbench-community-6.3.10-1.el7.x86_64
--> Processing Dependency: proj for package: mysql-workbench-community-6.3.10-1.el7.x86_64
--> Processing Dependency: python2-crypto for package: mysql-workbench-community-6.3.10-1.el7.x86_64
--> Processing Dependency: libGLU.so.1()(64bit) for package: mysql-workbench-community-6.3.10-1.el7.x86_64
--> Processing Dependency: libpq.so.5()(64bit) for package: mysql-workbench-community-6.3.10-1.el7.x86_64
--> Processing Dependency: libzip.so.2()(64bit) for package: mysql-workbench-community-6.3.10-1.el7.x86_64
--> Running transaction check
---> Package libzip.x86_64 0:0.10.1-8.el7 will be installed
---> Package mesa-libGLU.x86_64 0:9.0.0-4.el7 will be installed
---> Package postgresql-libs.x86_64 0:9.2.23-3.el7_4 will be installed
---> Package proj.x86_64 0:4.8.0-4.el7 will be installed
---> Package python-paramiko.noarch 0:2.1.1-0.4.el7 will be installed
--> Processing Dependency: python2-pyasn1 for package: python-paramiko-2.1.1-0.4.el7.noarch
--> Processing Dependency: python-cryptography for package: python-paramiko-2.1.1-0.4.el7.noarch
---> Package python2-crypto.x86_64 0:2.6.1-13.el7 will be installed
--> Processing Dependency: libtomcrypt.so.0()(64bit) for package: python2-crypto-2.6.1-13.el7.x86_64
--> Running transaction check
---> Package libtomcrypt.x86_64 0:1.17-25.el7 will be installed
--> Processing Dependency: libtommath >= 0.42.0 for package: libtomcrypt-1.17-25.el7.x86_64
--> Processing Dependency: libtommath.so.0()(64bit) for package: libtomcrypt-1.17-25.el7.x86_64
---> Package python2-cryptography.x86_64 0:1.7.2-2.el7 will be installed
--> Processing Dependency: python-cffi >= 1.4.1 for package: python2-cryptography-1.7.2-2.el7.x86_64
--> Processing Dependency: python-idna >= 2.0 for package: python2-cryptography-1.7.2-2.el7.x86_64
--> Processing Dependency: python-enum34 for package: python2-cryptography-1.7.2-2.el7.x86_64
---> Package python2-pyasn1.noarch 0:0.1.9-7.el7 will be installed
--> Running transaction check
---> Package libtommath.x86_64 0:0.42.0-5.el7 will be installed
---> Package python-cffi.x86_64 0:1.6.0-5.el7 will be installed
--> Processing Dependency: python-pycparser for package: python-cffi-1.6.0-5.el7.x86_64
---> Package python-enum34.noarch 0:1.0.4-1.el7 will be installed
---> Package python-idna.noarch 0:2.4-1.el7 will be installed
--> Running transaction check
---> Package python-pycparser.noarch 0:2.14-1.el7 will be installed
--> Processing Dependency: python-ply for package: python-pycparser-2.14-1.el7.noarch
--> Running transaction check
---> Package python-ply.noarch 0:3.4-11.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

====================================================================================================================================================================
Package                                  Arch                  Version                         Repository                                                     Size
====================================================================================================================================================================
Installing:
mysql-workbench-community                x86_64                6.3.10-1.el7                    /mysql-workbench-community-6.3.10-1.el7.x86_64                128 M
Installing for dependencies:
libtomcrypt                              x86_64                1.17-25.el7                     epel                                                          225 k
libtommath                               x86_64                0.42.0-5.el7                    epel                                                           35 k
libzip                                   x86_64                0.10.1-8.el7                    mnt                                                            49 k
mesa-libGLU                              x86_64                9.0.0-4.el7                     mnt                                                           196 k
postgresql-libs                          x86_64                9.2.23-3.el7_4                  mnt                                                           234 k
proj                                     x86_64                4.8.0-4.el7                     epel                                                          181 k
python-cffi                              x86_64                1.6.0-5.el7                     mnt                                                           218 k
python-enum34                            noarch                1.0.4-1.el7                     mnt                                                            52 k
python-idna                              noarch                2.4-1.el7                       mnt                                                            94 k
python-paramiko                          noarch                2.1.1-0.4.el7                   epel                                                          268 k
python-ply                               noarch                3.4-11.el7                      mnt                                                           123 k
python-pycparser                         noarch                2.14-1.el7                      mnt                                                           105 k
python2-crypto                           x86_64                2.6.1-13.el7                    epel                                                          476 k
python2-cryptography                     x86_64                1.7.2-2.el7                     mnt                                                           503 k
python2-pyasn1                           noarch                0.1.9-7.el7                     mnt                                                           100 k

Transaction Summary
====================================================================================================================================================================
Install  1 Package (+15 Dependent packages)

Total size: 130 M
Total download size: 2.8 M
Installed size: 140 M
Is this ok [y/d/N]: y



3.启动workbench,结果，一直运行不起来，上网检查这个是workbench6.3.10在rhel7上的bug，

Bug #89083

,安装6.3.8，或 8.0的版本即可。
安装6.3.8后，登陆，老是报：

authentication plugin 'caching_sha2_password'

Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306:
  Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/local/mysql/lib/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory

Please:
1 Check that mysql is running on server 127.0.0.1
2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the root has rights to connect to 127.0.0.1 from your address (mysql rights define what clients can connect to the server and from which machines)
4 Make sure you are both providing a password if needed and using the correct password for 127.0.0.1 connecting from the host address you're connecting from

--

关于  default_authentication_plugin ，具体可以看这里

https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin

在mysql8.0 ,

caching_sha2_password 是默认值。

解决办法1：

1.找到配置文件my.ini

将default_authentication_plugin=caching_sha2_password改为default_authentication_plugin=mysql_native_password

2.用命令行登陆

mysql -u root -p

123456

3.use mysql

4.ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'MySql123!';

5.flush privileges;

解决方法二：
   重新安装mysql-workbench-community.x86_64 0:8.0.11-0.1.rc.el7
   就不存在这个问题。