To work with mysql, we normally use the default mysql client:
mysql -u mysql_user -p
However mysql does not have auto-completion which could be very helpful. You can use mycli to do that.
pip3 install --user mycli mycli -u mysql_user
Unfortunately mycli does not support keywords and JSON functions from newer mysql 5.7 and mysql 8.
You can install mysqlsh which supports all those auto-completion, new keywords and JSON function for both Mysql 5.7 and 8.0.