I still run mysqlcc as a fast and simple MySQL client. It's kind of a pain to get working on modern Linux. These are the RPMs needed to run mysqlcc on Fedora 16 box.

yum install glibc.i686 mesa-libGL.i686 libXmu.i686 libXrender.i686 libXrandr.i686 libXcursor.i686 libXft.i686