[Solution] Create a MySQL database character with charset UTF-8 under Linux Ubuntu

To connect to MySQL

mysql -u root -p

Create a MysSQL Datatase

CREATE DATABASE mydatabase;

or Create a MySQL database character with charset UTF-8

CREATE DATABASE mydatabase CHARACTER SET utf8 COLLATE utf8_general_ci;

Everything is fine :

mysql> CREATE DATABASE webmarketing_en CHARACTER SET utf8 COLLATE utf8_general_ci;
Query OK, 1 row affected (0.00 sec)

Exit

exit