MySQL ERROR 1064： 'DEFAULT CHARACTER SET utf8'

Question

I create a database specified its charset as utf8 by:

CREATE DATABASE IF NOT EXISTS gtfs;
    DEFAULT CHARACTER SET utf8;
    DEFAULT COLLATE utf8_general_ci;

but encounter the following error：

ERROR 1064 (42000) at line 12: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARACTER SET utf8' at line 1

The version of MySQL:

$ mysql --version
mysql  Ver 14.14 Distrib 5.6.27, for debian-linux-gnu (x86_64) using  EditLine wrapper

Answer 1

Use this

CREATE DATABASE IF NOT EXISTS gtfs
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE utf8_general_ci;