Windows平台安装MySQL客户端命令行神器mycli

最新推荐文章于 2025-04-27 15:17:18 发布

真香IT

最新推荐文章于 2025-04-27 15:17:18 发布

阅读量1.2k

点赞数 2

本文链接：https://blog.youkuaiyun.com/Steven_Start/article/details/122488654

版权

数据库专栏收录该内容

7 篇文章

订阅专栏

本文介绍如何在Windows平台上安装myCLI，这是一个增强版的MySQL命令行客户端。首先需要安装Python 3.10环境，然后通过命令提示符使用pip命令安装myCLI及其依赖库。文章详细列出了安装过程中涉及的所有依赖包。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.下载安装最新版本的python3环境

点击python3.10下载

2.在管理员模式下打开命令行

快捷键 win + x , 选择 Windows终端(管理员) 模式
打开在终端

3.在终端中输入安装命令

 pip install mycli

等待安装完成

PS C:\Users\steve> pip install mycli
Collecting mycli
  Using cached mycli-1.24.2-py2.py3-none-any.whl (97 kB)
Collecting prompt-toolkit<4.0.0,>=3.0.6
  Downloading prompt_toolkit-3.0.24-py3-none-any.whl (374 kB)
     |████████████████████████████████| 374 kB 16 kB/s
Collecting click>=7.0
  Using cached click-8.0.3-py3-none-any.whl (97 kB)
Collecting sqlparse<0.5.0,>=0.3.0
  Downloading sqlparse-0.4.2-py3-none-any.whl (42 kB)
     |████████████████████████████████| 42 kB 25 kB/s
Collecting cli-helpers[styles]>=2.0.1
  Downloading cli_helpers-2.2.0-py3-none-any.whl (19 kB)
Collecting pyperclip>=1.8.1
  Downloading pyperclip-1.8.2.tar.gz (20 kB)
Collecting pyaes>=1.6.1
  Downloading pyaes-1.6.1.tar.gz (28 kB)
Collecting configobj>=5.0.5
  Downloading configobj-5.0.6.tar.gz (33 kB)
Collecting PyMySQL>=0.9.2
  Downloading PyMySQL-1.0.2-py3-none-any.whl (43 kB)
     |████████████████████████████████| 43 kB 37 kB/s
Collecting cryptography>=1.0.0
  Downloading cryptography-36.0.1-cp36-abi3-win_amd64.whl (2.2 MB)
     |████████████████████████████████| 2.2 MB 15 kB/s
Collecting Pygments<=2.11.1,>=1.6
  Downloading Pygments-2.11.1-py3-none-any.whl (1.1 MB)
     |████████████████████████████████| 1.1 MB 26 kB/s
Collecting tabulate[widechars]>=0.8.2
  Downloading tabulate-0.8.9-py3-none-any.whl (25 kB)
Collecting colorama
  Downloading colorama-0.4.4-py2.py3-none-any.whl (16 kB)
Collecting six
  Downloading six-1.16.0-py2.py3-none-any.whl (11 kB)
Collecting cffi>=1.12
  Downloading cffi-1.15.0-cp310-cp310-win_amd64.whl (180 kB)
     |████████████████████████████████| 180 kB 17 kB/s
Collecting pycparser
  Downloading pycparser-2.21-py2.py3-none-any.whl (118 kB)
     |████████████████████████████████| 118 kB 20 kB/s
Collecting wcwidth
  Downloading wcwidth-0.2.5-py2.py3-none-any.whl (30 kB)
Using legacy 'setup.py install' for configobj, since package 'wheel' is not installed.
Using legacy 'setup.py install' for pyaes, since package 'wheel' is not installed.
Using legacy 'setup.py install' for pyperclip, since package 'wheel' is not installed.
Installing collected packages: wcwidth, tabulate, six, pycparser, configobj, Pygments, colorama, cli-helpers, cffi, sqlparse, pyperclip, PyMySQL, pyaes, prompt-toolkit, cryptography, click, mycli
    Running setup.py install for configobj ... done
    Running setup.py install for pyperclip ... done
    Running setup.py install for pyaes ... done
Successfully installed PyMySQL-1.0.2 Pygments-2.11.1 cffi-1.15.0 cli-helpers-2.2.0 click-8.0.3 colorama-0.4.4 configobj-5.0.6 cryptography-36.0.1 mycli-1.24.2 prompt-toolkit-3.0.24 pyaes-1.6.1 pycparser-2.21 pyperclip-1.8.2 six-1.16.0 sqlparse-0.4.2 tabulate-0.8.9 wcwidth-0.2.5

4.mycli 的使用

在命令行中直接连接MySQL使用

mycli -u用户名  -p密码

登录效果

C:\Users\steve>mycli -uroot -p000000
MySQL
mycli 1.24.2
Home: http://mycli.net
Bug tracker: https://github.com/dbcli/mycli/issues
Thanks to the contributor - Karthikeyan Singaravelan
MySQL root@localhost:(none)> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set
Time: 0.015s
MySQL root@localhost:(none)> exit
Goodbye!

使用效果图