Mycli is a modern alternative to the default MySQL client. This tool does to MySQL what bpython does to the standard Python REPL. Mycli will auto-complete keywords, table names, columns, and functions as you type them.
The completion suggestions are context-sensitive. For example, after the SELECT * FROM, only tables from the current database are listed in the completion, rather than every possible keyword under the sun.
1. install some packages:
apt-get install python3-click -y
Code language: Bash (bash)
2. now to install the software
apt-get install mycli -y
Code language: Bash (bash)