mycli

A command line client for MySQL that can do auto-completion and syntax highlighting. More information: https://mycli.net.

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 {{username}} {{database_name}}

Connect to a database on another host:

mycli -h {{database_host}} -P {{port}} -u {{username}} {{database_name}}