RHEL(7.7)_MySQL命令行工具_mycli的安装

RHEL-7.7的安装与基础配置

1. 查看Red Hat Enterprise Linux Server的版本，本次安装为基础设施版，镜像请自行在网上下载

cat /etc/redhat-release

2.配置IP地址，保证XShell、SecureCRT等工具可以连接上

cat /etc/sysconfig/network-scripts/ifcfg-ens192

3. 配置YUM源，由于RHEL配置YUM源较麻烦，所以制作脚本一键设置节省时间；

#!/bin/bash
wget http://mirrors.163.com/centos/7/os/x86_64/Packages/yum-3.4.3-167.el7.centos.noarch.rpm &&
echo "Finished Get yum-3.4.3-163.el7.centos.noarch.rpm" &&
wget http://mirrors.163.com/centos/7/os/x86_64/Packages/yum-metadata-parser-1.1.4-10.el7.x86_64.rpm &&
echo "Finished Get yum-metadata-parser-1.1.4-10.el7.x86_64.rpm" &&
wget http://mirrors.163.com/centos/7/os/x86_64/Packages/yum-plugin-fastestmirror-1.1.31-53.el7.noarch.rpm &&
echo "Finished Get yum-plugin-fastestmirror-1.1.31-52.el7.noarch.rpm" &&
wget http://mirrors.163.com/centos/7/os/x86_64/Packages/yum-updateonboot-1.1.31-53.el7.noarch.rpm &&
echo "Finished Get yum-updateonboot-1.1.31-52.el7.noarch.rpm" &&
wget http://mirrors.163.com/centos/7/os/x86_64/Packages/yum-utils-1.1.31-53.el7.noarch.rpm &&
echo "Finished Get yum-utils-1.1.31-52.el7.noarch.rpm" &&
wget  http://mirrors.163.com/centos/7/os/x86_64/Packages/python-urlgrabber-3.10-10.el7.noarch.rpm &&
echo "Finished Get python-urlgrabber-3.10-9.el7.noarch.rpm" &&
yum -y remove subscription-manager &&
yum -y remove rhn-check &&
rpm -qa|grep yum|xargs rpm -e --nodeps &&
rpm -ivh --force --nodeps python-urlgrabber-3.10-10.el7.noarch.rpm &&
rpm -ivh  --force --nodeps yum-* &&
rm /etc/yum.repos.d/* &&
touch /etc/yum.repos.d/CentOS-Base.repo &&
echo test >> /etc/yum.repos.d/CentOS-Base.repo &&
sed -i '1c [base]' /etc/yum.repos.d/CentOS-Base.repo &&
sed -i '$a name=CentOS-$7 - Base - 163.com' /etc/yum.repos.d/CentOS-Base.repo &&
sed -i '$a #mirrorlist=http://mirrorlist.centos.org/?release=$7&arch=$basearch&repo=os' /etc/yum.repos.d/CentOS-Base.repo &&
sed -i '$a baseurl=http://mirrors.163.com/centos/7/os/$basearch/' /etc/yum.repos.d/CentOS-Base.repo &&
sed -i '$a gpgcheck=1' /etc/yum.repos.d/CentOS-Base.repo &&
sed -i '$a gpgkey=http://mirrors.163.com/centos/RPM-GPG-KEY-CentOS-7' /etc/yum.repos.d/CentOS-Base.repo &&
sed -i '$a #released updates' /etc/yum.repos.d/CentOS-Base.repo &&
sed -i '$a [updates]' /etc/yum.repos.d/CentOS-Base.repo &&
sed -i '$a name=CentOS-$7 - Updates - 163.com' /etc/yum.repos.d/CentOS-Base.repo &&
sed -i '$a #mirrorlist=http://mirrorlist.centos.org/?release=$7&arch=$basearch&repo=updates' /etc/yum.repos.d/CentOS-Base.repo &&
sed -i '$a baseurl=http://mirrors.163.com/centos/7/updates/$basearch/' /etc/yum.repos.d/CentOS-Base.repo &&
sed -i '$a gpgcheck=1' /etc/yum.repos.d/CentOS-Base.repo &&
sed -i '$a gpgkey=http://mirrors.163.com/centos/RPM-GPG-KEY-CentOS-7' /etc/yum.repos.d/CentOS-Base.repo &&
sed -i '$a #additional packages that may be useful' /etc/yum.repos.d/CentOS-Base.repo &&
sed -i '$a [extras]' /etc/yum.repos.d/CentOS-Base.repo &&
sed -i '$a name=CentOS-$7 - Extras - 163.com' /etc/yum.repos.d/CentOS-Base.repo &&
sed -i '$a #mirrorlist=http://mirrorlist.centos.org/?release=$7&arch=$basearch&repo=extras' /etc/yum.repos.d/CentOS-Base.repo &&
sed -i '$a baseurl=http://mirrors.163.com/centos/7/extras/$basearch/' /etc/yum.repos.d/CentOS-Base.repo &&
sed -i '$a gpgcheck=1' /etc/yum.repos.d/CentOS-Base.repo &&
sed -i '$a gpgkey=http://mirrors.163.com/centos/RPM-GPG-KEY-CentOS-7' /etc/yum.repos.d/CentOS-Base.repo &&
sed -i '$a #additional packages that extend functionality of existing packages' /etc/yum.repos.d/CentOS-Base.repo &&
sed -i '$a [centosplus]' /etc/yum.repos.d/CentOS-Base.repo &&
sed -i '$a name=CentOS-$7 - Plus - 163.com' /etc/yum.repos.d/CentOS-Base.repo &&
sed -i '$a baseurl=http://mirrors.163.com/centos/7/centosplus/$basearch/' /etc/yum.repos.d/CentOS-Base.repo &&
sed -i '$a gpgcheck=1' /etc/yum.repos.d/CentOS-Base.repo &&
sed -i '$a enabled=0' /etc/yum.repos.d/CentOS-Base.repo &&
sed -i '$a gpgkey=http://mirrors.163.com/centos/RPM-GPG-KEY-CentOS-7' /etc/yum.repos.d/CentOS-Base.repo &&
yum -y install epel-release &&
yum clean all &&
yum makecache

yum repolist

4. 安装并配置MySQL，包括修改默认密码、默认字符集，rpm安装包请网上自行查找下载，由于RHEL7.7默认带有mariadb，需要先卸载，再使用rpm -ivh进行MySQL的安装
   
   
   

systemctl start mysqld

mycli的安装

安装依赖包：python-devel、python-pip

yum -y install python-devel python-pip

由于直接使用命令安装mycli会出现多种错误，所以再次安装依赖包

yum -y install gcc libffi-devel openssl-devel

安装mycli工具，使用-i参数可以修改为国内源

pip install -i https://pypi.douban.com/simple mycli==1.8.1

此时可能会出现错误，若出现就需要升级pip，然后再安装

pip install -i https://pypi.douban.com/simple --upgrade pip

如果遇到以下错误

ERROR: Cannot uninstall 'configobj'. It is a distutils installed project and thus we cannot accurately determine which files belong to it which would lead to only a partial uninstall.

添加–ignore-installed参数再安装

pip install -i https://pypi.douban.com/simple --ignore-installed mycli==1.8.1

若出现如下这段提示，则表示安装成功

Installing collected packages: wcwidth, six, prompt-toolkit, Pygments, terminaltables, backports.csv, configobj, tabulate, cli-helpers, PyMySQL, pycparser, cffi, ipaddress, enum34, cryptography, sqlparse, click, mycli
    Running setup.py install for terminaltables ... done
    Running setup.py install for configobj ... done
    Running setup.py install for tabulate ... done
Successfully installed PyMySQL-0.9.3 Pygments-2.5.2 backports.csv-1.0.7 cffi-1.14.0 cli-helpers-1.2.1 click-7.1.1 configobj-5.0.6 cryptography-2.9.2 enum34-1.1.10 ipaddress-1.0.23 mycli-1.21.1 prompt-toolkit-2.0.10 pycparser-2.20 six-1.14.0 sqlparse-0.3.1 tabulate-0.8.7 terminaltables-3.1.0 wcwidth-0.1.9

4种mycli登录mysql的方式：

mycli -h127.0.0.1 -uroot -p'654321' -P3306 test01

mycli -p'654321' mysql://root@127.0.0.1:3306/test01

mycli  mysql://root:654321@127.0.0.1:3306/test01

mycli -h127.0.0.1 -uroot -p'654321'