Skip to content

about

centos7.9 + mysql-5.7.20 + mycli

习惯了bash中的自动补全,然后登录到mysql客户端之后,全部手扣命令......太难了... 所以就从网上找找有没有能在mysql客户端补全的插件,结果还真有,那就是第三方的mycli这个软件。

install

首先这个软件依赖pip环境,所以还要先下载pip:

bash
yum install -y epel-release
yum update -y
yum install gcc patch libffi-devel python-devel  zlib-devel bzip2-devel openssl-devel ncurses-devel sqlite-devel readline-devel tk-devel gdbm-devel db4-devel libpcap-devel xz-devel -y
yum install python36 -y
pip3 install -U pip
python3 -V
pip3 -V

下载mycli:

bash
# pip3 install mycli
pip3 install -i https://pypi.tuna.tsinghua.edu.cn/simple mycli

测试:

bash
# 直接登录即可
mycli -uroot -p

1832670219407982592.png


that's all,see also: Linux下非常强大的MySQL命令行客户端工具(支持自动补全) | linux下mysql的自动补全工具mycli