mycli
mycli
TLDR
Connect to a local database on port 3306, using the current user's username
Connect to a database (user will be prompted for a password)
Connect to a database on another host
SYNOPSIS
mycli [OPTIONS] [DATABASE]
DESCRIPTION
mycli is a command line interface for MySQL, MariaDB, and Percona with auto-completion and syntax highlighting. The CLI is also capable of pretty printing tabular data.
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|--pass TEXT
-
Password to connect to the database
- -v|--version
-
Version of mycli
- -D|--database TEXT
-
Database to use
- -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 config group with the specified suffix
- --defaults-file PATH
-
Only read default options from the given file
- --login-path TEXT
-
Read this path from the login file
- --help
-
Shows the help message and exit
AUTHOR
mycli is written by Amjith Ramanujam (http://mycli.net)
This manual page was written by Lennart Weller <lhw@ring0.de>, for the Debian project (but may be used by others).