Mysql console:
When openin the console:
mysql --default-character-set=utf8
Query in the opened console:
SET NAMES utf8;
Python
db = MySQLdb.connect(host="localhost", user='root', passwd='passwd', db='mydatabase', use_unicode=True, charset="utf8")