MySQL does not boot after Libmysqlclient-dev installation in Debian

Source: Internet
Author: User
Tags mysql client

System environment: DEBIAN,AMH Panel
Because the MySQL client is developed with C + +, the Libmysqlclient-dev is installed, and then AMH MySQL does not start, and the error message is:
The server quit without updating PID file (/var/run/mysqld/mysqld.pid)

After the search was fruitless, I tried to think of all the causes of the problem, luckily I had a VPS with the AMH panel installed, so I started to compare the environment and configuration of 2 machines with the contrast method.
First look at the configuration file used by MySQL server.


root@debian:/home/nine#/usr/local/mysql/bin/mysql--verbose--help | Grep-a 1 ' Default options '
Back: Default options are read from the following files in the given order:
/ETC/MY.CNF/ETC/MYSQL/MY.CNF/USR/LOCAL/MYSQL/ETC/MY.CNF ~/.my.cnf

Originally, Libmysqlclient-dev installed after the installation of 3 profiles, which point to different directories, resulting in configuration confusion, RM command Delete:


root@debian:/home/nine# rm-f/etc/mysql/my.cnf
root@debian:/home/nine# rm-f/usr/local/mysql/etc/my.cnf
root@debian:/home/nine# rm-f ~/.my.cnf
At this point, the MySQL server has been able to start normally.

Related Article

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.