commands.sh

mycli

all

A CLI for MySQL, MariaDB, and Percona that can do auto-completion and syntax highlighting.

More info →

Options (3)

-u, --userboolean

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

Example: mycli {{[-u|--user]}} {{username}} {{database_name}}
-h, --hostboolean

Connect to a database on another host

Example: mycli {{[-h|--host]}} {{database_host}} {{[-P|--port]}} {{port}} {{[-u|--user]}} {{username}} {{database_name}}
-P, --portboolean

Connect to a database on another host

Example: mycli {{[-h|--host]}} {{database_host}} {{[-P|--port]}} {{port}} {{[-u|--user]}} {{username}} {{database_name}}

Examples (3)

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|--user] username database_name

Connect to a database on another host

mycli [-h|--host] database_host [-P|--port] port [-u|--user] username database_name
made by @shridhargupta | data from tldr-pages