mycli官网地址
参考大佬的这篇
注意官方这样讲: mycli 1.9.0中删除了对Python 2.6的支持。
如果您正在运行Python 2.6,则需要安装mycli 1.8.1。
[root@ylxqc:~]# python -V
Python 2.7.5
但是我安装的时候Python的版本是2.7的,遇到了如下的坑
pip install mycli
Found existing installation: configobj 4.7.2
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.
解决方法:
pip install --ignore-installed mycli
紧接着:
Traceback (most recent call last):
File "/usr/bin/mycli", line 5, in <module>
from mycli.main import cli
File "/usr/lib/python2.7/site-packages/mycli/main.py", line 44, in <module>
from .config import (write_default_config, get_mylogin_cnf_path,
File "/usr/lib/python2.7/site-packages/mycli/config.py", line 28
print(message, file=sys.stderr) #这里说的是python2.7的事情,可能是最新的mycli对python2.7不支持
^
SyntaxError: invalid syntax
经过多次测试发现大于1.8.1的版本(比如1.9.0)都不支持python2.x
解决办法:要么升级python,要么指定mycli的版本小于等于1.8.1
Linux centos7 升级安装Python2.7到3.6 参考 https://www.jianshu.com/p/1cc8f77679c8
我选择简单的,降低版本
yum -y install gcc libffi-devel python-devel openssl-devel && pip install mycli==1.8.1
#注意这里没有--ignore-installed选项
紧接着:
[root@ylxqc:~]# mycli -uroot -p123
(2003, "Can't connect to MySQL server on u'localhost' ([Errno 113] No route to host)")
原因:是我改了mysql的默认端口,所以在登录的时候要指定端口
[root@ylxqc:~]# mycli -uroot -pylxqc@668XF -Pxxxx
Version: 1.8.1
Chat: https://gitter.im/dbcli/mycli
Mail: https://groups.google.com/forum/#!forum/mycli-users
Home: http://mycli.net
Thanks to the contributor - jweiland.net
mysql root@localhost:(none)>
不简单啊,终于进来了!!!!