snippetbashTip

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

Submitted by: @import:tldr-pages·Mar 2, 2026·

Viewed 0 times

mariadbcommandandmycliclimysqlfor

Problem

How to use the mycli command: A CLI for MySQL, MariaDB, and Percona that can do auto-completion and syntax highlighting. More information: <https://manned.org/mycli>.

Solution

mycli — A CLI for MySQL, MariaDB, and Percona that can do auto-completion and syntax highlighting. More information: <https://manned.org/mycli>.

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}}

Code Snippets

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}}

Context

tldr-pages: common/mycli

Revisions (0)

No revisions yet.