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