Pid file quit without updating fi

rn网上很多都说注释掉:/etc/my.cnf里面的skip-federatedrn但是在/etc/里面没有skip-federatedrnrn在phpmyadmin下显示了Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly.rnrn然后我去启动mysql 显示:Starting My SQL. Manager of pid-file quit without updating file.rn这该怎么解决啊。rnrn我配置的nginx。纠结了一个月的启动mysql的问题,今天终于得到解决,也搞清楚了问题的原因出在哪里。 [email protected]]# /etc/init.d/mysqld start Starting My SQL SUCCESS![[email protected]]# Logging to '/data/mysql/file.err'. rm: cannot remove ‘/data/mysql/file.pid’: Is a di110707 Inno DB: Initializing buffer pool, size = 128.0Mrn110707 Inno DB: Completed initialization of buffer poolrn110707 Inno DB: highest supported file format is Barracuda.rn110707 Inno DB: 1.1.4 started; log sequence number 1617759rn110707 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/data/hqdb01.pid' (Errcode: 13)rn110707 [ERROR] Can't start server: can't create PID file: Permission deniedrn110707 mysqld_safe mysqld from pid file /usr/local/mysql/data/hqdb01.pid endedrn[[email protected] data]#rnrnrn环境 mysql5.5.8 源码安装,linux系统错误信息:rn120129 [Note] Plugin ' FEDERATED' is Inno DB: The log sequence number in ibdata files does not matchrn Inno DB: the log sequence number in the ib_logfiles!操作系统:centos5.5rn My SQL版本:5.1-53rnrn执行命令:rn# /opt/software/mysql/share/mysql/mysql.server startrn Starting My SQL.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启动不了呢? The server quit without updating PID file (/usr/local/mysql/var/My Server.pid).rnrn使用df命令查看磁盘空间:[img=https://net/upload/201708/26/1503725241_755134.png][/img]rnrn这个是因为磁盘可以占满的原因吗折腾了一下午找不出原因 下面是日志内容 求大神带飞n2017-03-30 7295 [Note] Inno DB: Using mutexes to ref count buffer pool pagesn2017-03-30 7295 [Note] Inno DB: The Inno DB memory heap is disabledn2017-03-30 7295 [Note] Inno DB: Mutexes and rw_locks use Inno DB's own implementationn2017-03-30 7295 [Note] Inno DB: Memory barrier is not usedn2017-03-30 7295 [Note] Inno DB: Compressed tables use zlib 1.2.3n2017-03-30 7295 [Note] Inno DB: Using Linux native AIOn2017-03-30 7295 [Note] Inno DB: Not using CPU crc32 instructionsn2017-03-30 7295 [Note] Inno DB: Initializing buffer pool, size = 128.0Mn2017-03-30 7295 [Note] Inno DB: Completed initialization of buffer pooln2017-03-30 7295 [Note] Inno DB: Highest supported file format is Barracuda.n2017-03-30 7295 [Note] Inno DB: 128 rollback segment(s) are active.n2017-03-30 7295 [Note] Inno DB: Waiting for purge to startn2017-03-30 7295 [Note] Inno DB: 5.6.35 started; log sequence number 1626047n2017-03-30 7295 [Note] Binlog endn2017-03-30 7295 [Note] Inno DB: FTS optimize thread exiting.n2017-03-30 7295 [Note] Inno DB: Starting shutdown...n2017-03-30 7295 [Note] Inno DB: Shutdown completed; log sequence number 1626057n2017-03-30 7318 [Note] Inno DB: Using mutexes to ref count buffer pool pagesn2017-03-30 7318 [Note] Inno DB: The Inno DB memory heap is disabledn2017-03-30 7318 [Note] Inno DB: Mutexes and rw_locks use Inno DB's own implementatio启动时:Starting My SQL....................... The server quit without updating PID file (/home/mysql/data/**.**.pid).rnrnlog日志:rn151130 mysqld_safe Starting mysqld daemon with databases from /home/mysql/datarn151130 Inno DB: The Inno DB memory heap is disabledrn151130 Inno DB: Mutexes and rw_locks use GCC atomic builtinsrn151130 Inno DB: Compressed tables use zlib 1.2.3rn151130 Inno DB: Initializing buffer pool, size = 12.0Grn Inno DB: mmap(13186891776 bytes) failed; errno 12rn151130 Inno DB: Completed initialization of buffer poolrn151130 Inno DB: Fatal error: cannot allocate memory for the buffer poolrn151130 [ERROR] Plugin ' Inno DB' init function returned error.rn151130 [ERROR] Plugin ' Inno DB' registration as a STORAGE ENGINE failed.rn151130 [ERROR] Unknown/unsupported storage engine: Inno DBrn151130 [ERROR] Abortingrn151130 [Note] /home/mysql/bin/mysqld: Shutdown completern151130 mysqld_safe mysqld from pid file /home/mysql/data/**.**ended启动My SQL数据库:rnrnrn***@***-Virtual Box:~$ sudo /etc/init.d/mysql.server startrn Starting My SQLrn[color=#FF0000]....* The server quit without updating PID file (/usr/local/mysql/data/***-Virtual Box.pid)[/color]rn该如何解决了?rnrnrn谢谢各位!rnrnrn第一次把mysql装好后,整好了,可以使用;后来想练手就全部卸载了,然后重装了一遍,就出来了这个东西。。。然后我又重新卸载,删除所有mysql的东西 rm -fr(find / -name mysql*),重装后还是这个东西 The server quit without updating PID file(/var/lib/mysql/lochost.localdomain.pid).rnrn求解答[img=https://net/Point Forum/ui/scripts/csdn/Plugin/003/onion/3.gif][/img]刚开始是运行是很正常的,突然间服务就关了。rn重新开启mysql服务,然后失败!如何rn[img=https://net/upload/201711/18/1511002062_269340.png][/img]rn该文件是存在的,执行 /etc/init.d/mysqld start 命令之后,文件会被删除,然后就包没有这文件的错误rn[img=https://net/upload/201711/18/1511002386_424768.png][/img]rnrn求助各位大神帮忙,小弟不胜感激!rn由于服务器宕机,需要重启mysql(以前不知道谁安装的mysql,没有自动重启)。执行启动命令service mysql start后mysql提示: The server quit without updating PID file(/opt/***/***.pid) 找了网上的一些方法,都不好用。 查看mysql日志发现ERROR信息: Another process with pid 346...照着这个配置的:rn[url= mysql start,报错如下:rn Starting My SQL.. The server quit without updating PID file (/var/lib/mysql/vagrant-centos65.pid).rnrnrn网上各种解决方式都试过了 mysql版本由最开始的mysql-5.6.14换成mysql-5.5.17 两个版本也分别重新编译了2次 问题依旧rnrn求助,感谢。Starting My SQL...

My SQL could not open a table created in the earlier version (Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/tmp/mysql.sock' Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/tmp/mysql.sock' mysql.columns_priv OK OK mysql.event OK OK mysql.general_log OK mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK OK mysql.ndb_binlog_index OK mysql.plugin OK OK mysql.procs_priv OK mysql.servers OK mysql.slow_log OK mysql.tables_priv OK mysql.time_zone OK mysql.time_zone_leap_second OK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_type OK OK Running 'mysql_fix_privilege_tables'..."rn firn ;;rnrn通过,上面可以看出pid_file变量不对,不知到咋修改.rn[[email protected] ~]# /etc/init.d/mysql startrn Starting My SQL..Manager of pid-file quit without updating f[失败]rnrn日志:rn101130 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/varrn/usr/local/mysql/libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13)rn101130 [ERROR] Abortingrnrn101130 [Note] /usr/local/mysql/libexec/mysqld: Shutdown completernrn101130 mysqld_safe mysqld from pid file /usr/local/mysql/var/localhost.endedrnrn怎么解决呀? The file in the mysql data folder is gone and mysql just wont behave without it.

bathroom-blowjob

The mysql.socket is no longer visible in /tmp eventhough mysql thinks it is.

出现问题的可能性 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]....

heppi-vils.ru

7 Comments

  1. Pingback:

  2. eric   •  

    Ukraine marriage dating agency in Odessa Ukrainian women look for happy love and serious relationships.

  3. eric   •  

    Sometimes you neeed a fairy girls,real sex goddess and ideal woman, so here i m sensual girl. Come and discover the pleasure and enjoy life together,and find your deepest sexual desires...

  4. eric   •  

    Men traveling on business or going for a holiday in the region find a date for their visit online.

  5. eric   •  

    Hot Manila Nights is all about a Pasay City sexden with a dominant master like that.

  6. eric   •  

    There’s nothing notable, new, or exciting when you see an old ass dude with a woman half his age dangling from his arm.

  7. eric   •  

    Sure, it occasionally happens, but my boyfriend understands that being in a codependent relationship leads to all sorts of trouble and that spending time apart sometimes is key.

  8. eric   •  

    For your convenience, we have outlined several quickly-expanding niches in the Ska Date Dating Software blog.

  9. eric   •  

    Het risico bestaat dan wel dat hier misbruik van wordt gemaakt.

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>