change MySQL’s config file and let it use utf-8 by default
for xampp, the config file is under bin\my.ini

[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci