Scroll to navigation

MYCLI(1) DBCLI MYCLI(1)

NAME

mycli - CLI for MySQL/MariaDB with auto-completion and syntax highlighting

SYNOPSIS

mycli [OPTIONS] [DATABASE]

DESCRIPTION

mycli is a command line interface for MySQL/MariaDB with auto-completion and syntax highlighting. It is also capable of pretty printing tabular data.

OPTIONS

Host address of the database.

Port number to use for connection. Honors $MYSQL_TCP_PORT.

User name to connect to the database.

The socket file to use for connection.

Password to connect to the database.

Version of mycli.

Database to use.

Prompt format (Default: "\t \u@\h:\d> ").

Log every query and its results to a file.

Read config group with the specified suffix.

Only read default options from the given file.

Read this path from the login file.

Shows the help message and exit.

EXAMPLES

$ mycli my_database

$ mycli -u my_user -h my_host.com my_database
$ mycli mysql://my_user@my_host.com:3306/my_database

SEE ALSO

litecli(1)

pgcli(1)

HOMEPAGE

More information about mycli and the DBCLI project can be found on the homepage at https://www.mycli.net and https://www.dbcli.com.

AUTHORS

mycli was written by Amjith Ramanujam <amjith.r@gmail.com>.

2.23.2 mycli