NAME¶

mycli - Command line client for MySQL/MariaDB and Percona

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