Mysqler is a project mainly written in Python, it's free.

a better command line client for mysql to replace the "the MySQL command-line tool"