Pid file quit without updating fi Adult online chat rooms to trade pics and videos
13-Jan-2020 07:30
Please remove the file manually and start /usr/local/Cellar/mysql/5.7.19/bin/mysqld_safe again; mysqld daemon not started ERROR!The server quit without updating PID file (/usr/local/var/mysql/Mnmandahalfs-Mac Book-Pro.local.pid).rn120129 [color=#FF0000]Inno DB: Database was not shut down normally!features on the off chancethey may be needed at some point in the future.$ sudo chown -R mnmandahalf /usr/local/var/mysql/ Password: $ mysql.server start Starting My SQL ... The server quit without updating PID file (/usr/local/var/mysql/Mnmandahalfs-Mac Book-Pro.local.pid).$ touch /usr/local/var/mysql/Manamis-Mac Book-Pro.$ mysql.server start Starting My SQL .rm: /tmp/mysql.sock: Permission denied 2017-10-02T.6NZ mysqld_safe Fatal error: Can't remove the socket file: /tmp/
[失败]rn[[email protected] data]#rnrn我的日志是rnrnrn[img=https://net/upload/201404/19/1397900391_197339.gif][/img]最近一直忙mysql的问题。换了一台服务器,发现mysql启动有问题,这台服务器的mysql之前有人动过。服务器系统是Mac os ,安装包用的是rpm包。我看修改过mysql安装目录。配置文件也改变了很多。我重启的时候出现了此问题。rn My SQL manager or server PID file could not be found! [FAILED]rn真不知,如何修改,两天又过去了。这是mysql的配置文件my.cnf部分配置:rn[mysqld]rn#basedir=/usr/local/mysqlrn#datadir=/usr/local/mysql/datarnuser=mysqlrnbasedir=/usrrndatadir=/var/lib/mysqlrnsocket=/var/lib/mysql/mysql.sockrn#...............rn[mysqld_safe]rnlog-error=/var/log/mysqld.logrnpid-file=/var/run/mysqld/mysqld.pidrnrn我再贴一下mysql的启动脚本init.d/mysql文件,部分内容:rn# If you want to affect other My SQL variables, you should make your changesrn# in the /etc/my.cnf, ~/cnf or other My SQL configuration files.rnrn# If you change base dir, you must also change datadir.出现问题的可能性 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..$ sudo rm /tmp/$ /usr/local/Cellar/mysql/5.7.19/bin/mysqld_safe 2017-10-02T.6NZ mysqld_safe Logging to '/usr/local/var/mysql/Mnmandahalfs-Mac Book-Pro.local.err'.
2017-10-02T.6NZ mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql $ ps aux | grep mysql mnmandahalf 72116 0.0 0.0 2435000 1228 s004 R PM .01 grep mysql mnmandahalf 72096 0.0 2.1 2836108 177372 ??The easiest way is to remove your configuration file, and try to start the My SQL server again: Backup your My SQL configuration first.