MYCLI(1)

📦 version 2.14.0, in debian bookworm, debian trixie, ubuntu jammy, ubuntu noble, ubuntu questing, ubuntu resolute, ubuntu stonking

💖 mycli — the manual page, bestie edition 💖

okay so. this is a manual page from the DBCLI family, and it's all about mycli, section 1 of the manuals. strap in, we're gonna slay this 🫶

✨ NAME ✨

mycli — a CLI for MySQL/MariaDB with auto-completion and syntax highlighting. that's it, that's the vibe. 💅

✨ SYNOPSIS ✨

mycli [OPTIONS] [DATABASE]

literally so simple. options, then optionally a database. periodt. 🎀

✨ DESCRIPTION ✨

mycli is a command line interface for MySQL/MariaDB with auto-completion and syntax highlighting, bestie. it's giving ✨aesthetic terminal✨. and that's not even all — it can also pretty print tabular data, which is lowkey the most satisfying thing ever. 🌸

✨ OPTIONS ✨

okay this is the main character section, don't skip a single one:

  • -h, --host TEXT — the host address of the database. where your db actually lives, iykyk. 🏠
  • -P, --port INTEGER — the port number to use for the connection. it honors $MYSQL_TCP_PORT, which is iconic of it. 🚪
  • -u, --user TEXT — user name to connect to the database. who are you in this story? 👑
  • -S, --socket TEXT — the socket file to use for the connection. 🔌
  • -p, --password, --pass TEXT — password to connect to the database. keep it secret, keep it safe, no cap. 🤫
  • -v, --version — shows the version of mycli. 🏷️
  • -D, --database TEXT — database to use. yes queen, pick one. 🗂️
  • -R, --prompt TEXT — the prompt format. default is "\t \u@\h:\d> ". customize it, make it yours, main character energy only. ✨
  • -l, --logfile FILENAME — log every query and its results to a file. receipts!! 📝
  • --defaults-group-suffix TEXT — read config group with the specified suffix. 🧩
  • --defaults-file PATH — only read default options from the given file. just that one, bestie. 📄
  • --login-path TEXT — read this path from the login file. 🛤️
  • --help — shows the help message and exits. the classic. 🆘

✨ EXAMPLES ✨

here's how the girlies actually run it:

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

that last one with the URL? ate. 🔥

✨ SEE ALSO ✨

sibling icons, go show them love 💜

✨ HOMEPAGE ✨

want more tea about mycli and the DBCLI project? it's all on the homepage at https://www.mycli.net and https://www.dbcli.com. 🌈

✨ AUTHORS ✨

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

this manual page was written by Lennart Weller <lhw@ring0.de>, for the Debian project (but may be used by others). 🎀

and that's the whole thing, bestie!! this manual page is for mycli version 2.23.2, under the MYCLI(1) banner, and honestly? she ate. 💅✨ bye babes 🦋

📦 where this page comes from