CentOS 7 mariadb Boot issue

After installing MARIADB one day, restarting the machine will not start the mariadb.service.

Systemctl start Mariadb.service//Then find the following question

Job for Mariadb.service failed because the control process exited with error code.

See "Systemctl Status Mariadb.service" and "Journalctl-xe" for details

According to the above view nothing but see the "Journalctl-xe" in the start mariadb when there is logging to '/var/log/mariadb/mariadb.log ' and then go to check the log

Find the last below on aborting there is a row Character set ' UTF8 ' is not a compiled Character set and is not specified in the '/usr/share/mysql/ Charsets/index.xml '

After that, check out this index.xml and find UTF8 this configuration.

It's a dog.

Then guess the server configuration might not specify a character set

Then find the server configuration

Inside the/ETC/MYCNF.D there is a server.cnf added under [mysqld]

Character-set-server=utf8 Save

Then Systemctl start Mariadb.service

OK, fix it.

CentOS 7 mariadb Boot issue