超秀的 MySQL 客户端工具 MyCli ===> 支持自动补全关键字、表名、列和函数数据库

MyCli 是 MySQL 的专用命令行客户端，可以自动补全和语法高亮显示。 MyCli 是 MySQL，MariaDB 和 Percona 的命令行客户端工具，具有自动补全和语法突出显示功能。
效果图:

文章图片

兼容性：

Mycli 在macOS 和 Linux 上进行了测试。可运行在 Python 2.7 和 3.4+ 上。

注意：在mycli 1.9.0 中删除了 Python 2.6 支持。如果您正在运行Python 2.6，则需要安装mycli 1.8.1。
尽快安装安装体验吧 ! ! ! Windows系统：

按照此博客文章中的说明在Windows上安装mycli：https://www.codewall.co.uk/installing-using-mycli-on-windows/

苹果系统：

在Mac上安装mycli 使用以下命令:

brew update && brew install mycli

Linux系统：

Debian 和 Ubuntu 版安装方法：
打开终端用以下命令安装即可:

apt安装方法:
sudo apt-get update
sudo apt-get install mycli
或pip安装方法:
pip3 install -U mycli

RHEL 和 Centos 版本：
用pip安装mycli。您可以pip使用以下命令在系统上安装：

sudo yum install python -pip python-devel

pip 安装完成后，用以下命令安装 mycli：

sudo pip install mycli

登录MySQL方法:

python@ubuntu:~$ mycli -uroot
Password: ********

用法: 方法一. 可以直接在终端输入以下命令:

mycli -h 192.168.1.100 -P 3306 -u root -p ******
其中：

-h 是需要运行 mysql 命令的服务器 IP 地址。轻松连接到远程服务器，进行数据库的「增删改查」操作。如果是连接本地数据库, 可以省略该项，

-P 注意是大写的，即 mysql 数据库的端口，一般默认是 3306。

-u 用户名, 本地用户名一般是 root

-p 注意是小写的，也可以不用在这一步明文输入密码，而是以交互的形式来输入密码，保证账户安全。

方法二. 我们也可以设置短命令来启动，命令如下

alias mysql@100='mycli -h 192.168.1.100 -P 3306 -u root -p ******'
以后就可以直接在终端使用 mysql@100 来调用 mycli 用以连接数据库了
mysql@100

配置:

我们可以简单配置 mycli 以符合我们的使用习惯, 如下:
mycli 配置文件在 ~/.myclirc ，参考下面配置文件根据自己需要进行相应的修改与设置，比如字体颜色、自动补全、键盘使用习惯(Emacs vs Vi/Vim)
文章图片

配置文件如下:

# vi: ft=dosini
[main]
# Enables context sensitive auto-completion. If this is disabled the all
# possible completions will be listed.
smart_completion = True
# Multi-line mode allows breaking up the sql statements into multiple lines. If
# this is set to True, then the end of the statements must have a semi-colon.
# If this is set to False then sql statements can't be split into multiple
# lines. End of line (return) is considered as the end of the statement.
multi_line = False
# Destructive warning mode will alert you before executing a sql statement
# that may cause harm to the database such as "drop table", "drop database"
# or "shutdown".
destructive_warning = True
# log_file location.
log_file = ~/.mycli.log
# Default log level. Possible values: "CRITICAL", "ERROR", "WARNING", "INFO"
# and "DEBUG". "NONE" disables logging.
log_level = INFO
# Log every query and its results to a file. Enable this by uncommenting the
# line below.
# audit_log = ~/.mycli-audit.log
# Timing of sql statments and table rendering.
timing = True
# Table format. Possible values: psql, plain, simple, grid, fancy_grid, pipe,
# orgtbl, rst, mediawiki, html, latex, latex_booktabs, tsv.
# Recommended: psql, fancy_grid and grid.
## 数据表的显示方式( 有三种: psql, fancy_grid, grid )
table_format = fancy_grid
# Syntax coloring style. Possible values (many support the "-dark" suffix):
# manni, igor, xcode, vim, autumn, vs, rrt, native, perldoc, borland, tango, emacs,
# friendly, monokai, paraiso, colorful, murphy, bw, pastie, paraiso, trac, default,
# fruity.
# Screenshots at http://mycli.net/syntax
# syntax_style = default
syntax_style = monokai
# Keybindings: Possible values: emacs, vi.
# Emacs mode: Ctrl-A is home, Ctrl-E is end. All emacs keybindings are available in the REPL.
# When Vi mode is enabled you can use modal editing features offered by Vi in the REPL.
key_bindings = emacs
# Enabling this option will show the suggestions in a wider menu. Thus more items are suggested.
wider_completion_menu = False
# MySQL prompt
【超秀的 MySQL 客户端工具 MyCli ===> 支持自动补全关键字、表名、列和函数】# \t - Product type (Percona, MySQL, Mariadb)
# \u - Username
# \h - Hostname of the server
# \d - Database name
# \n - Newline
prompt = '\t \u@\h:\d> '
prompt_continuation = '-> '
# Skip intro info on startup and outro info on exit
# less_chatty = False
less_chatty = True
# Use alias from --login-path instead of host name in prompt
login_path_as_host = False
# Custom colors for the completion menu, toolbar, etc.
[colors]
# Completion menus.
## 选中关键字的颜色
# Token.Menu.Completions.Completion.Current = 'bg:#00aaaa #000000'
Token.Menu.Completions.Completion.Current = 'bg:#6A5ACD #aaffff'
## 备选关键字的颜色
Token.Menu.Completions.Completion = 'bg:#ebdbb2 #000000'
# Token.Menu.Completions.MultiColumnMeta = 'bg:#aaffff #000000'
Token.Menu.Completions.MultiColumnMeta = 'bg:#d79921 #000000'
Token.Menu.Completions.ProgressButton = 'bg:#003333'
Token.Menu.Completions.ProgressBar = 'bg:#00aaaa'
# Selected text.
Token.SelectedText = '#ffffff bg:#6666aa'
# Search matches. (reverse-i-search)
Token.SearchMatch = '#ffffff bg:#4444aa'
Token.SearchMatch.Current = '#ffffff bg:#44aa44'
# The bottom toolbar.
Token.Toolbar = 'bg:#222222 #aaaaaa'
Token.Toolbar.Off = 'bg:#222222 #888888'
Token.Toolbar.On = 'bg:#222222 #ffffff'
# Search/arg/system toolbars.
Token.Toolbar.Search = 'noinherit bold'
Token.Toolbar.Search.Text = 'nobold'
Token.Toolbar.System = 'noinherit bold'
Token.Toolbar.Arg = 'noinherit bold'
Token.Toolbar.Arg.Text = 'nobold'
# Favorite queries.
[favorite_queries]

MyCli使用帮助说明文档:

mycli --help用法: mycli [OPTIONS] [DATABASE] 例如:- mycli my_database - mycli -u my_user_name -h my_host.com my_database - mycli mysql://my_user@my_host.com:3306/my_database常用选项: -h, --host TEXT数据库的主机地址. -P, --port INTEGER用于连接的端口号. Honors$MYSQL_TCP_PORT. -u, --user TEXT要连接数据库的用户名. -S, --socket TEXT用于连接的套接字文件. -p, --password TEXT要连接数据库的密码. --help查看帮助信息非常用选项: --pass TEXT要连接数据库的密码. --ssh-user TEXT连接SSH服务器的用户名. --ssh-host TEXT连接SSH服务器的主机名. --ssh-port INTEGER连接SSH服务器的端口. --ssh-password TEXT连接SSH服务器的密码. --ssh-key-filename TEXTPrivate key filename (identify file) for the ssh connection. --ssl-ca PATHCA file in PEM format. --ssl-capath TEXTCA directory. --ssl-cert PATHX509 cert in PEM format. --ssl-key PATHX509 key in PEM format. --ssl-cipher TEXTSSL cipher to use. --ssl-verify-server-certVerify server's "Common Name" in its cert against hostname used when connecting. This option is disabled by default. -V, --versionOutput mycli's version. -v, --verboseVerbose output. -D, --database TEXTDatabase to use. -d, --dsn TEXTUse DSN configured into the [alias_dsn] section of myclirc file. --list-dsnlist of DSN configured into the [alias_dsn] section of myclirc file. -R, --prompt TEXTPrompt format (Default: "\t \u@\h:\d> "). -l, --logfile FILENAMELog every query and its results to a file. --defaults-group-suffix TEXTRead MySQL config groups with the specified suffix. --defaults-file PATHOnly read MySQL options from the given file. --myclirc PATHLocation of myclirc file. --auto-vertical-outputAutomatically switch to vertical output mode if the result is wider than the terminal width. -t, --tableDisplay batch output in table format. --csvDisplay batch output in CSV format. --warn / --no-warnWarn before running a destructive query. --local-infile BOOLEANEnable/disable LOAD DATA LOCAL INFILE. --login-path TEXTRead this path from the login file. -e, --execute TEXTExecute command and quit.