Back to MySQL

See Also MySQL Commands

mycli

A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting.

1. Installation

1.1. OS X

➜  ~  brew install mycli
==> Downloading https://homebrew.bintray.com/bottles/mycli-1.0.1.yosemite.bottle
######################################################################## 100.0%
==> Pouring mycli-1.0.1.yosemite.bottle.tar.gz
🍺  /usr/local/Cellar/mycli/1.0.1: 398 files, 4.6M

➜  ~  mycli
Version: 1.0.1
Chat: https://gitter.im/dbcli/mycli
Mail: https://groups.google.com/forum/#!forum/mycli-users
Home: http://mycli.net
Thanks to the contributor - Chris Anderton
mysql liyan@localhost:(none)> show databases;

1.2. CentOS

## Install on CentOS
# yum install python-pip -y
# pip install mycli

1.3. Cygwin

  1. Make sure the following Cygwin packages are installed: python3, python3-pip.

  2. Install mycli: pip3 install mycli

2. Usage

2.1. Use SSH Tunnel

## set up the tunnel:
ssh -Nf <ssh-user>@<ssh-host> -L 3306:<remote-mysql-host>:3306
## connect to mysql as if it was running on localhost
mycli -h localhost -P 3306

2.2. 数据导入导出


3. Reference


CategoryTool

MainWiki: mycli (last edited 2018-05-28 15:52:30 by twotwo)