修改MySQL的字符集编码和时区

mysql-mycnf.md

$ sudo vim /etc/mysql/my.cnf，加入下面几行。

[mysqld]
character-set-server = utf8
collation-server = utf8_general_ci
default-time_zone = '+8:00'                                                                                                                                                                                    

[client]
default-character-set = utf8
 
[mysql]
default-character-set = utf8
prompt = \\u@\\h[\\d]>\\_

重启mysql