重庆思庄Oracle、Redhat认证学习论坛
标题: 在rhel7.5上安装mysql-workbench [打印本页]
作者: 郑全 时间: 2018-7-7 20:35
标题: 在rhel7.5上安装mysql-workbench
本帖最后由 郑全 于 2018-7-7 20:56 编辑
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
就不存在这个问题。
| 欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) |
Powered by Discuz! X3.2 |