---
syntax: markdown
tags: [tldr, common]
source: https://github.com/tldr-pages/tldr.git
---
# 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}}`
