每次我尝试启动 mysql 时，sudo service mysql restart它都会返回
Job for mysql.service failed because the control process exited with error
code. See "systemctl status mysql.service" and "journalctl -xe" for details.
有人知道这是怎么造成的吗？
这是之后发生的事情systemctl status mysql.service
Jul 04 15:49:46 sandbox systemd[1]: Starting MySQL Community Server...
Jul 04 15:49:46 sandbox mysqld[19504]: 2016-07-04T19:49:46.823245Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
Jul 04 15:49:46 sandbox mysqld[19504]: 2016-07-04T19:49:46.823275Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
Jul 04 15:49:46 sandbox mysqld[19504]: 2016-07-04T19:49:46.955617Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server opti
Jul 04 15:49:46 sandbox mysqld[19504]: 2016-07-04T19:49:46.955943Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.12-0ubuntu1.1-log) starting as process 19504 ...
Jul 04 15:49:46 sandbox mysqld[19504]: 2016-07-04T19:49:46.956626Z 0 [ERROR] COLLATION 'utf8_unicode_ci' is not valid for CHARACTER SET 'latin1'
Jul 04 15:49:46 sandbox mysqld[19504]: 2016-07-04T19:49:46.956656Z 0 [ERROR] Aborting
Jul 04 15:49:46 sandbox mysqld[19504]: 2016-07-04T19:49:46.956682Z 0 [Note] Binlog end
Jul 04 15:49:46 sandbox systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
答案1
mysqld.conf 文件collation-set-server = utf8本来应该character-set-server = utf8