O arquivo mysqld.conf tinha collation-set-server = utf8 quando deveria ter sido character-set-server = utf8
Toda vez que tento iniciar o mysql com sudo service mysql restart , ele retorna
Job for mysql.service failed because the control process exited with error
code. See "systemctl status mysql.service" and "journalctl -xe" for details.
Alguém tem alguma ideia de como isso está sendo causado?
Isso é o que surgiu depois de 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
O arquivo mysqld.conf tinha collation-set-server = utf8 quando deveria ter sido character-set-server = utf8