mycli

TLDR

Connect to a local database on port 3306, using the current user's username

$ mycli [database_name]

Connect to a database (user will be prompted for a password)

$ mycli -u [username] [database_name]

Connect to a database on another host

$ mycli -h [database_host] -P [port] -u [username] [database_name]

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).