mysql命令行爱好者必备工具mycli
2024-09-07 18:20:15
mycli
MyCLI is a command line interface for MySQL, MariaDB, and Percona with auto-completion and syntax highlighting.
- Source: https://github.com/dbcli/mycli
- Chat: Gitter
- Mailing List: https://groups.google.com/forum/#!forum/mycli-users
Quick Start
If you already know how to install python packages, then you can simply do:
$ pip install mycli
If you're on macOS you can install it via homebrew.
$ brew update && brew install mycli
If you're having trouble with the quick start, check the install page for detailed instructions.
Usage
$ mycli --help
Usage: mycli [OPTIONS] [DATABASE] A MySQL terminal client with auto-completion and syntax highlighting. Examples:
- mycli my_database
- mycli -u my_user -h my_host.com my_database
- mycli mysql://my_user@my_host.com:3306/my_database Options:
-h, --host TEXT Host address of the database.
-P, --port INTEGER Port number to use for connection. Honors
$MYSQL_TCP_PORT.
-u, --user TEXT User name to connect to the database.
-S, --socket TEXT The socket file to use for connection.
-p, --password TEXT Password to connect to the database.
--pass TEXT Password to connect to the database.
--ssl-ca PATH CA file in PEM format.
--ssl-capath TEXT CA directory.
--ssl-cert PATH X509 cert in PEM format.
--ssl-key PATH X509 key in PEM format.
--ssl-cipher TEXT SSL cipher to use.
--ssl-verify-server-cert Verify server's "Common Name" in its cert
against hostname used when connecting. This
option is disabled by default.
-V, --version Output mycli's version.
-v, --verbose Verbose output.
-D, --database TEXT Database to use.
-d, --dsn TEXT Use DSN configured into the [alias_dsn]
section of myclirc file.
--list-dsn list of DSN configured into the [alias_dsn]
section of myclirc file.
-R, --prompt TEXT Prompt format (Default: "\t \u@\h:\d> ").
-l, --logfile FILENAME Log every query and its results to a file.
--defaults-group-suffix TEXT Read MySQL config groups with the specified
suffix.
--defaults-file PATH Only read MySQL options from the given file.
--myclirc PATH Location of myclirc file.
--auto-vertical-output Automatically switch to vertical output mode
if the result is wider than the terminal
width.
-t, --table Display batch output in table format.
--csv Display batch output in CSV format.
--warn / --no-warn Warn before running a destructive query.
--local-infile BOOLEAN Enable/disable LOAD DATA LOCAL INFILE.
--login-path TEXT Read this path from the login file.
-e, --execute TEXT Execute command and quit.
--help Show this message and exit.
blogroll
最新文章
- 初始Bootstrap
- UNC 目录格式检测C#代码
- Hibernate的抓取策略
- 关于外部引用JS,中文乱码的问题
- 排序(qsort sort的使用)
- NET Memory Profiler 跟踪.net 应用内存
- Java线程(一):线程安全与不安全
- O​r​a​c​l​e​1​1​g​ ​f​o​r​ ​R​e​d​H​a​t​6​.​4​安​装​手​册
- SQL SERVER 与ACCESS、EXCEL的数据导入导出转换
- Invalid segment BIN$xxx and dba_recyclebin was empty (回收站空,释放无效的BIN$xx空间)
- String、StringBuffer、StringBuilder之间区别
- Java中的换行符
- Asp .Net Core 读取appsettings.json配置文件
- Unicode编码范围
- Javascript 京东轮播图
- c++多态及实现原理
- web项目中的监听器,过滤器以及自定义servlet的执行顺序
- 搭建redsocks 测试环境
- Navicat Premium 12连接Oracle时提示oracle library is not loaded的问题解决
- 【Spring Boot &;&; Spring Cloud系列】Spring Boot的启动器Starter