设为首页收藏本站
切换到窄版

VPS侦探论坛

 找回密码
 注册
VPS侦探论坛»VPS侦探论坛 › 技术交流区 › LNMP一键安装包 › 军哥，Mysql启动不了 Starting MySQL... ERROR! The ser ...
返回列表 发新帖
查看: 6147|回复: 5

军哥，Mysql启动不了 Starting MySQL... ERROR! The server quit without updating PID file

[复制链接]
2966980
发表于 2016-3-16 18:00:05 | 显示全部楼层 |阅读模式

启动mysql时提示 Starting MySQL... ERROR! The server quit without updating PID file (/usr/local/mysql/var/VM_75_73_centos.pid).

vim /usr/local/mysql/var/VM_75_73_centos.err 得到以下内容，请问要怎么解决？
  1. 151111 11:40:05 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
  2. 2015-11-11 11:40:06 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  3. 2015-11-11 11:40:06 27696 [Note] Plugin 'FEDERATED' is disabled.
  4. 2015-11-11 11:40:06 7ff165c1d780 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
  5. 2015-11-11 11:40:06 27696 [Note] InnoDB: Using atomics to ref count buffer pool pages
  6. 2015-11-11 11:40:06 27696 [Note] InnoDB: The InnoDB memory heap is disabled
  7. 2015-11-11 11:40:06 27696 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  8. 2015-11-11 11:40:06 27696 [Note] InnoDB: Memory barrier is not used
  9. 2015-11-11 11:40:06 27696 [Note] InnoDB: Compressed tables use zlib 1.2.7
  10. 2015-11-11 11:40:06 27696 [Note] InnoDB: Not using CPU crc32 instructions
  11. 2015-11-11 11:40:06 27696 [Note] InnoDB: Initializing buffer pool, size = 16.0M
  12. 2015-11-11 11:40:06 27696 [Note] InnoDB: Completed initialization of buffer pool
  13. 2015-11-11 11:40:06 27696 [Note] InnoDB: Highest supported file format is Barracuda.
  14. 2015-11-11 11:40:06 27696 [Note] InnoDB: 128 rollback segment(s) are active.
  15. 2015-11-11 11:40:06 27696 [Note] InnoDB: Waiting for purge to start
  16. 2015-11-11 11:40:06 27696 [Note] InnoDB: 5.6.23 started; log sequence number 1625994
  17. 2015-11-11 11:40:06 27696 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: e63c77f9-8825-11e5-8553-5254001ea1a3.
  18. 2015-11-11 11:40:06 27696 [Note] Server hostname (bind-address): '*'; port: 3306
  19. 2015-11-11 11:40:06 27696 [Note] IPv6 is available.
  20. 2015-11-11 11:40:06 27696 [Note]   - '::' resolves to '::';
  21. 2015-11-11 11:40:06 27696 [Note] Server socket created on IP: '::'.
  22. 2015-11-11 11:40:06 27696 [Note] Event Scheduler: Loaded 0 events
  23. 2015-11-11 11:40:06 27696 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
  24. Version: '5.6.23-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
  25. 2015-11-11 11:40:06 27696 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

  27. 2015-11-11 11:40:06 27696 [Note] Giving 0 client threads a chance to die gracefully
  28. 2015-11-11 11:40:06 27696 [Note] Event Scheduler: Purging the queue. 0 events
  29. 2015-11-11 11:40:06 27696 [Note] Shutting down slave threads
  30. 2015-11-11 11:40:06 27696 [Note] Forcefully disconnecting 0 remaining clients
  31. 2015-11-11 11:40:06 27696 [Note] Binlog end
  32. 2015-11-11 11:40:06 27696 [Note] Shutting down plugin 'partition'
  33. 2015-11-11 11:40:06 27696 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
  34. 2015-11-11 11:40:06 27696 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
  35. 2015-11-11 11:40:06 27696 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  36. 2015-11-11 11:40:06 27696 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
  37. 2015-11-11 11:40:06 27696 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
  38. 2015-11-11 11:40:06 27696 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  39. 2015-11-11 11:40:06 27696 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  40. 2015-11-11 11:40:06 27696 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  41. 2015-11-11 11:40:06 27696 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  42. 2015-11-11 11:40:06 27696 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  43. 2015-11-11 11:40:06 27696 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
  44. 2015-11-11 11:40:06 27696 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
  45. 2015-11-11 11:40:06 27696 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
  46. 2015-11-11 11:40:06 27696 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
  47. 2015-11-11 11:40:06 27696 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  48. 2015-11-11 11:40:06 27696 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
  49. 2015-11-11 11:40:06 27696 [Note] Shutting down plugin 'INNODB_METRICS'
  50. 2015-11-11 11:40:06 27696 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
  51. 2015-11-11 11:40:06 27696 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
  52. 2015-11-11 11:40:06 27696 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
复制代码



[client]
port        = 3306
socket      = /tmp/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port        = 3306
socket      = /tmp/mysql.sock
datadir = /usr/local/mysql/var

[ 本帖最后由 2966980 于 2016-3-16 18:15 编辑 ]
美国VPS推荐： 遨游主机、Linode、LOCVPS、主机云、搬瓦工、80VPS、Vultr等美国VPS主机。中国VPS推荐： 阿里云、腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
回复

举报

licess
发表于 2016-3-16 19:52:15 | 显示全部楼层


日志是以前的不是现在的，直接上传完整文件
Linux下Nginx+MySQL+PHP自动安装工具：https://lnmp.org
回复 支持 反对

举报

kcersing
发表于 2016-3-18 08:55:21 | 显示全部楼层

我也碰到这个错误了。
美国VPS推荐： 遨游主机、Linode、LOCVPS、主机云、搬瓦工、80VPS、Vultr等美国VPS主机。中国VPS推荐： 阿里云、腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
回复 支持 反对

举报

licess
发表于 2016-3-18 12:52:57 | 显示全部楼层

回复 3# 的帖子




日志日志日志
Linux下Nginx+MySQL+PHP自动安装工具：https://lnmp.org
回复 支持 反对

举报

明月出天山
发表于 2016-4-5 21:36:50 | 显示全部楼层

160405 20:32:20 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
2016-04-05 20:32:20 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-04-05 20:32:20 8151 [Warning] ignore-builtin-innodb is ignored and will be removed in future releases.
2016-04-05 20:32:20 8151 [Warning] The option innodb (skip-innodb) is deprecated and will be removed in a future release
2016-04-05 20:32:20 8151 [Warning] The option innodb (skip-innodb) is deprecated and will be removed in a future release
2016-04-05 20:32:20 8151 [Warning] Using unique option prefix innodb-locks instead of innodb-locks-unsafe-for-binlog is deprecated and will be removed in a future release. Please use the full name instead.
2016-04-05 20:32:20 8151 [Warning] Using unique option prefix innodb-cmp instead of innodb-cmp-per-index-enabled is deprecated and will be removed in a future release. Please use the full name instead.
2016-04-05 20:32:20 8151 [Warning] Using unique option prefix innodb-cmp-per-index instead of innodb-cmp-per-index-enabled is deprecated and will be removed in a future release. Please use the full name instead.
2016-04-05 20:32:20 8151 [Note] Plugin 'InnoDB' is disabled.
2016-04-05 20:32:20 8151 [Note] Plugin 'INNODB_TRX' is disabled.
2016-04-05 20:32:20 8151 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled.
2016-04-05 20:32:20 8151 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
2016-04-05 20:32:20 8151 [Note] Plugin 'INNODB_CMPMEM' is disabled.
2016-04-05 20:32:20 8151 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
2016-04-05 20:32:20 8151 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
2016-04-05 20:32:20 8151 [Note] Plugin 'INNODB_BUFFER_PAGE' is disabled.
2016-04-05 20:32:20 8151 [Note] Plugin 'INNODB_BUFFER_PAGE_LRU' is disabled.
2016-04-05 20:32:20 8151 [Note] Plugin 'INNODB_BUFFER_POOL_STATS' is disabled.
2016-04-05 20:32:20 8151 [Note] Plugin 'INNODB_METRICS' is disabled.
2016-04-05 20:32:20 8151 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
2016-04-05 20:32:20 8151 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
2016-04-05 20:32:20 8151 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
2016-04-05 20:32:20 8151 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
2016-04-05 20:32:20 8151 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
2016-04-05 20:32:20 8151 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
2016-04-05 20:32:20 8151 [Note] Plugin 'INNODB_SYS_TABLES' is disabled.
2016-04-05 20:32:20 8151 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
2016-04-05 20:32:20 8151 [Note] Plugin 'INNODB_SYS_INDEXES' is disabled.
2016-04-05 20:32:20 8151 [Note] Plugin 'INNODB_SYS_COLUMNS' is disabled.
2016-04-05 20:32:20 8151 [Note] Plugin 'INNODB_SYS_FIELDS' is disabled.
2016-04-05 20:32:20 8151 [Note] Plugin 'INNODB_SYS_FOREIGN' is disabled.
2016-04-05 20:32:20 8151 [Note] Plugin 'INNODB_SYS_FOREIGN_COLS' is disabled.
2016-04-05 20:32:20 8151 [Note] Plugin 'FEDERATED' is disabled.
2016-04-05 20:32:20 8151 [Warning] /usr/local/mysql/bin/mysqld: unknown variable 'loose-innodb-ft-inserted=0'
2016-04-05 20:32:21 8151 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 71239c64-fb2a-11e5-b355-deaab89eecc6.
2016-04-05 20:32:21 8151 [Note] Server hostname (bind-address): '*'; port: 3306
2016-04-05 20:32:21 8151 [Note] IPv6 is available.
2016-04-05 20:32:21 8151 [Note]   - '::' resolves to '::';
2016-04-05 20:32:21 8151 [Note] Server socket created on IP: '::'.
2016-04-05 20:32:21 8151 [Note] Event Scheduler: Loaded 0 events
2016-04-05 20:32:21 8151 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.6.23-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
2016-04-05 20:32:22 8151 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

2016-04-05 20:32:22 8151 [Note] Giving 0 client threads a chance to die gracefully
2016-04-05 20:32:22 8151 [Note] Event Scheduler: Purging the queue. 0 events
2016-04-05 20:32:22 8151 [Note] Shutting down slave threads
2016-04-05 20:32:22 8151 [Note] Forcefully disconnecting 0 remaining clients
2016-04-05 20:32:22 8151 [Note] Binlog end
2016-04-05 20:32:22 8151 [Note] Shutting down plugin 'partition'
2016-04-05 20:32:22 8151 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-04-05 20:32:22 8151 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-04-05 20:32:22 8151 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-04-05 20:32:22 8151 [Note] Shutting down plugin 'INNODB_CMP'
2016-04-05 20:32:22 8151 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-04-05 20:32:22 8151 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-04-05 20:32:22 8151 [Note] Shutting down plugin 'ARCHIVE'
2016-04-05 20:32:22 8151 [Note] Shutting down plugin 'BLACKHOLE'
2016-04-05 20:32:22 8151 [Note] Shutting down plugin 'MyISAM'
2016-04-05 20:32:22 8151 [Note] Shutting down plugin 'MRG_MYISAM'
2016-04-05 20:32:22 8151 [Note] Shutting down plugin 'CSV'
2016-04-05 20:32:22 8151 [Note] Shutting down plugin 'MEMORY'
2016-04-05 20:32:22 8151 [Note] Shutting down plugin 'sha256_password'
2016-04-05 20:32:22 8151 [Note] Shutting down plugin 'mysql_old_password'
2016-04-05 20:32:22 8151 [Note] Shutting down plugin 'mysql_native_password'
2016-04-05 20:32:22 8151 [Note] Shutting down plugin 'binlog'
2016-04-05 20:32:22 8151 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

160405 20:32:22 mysqld_safe mysqld from pid file /usr/local/mysql/var/black5.pid ended
160405 20:32:23 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
160405 20:32:25 mysqld_safe mysqld from pid file /usr/local/mysql/var/black5.pid ended
160405 20:39:41 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
160405 20:39:42 mysqld_safe mysqld from pid file /usr/local/mysql/var/black5.pid ended
160405 21:09:15 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
160405 21:09:17 mysqld_safe mysqld from pid file /usr/local/mysql/var/black5.pid ended
160405 21:21:01 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
160405 21:21:03 mysqld_safe mysqld from pid file /usr/local/mysql/var/black5.pid ended
160405 21:22:37 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
160405 21:22:39 mysqld_safe mysqld from pid file /usr/local/mysql/var/black5.pid ended
160405 21:24:24 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
160405 21:24:26 mysqld_safe mysqld from pid file /usr/local/mysql/var/black5.pid ended
160405 21:24:58 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
160405 21:25:00 mysqld_safe mysqld from pid file /usr/local/mysql/var/black5.pid ended
160405 21:25:32 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
160405 21:25:34 mysqld_safe mysqld from pid file /usr/local/mysql/var/black5.pid ended


刚安装的lnmp1.2，mysql无法启动

军哥运维代购：http://shop63846532.taobao.com/
回复 支持 反对

举报

licess
发表于 2016-4-6 12:57:50 | 显示全部楼层

回复 5# 的帖子


里面没有有用的信息，上传安装日志看一下
回复 支持 反对

举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|VPS侦探 ( 鲁ICP备16040043号-1 )

GMT+8, 2024-11-17 19:00 , Processed in 0.026989 second(s), 16 queries .

Powered by Discuz! X3.4

© 2001-2023 Discuz! Team.

快速回复 返回顶部 返回列表