Ubuntu MySQL does not start a simple troubleshooting

Source: Internet
Author: User
Tags vps domain hosting

Their website for a long time did not go on, want to open found incredibly can not open, so found a series of reasons.

  1. VPS Not
  2. DNS parsing is out of the problem
  3. Domain name problem.

After the simple troubleshooting, my VPS service is to use a bricklayer (bandwagonhost), restarted or inaccessible, and then I looked at the domain hosting I used (dnspod), it seems that there is no problem. Finally checked the domain name provides (freenom), the domain name expires also has one year, should also have no problem.

Later looked for a while, just think will be Apache server did not start
Restarted: sudo apache2ctl-k restart
can be accessed [by his own stupid cry

But MySQL is still not available.
So I tried it. Restart: Service MySQL start
Error said can not start, also did not write what reason (the server on the Ubuntu system is relatively small, error is not complete), looking for half a day do not know what the problem.

Later on the Internet to find information to see the error log (in/var/log/mysql), which wrote the cause of the error is [ERROR]/usr/sbin/mysqld:unknown variable ' Default-character-set=utf8 '

Later on-line search after found to the MySQL configuration file my.cnf in the Default-character-set=utf8 changed to Character_set_server=utf8 on it, tried a bit sure can be = =
(My.cnf in/etc/mysql)
really weak = =

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Ubuntu MySQL does not start a simple troubleshooting

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.