工作需要安装了CentOS8系统桌面版,在MySQL命令行下查询数据,比较难看。想要使用MySQL可视化客户端,方便批量数据展示。
找到MySQL Workbeanch官网:http://mysqlworkbench.org/
看到最新版本Workbench 8.0.18:
选择操作系统(Red Hat Enterprise Linux 8,此版本与CentOS8匹配):
下载到本地:
下载完后,执行安装:
[root@core ~]# rpm -ivh /home/xxx/Downloads/mysql-workbench-community-8.0.18-1.el8.x86_64.rpm
warning: /home/xxx/Downloads/mysql-workbench-community-8.0.18-1.el8.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
libpcrecpp.so.0()(64bit) is needed by mysql-workbench-community-8.0.18-1.el8.x86_64
libpython2.7.so.1.0()(64bit) is needed by mysql-workbench-community-8.0.18-1.el8.x86_64
libzip is needed by mysql-workbench-community-8.0.18-1.el8.x86_64
libzip.so.5()(64bit) is needed by mysql-workbench-community-8.0.18-1.el8.x86_64
发现缺少4个依赖包:libpcrecpp.so.0、libpython2.7.so.1.0、libzip、libzip.so.5。
怎么办呢?!不用慌,可通过一个命令查询:yum whatprovides */库名字。
查询这4个库查询,可得知分别在那个安装包:
[root@core ~]# yum whatprovides */libpcrecpp.so.0
Last metadata expiration check: 0:55:51 ago on Mon 21 Oct 2019 02:49:37 PM CST.
pcre-cpp-8.42-4.el8.i686 : C++ bindings for PCRE
Repo : BaseOS
Matched from:
Filename : /usr/lib/libpcrecpp.so.0
pcre-cpp-8.42-4.el8.x86_64 : C++ bindings for PCRE
Repo : BaseOS
Matched from:
Filename : /usr/lib64/libpcrecpp.so.0
[root@core ~]# yum whatprovides */libpython2.7.so.1.0
Last metadata expiration check: 0:56:03 ago on Mon 21 Oct 2019 02:49:37 PM CST.
python2-libs-2.7.15-24.module_el8.0.0+193+7850e68f.x86_64 : Runtime libraries for Python 2
Repo : @System
Matched from:
Filename : /usr/lib64/libpython2.7.so.1.0
python2-libs-2.7.15-24.module_el8.0.0+193+7850e68f.x86_64 : Runtime libraries for Python 2
Repo : AppStream
Matched from:
Filename : /usr/lib64/libpython2.7.so.1.0
[root@core ~]# yum whatprovides */libzip
Last metadata expiration check: 0:56:06 ago on Mon 21 Oct 2019 02:49:37 PM CST.
libzip-1.5.1-1.module_el8.0.0+56+d1ca79aa.x86_64 : C library for reading, creating, and modifying zip archives
Repo : AppStream
Matched from:
Filename : /usr/share/licenses/libzip
[root@core ~]# yum whatprovides */libzip.so.5
Last metadata expiration check: 0:56:22 ago on Mon 21 Oct 2019 02:49:37 PM CST.
libzip-1.5.1-1.module_el8.0.0+56+d1ca79aa.x86_64 : C library for reading, creating, and modifying zip archives
Repo : AppStream
Matched from:
Filename : /usr/lib64/libzip.so.5
找到安装包后,挨个安装:
安装pcre-cpp:
[root@core ~]# yum install -y pcre-cpp
Last metadata expiration check: 1:54:35 ago on Mon 21 Oct 2019 02:49:37 PM CST.
Dependencies resolved.
================================&#