Shulou(Shulou.com)06/01 Report--

Just finished installing MySQL, the startup times the following error:

Starting MySQL.Manager of pid-file quit without updating file. [FAILED]

Starting MySQL.Manager of pid-file quit without updating file. [FAILED]

I tried the various methods found from Google in turn and found that it can be solved by executing the following MySQL initialization command:

/usr/local/mysql/bin/mysql_install_db --user=mysql

Below is a collection of Google solutions to this problem, which may vary from person to person:

I. Check the error log

Error logs are our way of solving problems. Without them, we have no direction.

I had an installation error and there was this error in the log:

/usr/local/mysql/bin/mysqld: error while loading shared libraries: libstdc++.so.5: cannot open sharedobject file: No such file or directory

The library file libstdc++.so.5 is obviously missing, so we can search for packages related to libstdc to install.

Second, maybe Selinux caused the disaster.

If it is a centos system, selinux will be enabled by default. At this time, you can turn it off first, open/etc/selinux/config, change SELINUX=enforcing to SELINUX=disabled, and then save to exit and restart the machine.

III. Residual data

It is also possible to install mysql on the machine for the second time. Residual data affects the startup of the service. Go to mysql's data directory/data to see if mysql-bin.index exists. Delete it as soon as possible. It is the culprit.

IV. Determine the authority of the data directory

Data directory is generally/data, check its ownership, if not mysql owner, generally install mysql users and groups will be created, then modify the user and group:

chown -R mysql:mysql /var/data

V. No specified data directory

mysql will use the/etc/my.cnf configuration file when it is not specified at startup. Please open this file to see if there is a specified data directory (datadir) under the [mysqld] section. If not, set this line under [mysqld]:

datadir = /usr/local/mysql/data

6. There is also the mysql process running

This is most likely to happen if this is the second time mysql is installed on the machine, and there is a good chance that there is still a mysql process running on the system. You can view it by executing the following command:

ps -ef | grep mysql

If there's more than one line, kill it.

7. Skip-federated fields are causing trouble

Check the/etc/my.cnf file for uncommented skip-federated fields, and comment them out immediately.

Error Log Directory does not exist

Maybe you don't know where the mysql error log is yet? At this point you can execute the command to view:

cd mysql/bin./ mysql_safe

At this time will certainly report an error, and in the error display will be written in a certain directory of a certain file, check whether this directory and file here, in accordance with the log instructions to solve, if not, then create a directory and modify the permissions and attribution. Usually it will be/var/lib/mysql/mysql.error, note that mysql.error is not created.

cd /var/libmkdir mysqlchmod 777 mysqlchown mysql:mysql mysql

Try again then. If it still doesn't work, leave a message and let everyone help you take a look...

The requested URL/data/mysql-bin.index was not found on this server.

Previous cause: mysql won't start up because the hard disk is full. I logged in and found out why. MySQL Manager of pid-file quit without updating file. [FAILED]

There are many explanations for this reason online, but none of them are what I want to say. The reason I want to say is actually very idiotic: data/mysql-bin.index is not deleted, data/mysql-bin.index is the file that stores the log file index, and it is obviously impossible to delete the log file without processing the log index file.

Delete the data/mysql-bin.index file and then service mysqld start.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.