python中读取mysql乱码怎么办？

-- 建表语句

CREATE TABLE books (

  name varchar(50) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 插入数据

insert into books values('万物生光辉');

insert into books values('我亲爱的甜橙树');

insert into books values('教父');

insert into books values('故事');

insert into books values('树上的男爵');

insert into books values('罗马人的故事2');

insert into books values('秘岛（全三册）');

#!/usr/bin/env python

import pymysql.cursors

connection = pymysql.connect(user='用户名', passwd='密码', db='数据库名')

cursor = connection.cursor()

ex = cursor.execute("select name from books")

books = cursor.fetchmany(ex)

for book in books:

    print("%s" % book[0])

connection.close()