npm

mycli

MySQL CLI with auto-completion and syntax highlighting.

brewmacoslinux
Try with needOr install directly
Source

About

CLI for MySQL with auto-completion and syntax highlighting

Commands

mycli

Examples

connect to local MySQL database$ mycli -u root -p
connect to remote MySQL server with host and database$ mycli -h 192.168.1.100 -u username -p -d mydatabase
run SQL query and exit immediately$ mycli -u root -p -e "SELECT * FROM users LIMIT 5;"
execute SQL commands from a file$ mycli -u root -p mydatabase < script.sql
connect with specific port and enable auto-completion$ mycli -h localhost -P 3307 -u root -p