Starting MySQL....The server quit without updating PID file

Hi,

My MySQL server is running on Centos and it is not restarting and giving following error:

Starting MySQL....The server quit without updating PID file (/var/lib/mysql/xxxxx.pid).

MySQL Restart fails and the server quit without updating PID file. What is reason?

Thanks

View Answers

December 26, 2013 at 6:29 PM

Hi,

The reason is that there is some error in my.cnf file.

You should replace the my.cnf with correct version of my.cnf file.

Check the tutorial: cPanel upgrade MySQL 5.1 to 5.5.

Thanks


December 26, 2013 at 6:34 PM

Hi,

You should rename the file using following command:

mv /etc/my.cnf /etc/my.cnf.old

and then try to restart the MySQL Server.

Even if does not starts you should copy the my.cnf file from the directory of your MyServer.

In case of MySQL 5.5 you can use following command:

cp /usr/share/mysql/my-small.cnf /etc/my.cnf

and then change the permission using following command:

cd /etc/
chown -R mysql:mysql my.cnf

Thanks









Related Tutorials/Questions & Answers:
Starting MySQL....The server quit without updating PID file
error: Starting MySQL....The server quit without updating PID file (/var/lib/mysql/xxxxx.pid). MySQL Restart fails and the server quit without updating PID...Starting MySQL....The server quit without updating PID file  Hi, My
Starting MySQL.. ERROR! The server quit without updating PID file
: Starting MySQL.. ERROR! The server quit without updating PID file (/var/lib...Starting MySQL.. ERROR! The server quit without updating PID file  I... and the error is gone. This error "Starting MySQL.. ERROR! The server quit without
Advertisements
Starting MySQL.The server quit without updating PID file
Starting MySQL.The server quit without updating PID file  Starting MySQL.The server quit without updating PID file (/var/lib/mysql/xxxxxx.pid
MySQL server PID file could not be found! [FAILED]
MySQL server PID file could not be found! [FAILED]  MySQL server PID file could not be found! [FAILED
Updating from MySQL 5.0 to 5.5 cPanel
Updating from MySQL 5.0 to 5.5 cPanel   Updating from MySQL 5.0 to 5.5 cPanel
cPanel upgrade MySQL 5.1 to 5.5
PID file could not be found! [FAILED] Starting MySQL.The server quit without updating PID file (/var/lib/mysql/xxxxxx.pid). If such error comes it means.... But in some cases it will may give following errors: MySQL server PID file could
Running faces config file without using internet - Java Server Faces Questions
Running faces config file without using internet  how i can run faces config file without using live internet i have put "web-facesconfig_1_1.dtd" file at local path while i run the jboss,it will throw exception
Upload file without brouse button
Upload file without brouse button  Hi i want to upload 7 files without using browse button . I am using jscript to get the files and to view the files (.jpeg) .But I am not able to enter that address into file field can any body
Retriving data from MYSQL without line break using java
Retriving data from MYSQL without line break using java  get data without line breaking from mysql table (i.e data stored as mediumtext )using java
DELETE with alias reference impossible without selecting a db since MySQL 5.5.3?
DELETE with alias reference impossible without selecting a db since MySQL 5.5.3?   DELETE with alias reference impossible without selecting a db since MySQL 5.5.3
upgrade mysql cpanel server
upgrade mysql cpanel server  upgrade mysql cpanel server
How to save form fields into the MySql Database without submit button in jsp?
How to save form fields into the MySql Database without submit button in jsp?  I want to store user inputs into the database using javasccript or ajax or jqury but without submit button. Form Contains three fields
without ;
without ;  can u give me an example of a program without
without ;
without ;  can u give me an example of a program without
How to compile PHP file and provide it to user without code?
How to compile PHP file and provide it to user without code?  I have... it to my client so that he can be able to use it just like server control in asp.net instead of providing code file. How can I compile the PHP file and provide
How to Write to a File in Java without overwriting
Learn how to Write to a File in Java without overwriting in your Java program This tutorial teaches you how to write to a file in Java without overwriting... which already contains the data and our program will write to this file without
PHP Make a shoutbox without using MYSQL Tutorial
PHP Create a Shoutbox using MySQL       Make a shoutbox (mini forum) using MYSQL database. Now to make your very own PHP shoutbox, which , first of all we need to create a .html file
program to display all words in the file in the sorted order without duplicates
program to display all words in the file in the sorted order without duplicates  I want a java program which accepts a file from user and displays all words in the file in the sorted order without duplicates
without writing web.xml file we can write servlet program
without writing web.xml file we can write servlet program  Sir Morning... Sir I have one Question "without writing web.xml file we can write servlet program". if yes which way? if no why? but without use Annotation........ Plz
ModuleNotFoundError: No module named 'pid'
ModuleNotFoundError: No module named 'pid'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'pid' How to remove the ModuleNotFoundError: No module named 'pid' error
downloading a file directly from mysql using java
downloading a file directly from mysql using java  Hi, I am trying to come up with a code to download a file that is on a mysql database (in form of a blob) without using url. Can anyone tell me how it can be done because I am
Import MYSQL file in PHP - PHP
Import MYSQL file in PHP  i wanted to import the mysql file in PHP5 on button click. is it possible to do it? Is there any possibility of data security
ModuleNotFoundError: No module named 'quit-store'
ModuleNotFoundError: No module named 'quit-store'  Hi, My Python... 'quit-store' How to remove the ModuleNotFoundError: No module named 'quit... have to install padas library. You can install quit-store python
mysql locate cnf file: cPanel MYSQL 5.1 to 5.5
mysql locate cnf file: cPanel MYSQL 5.1 to 5.5  mysql locate cnf file: cPanel MYSQL 5.1 to 5.5
Can MySQL 5.1 read a MySQL 5.5 MyISAM file?
Can MySQL 5.1 read a MySQL 5.5 MyISAM file?  Can MySQL 5.1 read a MySQL 5.5 MyISAM file
jsp upload file to server
jsp upload file to server  How to create and upload file to server in JSP?   Find the given example that explains how to upload single and multiple file on server using JSP
coding for updating profile
coding for updating profile  coding for updating profile
PHP MySql Server Version
PHP MYSQL server version Sometimes we need to check the version of MySql, PHP provides mysql_get_server_info() function to check the MySql version. To check... ' );//mysql_connect(): it open a connection to a MySql server //root is the name
MySQL Training ? Online Free MySQL Training
want to know about MySQL, we are starting from installation to the development... the configuration of MySQL . The MySQL server configuration normally started during ... Executable files This lesson you learn  how to the execute mysql file
upload file to server and store recode in database
upload file to server and store recode in database  i want to upload a file into the server and store a recode in mysql database.any one know the code
Uploading File on Server
Uploading File on Server  Hello, Can someone explain or suggest example. How do i uploading files on the FTP Server. Thanks
how to insert excel file into mysql datbase in servlet
how to insert excel file into mysql datbase in servlet  emphashow to insert excel file into mysql datbase inservletized text
Why do data scientists quit?
Why do data scientists quit?  Hi, I am beginner in Data Science... data scientists quit? Try to provide me good examples or tutorials links so that I can learn the topic "Why do data scientists quit?". Also tell me
How to check if a pid is alive?
How to check if a pid is alive?  Hi, I have a process which is running in background and I want a simple command to find if the process id still running? How to check if a pid is alive? Thanks   HI, You can use
ModuleNotFoundError: No module named 'docker-pid'
ModuleNotFoundError: No module named 'docker-pid'  Hi, My Python... 'docker-pid' How to remove the ModuleNotFoundError: No module named 'docker-pid' error? Thanks   Hi, In your python environment you
ModuleNotFoundError: No module named 'mix-pid'
ModuleNotFoundError: No module named 'mix-pid'  Hi, My Python...-pid' How to remove the ModuleNotFoundError: No module named 'mix-pid... to install padas library. You can install mix-pid python with following command
ModuleNotFoundError: No module named 'pid-childs'
ModuleNotFoundError: No module named 'pid-childs'  Hi, My Python... 'pid-childs' How to remove the ModuleNotFoundError: No module named 'pid... have to install padas library. You can install pid-childs python
ModuleNotFoundError: No module named 'pid_controller'
ModuleNotFoundError: No module named 'pid_controller'  Hi, My... named 'pid_controller' How to remove the ModuleNotFoundError: No module named 'pid_controller' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'pid-elapsed'
ModuleNotFoundError: No module named 'pid-elapsed'  Hi, My Python... 'pid-elapsed' How to remove the ModuleNotFoundError: No module named 'pid-elapsed' error? Thanks   Hi, In your python environment
ModuleNotFoundError: No module named 'pid-killall'
ModuleNotFoundError: No module named 'pid-killall'  Hi, My Python... 'pid-killall' How to remove the ModuleNotFoundError: No module named 'pid-killall' error? Thanks   Hi, In your python environment
ModuleNotFoundError: No module named 'PID-pendulum'
ModuleNotFoundError: No module named 'PID-pendulum'  Hi, My Python... 'PID-pendulum' How to remove the ModuleNotFoundError: No module named 'PID-pendulum' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'pid-trap'
ModuleNotFoundError: No module named 'pid-trap'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'pid-trap' How to remove the ModuleNotFoundError: No module named 'pid-trap
ModuleNotFoundError: No module named 'python-pid'
ModuleNotFoundError: No module named 'python-pid'  Hi, My Python... 'python-pid' How to remove the ModuleNotFoundError: No module named 'python-pid' error? Thanks   Hi, In your python environment you
ModuleNotFoundError: No module named 'python-pid'
ModuleNotFoundError: No module named 'python-pid'  Hi, My Python... 'python-pid' How to remove the ModuleNotFoundError: No module named 'python-pid' error? Thanks   Hi, In your python environment you
ModuleNotFoundError: No module named 'simple-pid'
ModuleNotFoundError: No module named 'simple-pid'  Hi, My Python... 'simple-pid' How to remove the ModuleNotFoundError: No module named 'simple-pid' error? Thanks   Hi, In your python environment you
ModuleNotFoundError: No module named 'docker-pid'
ModuleNotFoundError: No module named 'docker-pid'  Hi, My Python... 'docker-pid' How to remove the ModuleNotFoundError: No module named 'docker-pid' error? Thanks   Hi, In your python environment you
Connecting to remote mysql server using jdbc.
Connecting to remote mysql server using jdbc.  How to Connect to remote mysql server using jdbc
MySQL server has gone away
MySQL server has gone away  Hi, What is the reason of error "MySQL server has gone away"? Some time in my application this error is coming. Thanks   hi friend, This happens because the server is timed out
MySQL Configuration
the MySQLInstanceConfig.exe file directly from bin directory of your MySQL installation. The MySQL server... in the installation directory for the MySQL server.  --defaults-file... of MySQL server . The --defaults-file option instructs the MySQL server to read
need link without underline in jsf - Java Server Faces Questions
need link without underline in jsf  Hi Friend, I need commandlink without underline,now iam using tag for that purpose,is it correct or any other jsf tag is available. (style="text-decoration:none" is html tag). Thanks

Questions by Category