Ubuntu mysql cannot be started for simple troubleshooting. tumysql

Ubuntu mysql cannot be started for simple troubleshooting. tumysql

My website has not been on for a long time. I want to open it and find that it cannot be opened, so I found a series of reasons.

After a simple investigation, my vps service was commercially available as a bricklayer (bandwagonhost). After I restarted the service, I still couldn't access it. Later I checked my domain name hosting (dnspod ), it seems that there is no problem. Finally, I checked the domain name provision (freenom). The domain name has expired for one year, and it should be okay.

Later, after reading it for a while, I realized whether the apache server was not started.
Restart: sudo apache2ctl-k restart
You can access it.

However, mysql is still unavailable.
So I tried to restart: service mysql start
The error indicates that the instance cannot be started, and there is no reason to write it (the ubuntu system on the server is relatively small, and the error message is incomplete). After searching for the system for a long time, I don't know what the problem is.

Later, I found the information on the Internet and found the ERROR log (in/var/log/mysql). The ERROR cause is [ERROR]/usr/sbin/mysqld: unknown variable 'default-character-set = utf8'

After checking the information on the Internet, I found that I had to change the default-character-set = utf8 In the mysql configuration file my. cnf to character_set_server = utf8. After I tried it, I could =
(My. cnf is in/etc/mysql)
Really weak =

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.