Archive for October, 2008
“…
./mysql.server start
Starting MySQL
. ERROR! Manager of pid-file quit without updating file.
…”
If you’ve ever had to configure a CentOS system from scratch you may have noticed yourself running into issues when ( some of many examples) it came to the MySQL installation whether it be the default yum install, manual RPM packages or even compiling from source, well not so much the installation itself but when it came time to start it. It simply would not start, and the error logs reveal nothing. I have come to this issue myself and faced with much frustration and no answers even from the MySQL developers themselves I think I have finally found a fix.
I decided to check the SE Linux permission settings (no idea why), and it seemed to fix the issue. Depending on your host, you may have a very relaxed setup on a fresh install, others may not be so. In order to tweak these settings via SSH, run this command when logged in as root:
yum install -y system-config-securitylevel
If it’s already installed, you can go ahead and enter the manager.
system-config-securitylevel
This will reveal a blue screen, perhaps unsusual to the sight of a blank SSH screen:
From this screen, you can use tab to switch between options, the arrow keys to move up and down, and space to select. In order for the most relaxed possible (though perhaps not preferred depending on what you’re using the server for) you could select these options:
Now, tab onto the “OK” button and hit the space bar. The manager will exit. MySQL should now start with no issues regarding the PID manager. Don’t forget to set your root password.
-Erratic.