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

Ads
 

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

Ads









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
cPanel upgrade MySQL 5.1 to 5.5
it will may give following errors: MySQL server PID file could not be found! [FAILED] or service mysql restart MySQL server PID file could not be found! [FAILED] Starting MySQL.The server quit without updating PID file (/var/lib/mysql
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
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
upgrade mysql cpanel server
upgrade mysql cpanel server  upgrade mysql cpanel server
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
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
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
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
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
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
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
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
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 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 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
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
download mp3 file on server in iphone
download mp3 file on server in iphone  I want to download mp3 file on the server in iphone......plz help me give me the demo code
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
Connecting to remote mysql server using jdbc.
Connecting to remote mysql server using jdbc.  How to Connect to remote mysql server using jdbc
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
without ;
without ;  can u give me an example of a program without
without ;
without ;  can u give me an example of a program without
uploading file to tomcat server
uploading file to tomcat server  please tell me how to upload a file to the URL "http://192.168.12.7:8000/tomcat-docs/" ? thanks
FTP Server : Upload file
This tutorial contains description of file uploading to the FTP server using java
FTP Server : Download file
This tutorial contains description of file downloading from the FTP server using java
FTPClient : Server File transfer
In this tutorial, you will learn how to transfer file on the server by using FTPClient class

Ads