linux 下mycli的安装与使用 (mysql命令行增强工具)
前置条件
0.准备python相关依赖(注意linux服务器自带python2.6版本保留,千万别删除)
yum install -y libffi-devel
yum -y install zlib-devel bzip2-devel openssl-devel ncurses-devel sqlite-devel readline-devel tk-devel gdbm-devel db4-devel libpcap-devel xz-devel
1.需要安装高版本python,这里选择 Python 3.7.7 下载地址:https://www.python.org/downloads/release/python-377/
2. 将Python-3.7.7.tgz 上传至 /home 下 ,执行解压命令
2.1 tar -xf Python-3.7.7.tgz
2.2 进入目录 cd Python-3.7.7
2.3 开始安装:
[[email protected] Python-3.7.7]# ./configure --prefix=/usr/local/Python-3.7.7/
[[email protected] Python-3.7.7]# make
[[email protected] Python-3.7.7]# make install
成功后如上图所示 会默认安装 pip和steuptools.pip
3. 配置python37全局命令:
[[email protected] Python-3.7.7]# ln -s /usr/local/Python-3.7.7/bin/python3.7 /usr/bin/python37
配置pip37全局命令:
[[email protected] bin]# ln -s /usr/local/Python-3.7.7/bin/pip3.7 /usr/bin/pip37
4.安装mycli (本文重点)
[[email protected] bin]# pip37 install mycli -i http://mirrors.aliyun.com/pypi/simple --trusted-host mirrors.aliyun.com
4.1配置mycli全局命令
[[email protected] mycli]# ln -s /usr/local/Python-3.7.7/bin/mycli /usr/bin/mycli
4.2 使用mycli
[[email protected] /]# mycli -h 192.168.1.165 -P 3306 -u root -p 123456