centos安装mycli

1,环境信息：

[root@centos76_vm pip-21.3.1]# cat /proc/version 
Linux version 3.10.0-1127.el7.x86_64 (mockbuild@kbuilder.bsys.centos.org) (gcc version 4.8.5 20150623 (Red Hat 4.8.5-39) (GCC) ) #1 SMP Tue Mar 31 23:36:51 UTC 2020

2,安装pip：

[root@centos76_vm pip-21.3.1]# curl https://bootstrap.pypa.io/get-pip.py -o get-pip.py
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  3 2108k    3 82192    0     0  49163      0  0:00:43  0:00:01  0:00:42 49157
100 2108k  100 2108k    0     0   785k      0  0:00:02  0:00:02 --:--:--  785k
[root@centos76_vm pip-21.3.1]# 
[root@centos76_vm pip-21.3.1]# 
[root@centos76_vm pip-21.3.1]# python3 get-pip.py 
Looking in indexes: https://pypi.tuna.tsinghua.edu.cn/simple
Collecting pip
  Downloading https://pypi.tuna.tsinghua.edu.cn/packages/a4/6d/6463d49a933f547439d6b5b98b46af8742cc03ae83543e4d7688c2420f8b/pip-21.3.1-py3-none-any.whl (1.7 MB)
     |████████████████████████████████| 1.7 MB 2.3 MB/s            
Collecting wheel
  Downloading https://pypi.tuna.tsinghua.edu.cn/packages/27/d6/003e593296a85fd6ed616ed962795b2f87709c3eee2bca4f6d0fe55c6d00/wheel-0.37.1-py2.py3-none-any.whl (35 kB)
Installing collected packages: wheel, pip
  Attempting uninstall: pip
    Found existing installation: pip 9.0.3
    Uninstalling pip-9.0.3:
      Successfully uninstalled pip-9.0.3
Successfully installed pip-21.3.1 wheel-0.37.1
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv

3,安装mycli

[root@centos76_vm pip-21.3.1]# pip3 install mycli
Looking in indexes: https://pypi.tuna.tsinghua.edu.cn/simple
Collecting mycli
  Downloading https://pypi.tuna.tsinghua.edu.cn/packages/05/06/bacbbbf35f770d8fd07725f56a6b3eeb02f99a0ae1b6f0468c6f88fd0c02/mycli-1.24.1-py2.py3-none-any.whl (96 kB)
     |████████████████████████████████| 96 kB 2.6 MB/s             
Collecting prompt-toolkit<4.0.0,>=3.0.6
  Downloading https://pypi.tuna.tsinghua.edu.cn/packages/fb/37/4f9ae5a6cd0ebdfc1fbafcfd03e812df1ed92a92bf0bee09441c52164f58/prompt_toolkit-3.0.24-py3-none-any.whl (374 kB)
     |████████████████████████████████| 374 kB 4.7 MB/s            
Collecting cli-helpers[styles]>=2.0.1
  Downloading https://pypi.tuna.tsinghua.edu.cn/packages/d9/d1/d7d2ebe7991245590e8c079327d7ccd91a4ad03c91c074777255ebb15e52/cli_helpers-2.2.0-py3-none-any.whl (19 kB)
Collecting pyperclip>=1.8.1
  Downloading https://pypi.tuna.tsinghua.edu.cn/packages/a7/2c/4c64579f847bd5d539803c8b909e54ba087a79d01bb3aba433a95879a6c5/pyperclip-1.8.2.tar.gz (20 kB)
  Preparing metadata (setup.py) ... done
Collecting cryptography>=1.0.0
  Downloading https://pypi.tuna.tsinghua.edu.cn/packages/a7/9f/a725c8f434d24ae656b61539b3c3d22325e8b65331c3f8f943c4cf8858d4/cryptography-36.0.1-cp36-abi3-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (3.8 MB)
     |████████████████████████████████| 3.8 MB 4.1 MB/s            
Collecting Pygments>=1.6
  Downloading https://pypi.tuna.tsinghua.edu.cn/packages/78/c8/8d9be2f72d8f465461f22b5f199c04f7ada933add4dae6e2468133c17471/Pygments-2.10.0-py3-none-any.whl (1.0 MB)
     |████████████████████████████████| 1.0 MB 4.3 MB/s            
Collecting PyMySQL>=0.9.2
  Downloading https://pypi.tuna.tsinghua.edu.cn/packages/4f/52/a115fe175028b058df353c5a3d5290b71514a83f67078a6482cff24d6137/PyMySQL-1.0.2-py3-none-any.whl (43 kB)
     |████████████████████████████████| 43 kB 673 kB/s             
Collecting configobj>=5.0.5
  Downloading https://pypi.tuna.tsinghua.edu.cn/packages/64/61/079eb60459c44929e684fa7d9e2fdca403f67d64dd9dbac27296be2e0fab/configobj-5.0.6.tar.gz (33 kB)
  Preparing metadata (setup.py) ... done
Collecting importlib-resources>=5.0.0
  Downloading https://pypi.tuna.tsinghua.edu.cn/packages/24/1b/33e489669a94da3ef4562938cd306e8fa915e13939d7b8277cb5569cb405/importlib_resources-5.4.0-py3-none-any.whl (28 kB)
Collecting sqlparse<0.4.0,>=0.3.0
  Downloading https://pypi.tuna.tsinghua.edu.cn/packages/85/ee/6e821932f413a5c4b76be9c5936e313e4fc626b33f16e027866e1d60f588/sqlparse-0.3.1-py2.py3-none-any.whl (40 kB)
     |████████████████████████████████| 40 kB 1.6 MB/s             
Collecting click>=7.0
  Downloading https://pypi.tuna.tsinghua.edu.cn/packages/48/58/c8aa6a8e62cc75f39fee1092c45d6b6ba684122697d7ce7d53f64f98a129/click-8.0.3-py3-none-any.whl (97 kB)
     |████████████████████████████████| 97 kB 1.6 MB/s             
Collecting pyaes>=1.6.1
  Downloading https://pypi.tuna.tsinghua.edu.cn/packages/44/66/2c17bae31c906613795711fc78045c285048168919ace2220daa372c7d72/pyaes-1.6.1.tar.gz (28 kB)
  Preparing metadata (setup.py) ... done
Collecting tabulate[widechars]>=0.8.2
  Downloading https://pypi.tuna.tsinghua.edu.cn/packages/ca/80/7c0cad11bd99985cfe7c09427ee0b4f9bd6b048bd13d4ffb32c6db237dfb/tabulate-0.8.9-py3-none-any.whl (25 kB)
Collecting importlib-metadata
  Downloading https://pypi.tuna.tsinghua.edu.cn/packages/a0/a1/b153a0a4caf7a7e3f15c2cd56c7702e2cf3d89b1b359d1f1c5e59d68f4ce/importlib_metadata-4.8.3-py3-none-any.whl (17 kB)
Collecting six
  Downloading https://pypi.tuna.tsinghua.edu.cn/packages/d9/5a/e7c31adbe875f2abbb91bd84cf2dc52d792b5a01506781dbcf25c91daf11/six-1.16.0-py2.py3-none-any.whl (11 kB)
Collecting cffi>=1.12
  Downloading https://pypi.tuna.tsinghua.edu.cn/packages/49/7b/449daf9cacfd7355cea1b4106d2be614315c29ac16567e01756167f6daab/cffi-1.15.0-cp36-cp36m-manylinux_2_5_x86_64.manylinux1_x86_64.whl (405 kB)
     |████████████████████████████████| 405 kB 1.6 MB/s            
Collecting zipp>=3.1.0
  Downloading https://pypi.tuna.tsinghua.edu.cn/packages/bd/df/d4a4974a3e3957fd1c1fa3082366d7fff6e428ddb55f074bf64876f8e8ad/zipp-3.6.0-py3-none-any.whl (5.3 kB)
Collecting wcwidth
  Downloading https://pypi.tuna.tsinghua.edu.cn/packages/59/7c/e39aca596badaf1b78e8f547c807b04dae603a433d3e7a7e04d67f2ef3e5/wcwidth-0.2.5-py2.py3-none-any.whl (30 kB)
Collecting pycparser
  Downloading https://pypi.tuna.tsinghua.edu.cn/packages/62/d5/5f610ebe421e85889f2e55e33b7f9a6795bd982198517d912eb1c76e1a53/pycparser-2.21-py2.py3-none-any.whl (118 kB)
     |████████████████████████████████| 118 kB 2.0 MB/s            
Collecting typing-extensions>=3.6.4
  Downloading https://pypi.tuna.tsinghua.edu.cn/packages/05/e4/baf0031e39cf545f0c9edd5b1a2ea12609b7fcba2d58e118b11753d68cf0/typing_extensions-4.0.1-py3-none-any.whl (22 kB)
Building wheels for collected packages: configobj, pyaes, pyperclip
  Building wheel for configobj (setup.py) ... done
  Created wheel for configobj: filename=configobj-5.0.6-py3-none-any.whl size=34547 sha256=8eb5a7fc8649f5119eb29375b439357f9743c870fb34102902d9d67212dc8133
  Stored in directory: /root/.cache/pip/wheels/f9/cd/21/08abaf28216c36dedfb87cc038133855371acb6dec4639a18c
  Building wheel for pyaes (setup.py) ... done
  Created wheel for pyaes: filename=pyaes-1.6.1-py3-none-any.whl size=26346 sha256=f8fb4873b746c9d193c9b3fd6928dfcc1d1b5684542e7378cc48b701fcbd0e98
  Stored in directory: /root/.cache/pip/wheels/be/c9/76/2a88de3fe85af192219532ab2b5dc627cb53bdcf93d4b9dc6c
  Building wheel for pyperclip (setup.py) ... done
  Created wheel for pyperclip: filename=pyperclip-1.8.2-py3-none-any.whl size=11107 sha256=c24af1b6777340efc4e011b81a66acfd7a8d848148821d90920005832d43bdb4
  Stored in directory: /root/.cache/pip/wheels/e8/f9/e4/82121f7ae06105b8f756ac3d6b365dd34262c4dd1e379646a5
Successfully built configobj pyaes pyperclip
Installing collected packages: wcwidth, tabulate, six, zipp, typing-extensions, pycparser, configobj, Pygments, importlib-metadata, cli-helpers, cffi, sqlparse, pyperclip, PyMySQL, pyaes, prompt-toolkit, importlib-resources, cryptography, click, mycli
Successfully installed PyMySQL-1.0.2 Pygments-2.10.0 cffi-1.15.0 cli-helpers-2.2.0 click-8.0.3 configobj-5.0.6 cryptography-36.0.1 importlib-metadata-4.8.3 importlib-resources-5.4.0 mycli-1.24.1 prompt-toolkit-3.0.24 pyaes-1.6.1 pycparser-2.21 pyperclip-1.8.2 six-1.16.0 sqlparse-0.3.1 tabulate-0.8.9 typing-extensions-4.0.1 wcwidth-0.2.5 zipp-3.6.0
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv

4，使用mycli：

[root@centos76_vm pip-21.3.1]# mycli -h ip -P4000 -uroot 
MySQL 5.7.25
mycli 1.24.1
Home: http://mycli.net
Bug tracker: https://github.com/dbcli/mycli/issues
Thanks to the contributor - chainkite
MySQL root@12.16.7.21:(none)>
MySQL root@12.16.7.21:(none)>
MySQL root@12.16.7.21:(none)> select count