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 a local MySQL server with a username$ mycli -u root
Connect to a remote MySQL server with host and database$ mycli -h 192.168.1.100 -u user -p password -d mydatabase
Execute a query directly without entering interactive mode$ mycli -u root -e "SELECT * FROM users LIMIT 10;"