Pid file quit without updating fi

For example, I experienced this problem today after upgrading the Apache and Ruby (Yes, My SQL is not part of the update), and I got this error message afterward.

After rebooting the computer, the error message is gone.

[FAILED]rn Starting My SQL.................................................................................................... These may getrn# overwritten by settings in the My SQL configuration files.rnrnbasedir=rndatadir=rnrn# The following variables are only set for letting mysql.server find things.rnrn# Set some defaultsrnrnpid_file=rnserver_pid_file=rnuse_mysqld_safe=1rnuser=mysqlrnif test -z "$basedir"rnthenrn basedir=/var/lib/mysqlrn bindir=./binrn if test -z "$datadir"rn thenrn datadir=/var/lib/mysqlrn firn sbindir=./binrn libexecdir=./binrnelsern bindir="$basedir/bin"rn if test -z "$datadir"rn thenrn datadir="$basedir/data"rn firn sbindir="$basedir/sbin"rn libexecdir="$basedir/libexec"rnfirnrn# If the manager pid_file doesn't exist, try the server'srnif test -s "$pid_file"rn thenrn mysqlmanager_pid=`cat $pid_file`rn echo $echo_n "Shutting down My SQL"rn kill $mysqlmanager_pidrn # mysqlmanager should remove the pid_file when it exits, so wait for wait_for_pid removed "$mysqlmanager_pid"; return_value=$?

rnrn # delete lock for Red Hat / Su SErn if test -f $lock_dirrn thenrn rm -f $lock_dirrn firn exit $return_valuern elsern log_failure_msg "My SQL manager or server PID file could not be found!

Manager of pid-file quit without updating fi[FAILED]rn使用命令:rn# /opt/software/mysql/bin/mysqld_safe --user=rootrnrn110107 mysqld_safe Logging to '/opt/software/mysql/var/nat180.err'.rn110107 mysqld_safe Starting mysqld daemon with databases from /opt/software/mysql/varrn(屏幕也一直停在这里)rn再开一个putty连接上去后rnmysql已经启动了rnrn为什么用mysql.server启动不了呢?

出现问题的可能性 1、可能是/opt/mysql/data/数据目录mysql用户没有权限(修改数据目录的权限) 解决方法 :给予权限,执行 "chown -R mysql.mysql /opt/mysql/data" 然后重新启动mysqld 2、可能进程里已经存在mysql进程 解决方法:用命令“ps -ef|grep mysqld”查看是否有mysqld进程,如果有使用“kill -9 进程号”杀死,然后重新启动mysqld! 3、可能是第二次在机器上安装mysql,有残余数据影响了服务的启动。 解决方法:去mysql的二进制日志目录看看,如果存在mysql-binlog.index,就赶快把它删除掉吧 4、mysql在启动时没有指定配置文件时会使用/etc/my.cnf配置文件,请打开这个文件查看在[mysqld]下有没有指定数据目录(datadir)。 解决方法:请在[mysqld]下设置这一行:datadir = /opt/mysql/data 5、skip-federated字段问题 解决方法:检查一下/etc/my.cnf文件中有没有没被注释掉的skip-federated字段,如果有就立即注释掉吧。 6、错误日志目录不存在 解决方法:使用“chown” “chmod”命令赋予mysql所有者及权限 7、selinux惹的祸,如果是centos系统,默认会开启selinux 1解决方法:先临时改为警告模式:[[email protected] php]# setenforce 0 2然后打开/etc/sysconfig/selinux,把SELINUX=enforcing改为SELINUX=disabled 8、启动失败注意检查数据目录的权限,要与mysql程序运行用户权限一致。 1[[email protected] mysql]# chown -R mysql.mysql ../mysql 最好是整个mysql程序目录都授权予mysql用户。 service mysql restart linux重启mysql服务rnrn提示:rn ERROR! * rnrn但是,无法登陆了:rn***@***-Virtual Box:/etc/mysql/conf.d$ sudo mysql -u root -prn Enter password: rn[color=#FF0000]ERROR 2002 (HY000): Can't connect to local My SQL server through socket '/var/run/mysqld/mysqld.sock' (2)[/color]rnrnrn这个错误我用了各种办法无法解决,无奈把my.cnf的名称变回来:rnrn***@***-Virtual Box:/etc$ [color=#0000FF]sudo mv /etc/old /etc/my.cnf[/color]rn####################################################################rnrnrn请问,错误:rn[color=#FF0000]....

* The server quit without updating PID file (/usr/local/mysql/data/***-Virtual Box.pid).[/color]rnrn针对以上错误,网上各种百度,各种谷歌都解决不了,还是提示上面的同样的错误rnrnrn我采用下面的方法,竟然可以启动My SQL,但是又引发了其他的无法解决的errorrn################################## 方法如下 ##############################rn按照网址: SQL服务,如下:rn***@***-Virtual Box:/etc$ [color=#0000FF]sudo mv /etc//etc/old[/color]rn***@***-Virtual Box:/etc$ sudo /etc/init.d/mysql.server startrn Starting My SQLrn..

S PM .42 /usr/local/Cellar/mysql/5.7.19/bin/mysqld -- basedir=/usr/local/Cellar/mysql/5.7.19 --datadir=/usr/local/var/mysql --plugin-dir=/usr/local/Cellar/mysql/5.7.19/lib/plugin -- log-error=Mnmandahalfs-Mac Book-Pro.--pid-file=Mnmandahalfs-Mac Book-Pro.manami 72024 0.0 0.0 2438664 1972 ??

I read in some forums that doing a giving a /bin/sh before the /etc/init.d/mysql start would solve the problem and it did.

Search for pid file quit without updating fi:

pid file quit without updating fi-19pid file quit without updating fi-32pid file quit without updating fi-18

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “pid file quit without updating fi”

  1. Whether you want to open loot boxes or trade your way to the top, Case Simulator 2 can provide you with the player-run economy you need. Test your driving skills and download Russian Car Driver HD PC game for free.