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

VPS侦探论坛

 找回密码
 注册
VPS侦探论坛»VPS侦探论坛 › 技术交流区 › LNMP一键安装包 › [root@cloud var]# service mysql start Starting MySQL ...
返回列表 发新帖
查看: 2883|回复: 8

[root@cloud var]# service mysql start Starting MySQL. ERROR! The server quit wit

[复制链接]
旧日歌
发表于 2017-10-26 10:39:53 | 显示全部楼层 |阅读模式

  1. 171026 10:13:37 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
  2. 171026 10:13:37 [Warning] You need to use --log-bin to make --binlog-format work.
  3. 171026 10:13:37 [Note] Plugin 'InnoDB' is disabled.
  4. /usr/local/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
  5. 171026 10:13:37 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
  6. 171026 10:13:37 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
  7. 171026 10:13:37 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
  8. 171026 10:13:37 [Note] Server socket created on IP: '0.0.0.0'.
  9. 171026 10:13:37 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/var/cloud.pid' (Errcode: 13)
  10. 171026 10:13:37 [ERROR] Can't start server: can't create PID file: Permission denied
  11. 171026 10:13:37 mysqld_safe mysqld from pid file /usr/local/mysql/var/cloud.pid ended
  12. 171026 10:14:04 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
  13. 171026 10:14:04 [Warning] You need to use --log-bin to make --binlog-format work.
  14. 171026 10:14:04 [Note] Plugin 'InnoDB' is disabled.
  15. /usr/local/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
  16. 171026 10:14:04 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
  17. 171026 10:14:04 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
  18. 171026 10:14:04 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
  19. 171026 10:14:04 [Note] Server socket created on IP: '0.0.0.0'.
  20. 171026 10:14:04 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/var/cloud.pid' (Errcode: 13)
  21. 171026 10:14:04 [ERROR] Can't start server: can't create PID file: Permission denied
  22. 171026 10:14:04 mysqld_safe mysqld from pid file /usr/local/mysql/var/cloud.pid ended
  23. 171026 10:18:22 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
  24. 171026 10:18:22 [Warning] You need to use --log-bin to make --binlog-format work.
  25. 171026 10:18:22 [Note] Plugin 'InnoDB' is disabled.
  26. /usr/local/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
  27. 171026 10:18:22 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
  28. 171026 10:18:22 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
  29. 171026 10:18:22 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
  30. 171026 10:18:22 [Note] Server socket created on IP: '0.0.0.0'.
  31. 171026 10:18:22 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/var/cloud.pid' (Errcode: 13)
  32. 171026 10:18:22 [ERROR] Can't start server: can't create PID file: Permission denied
  33. 171026 10:18:22 mysqld_safe mysqld from pid file /usr/local/mysql/var/cloud.pid ended
  34. 171026 10:20:30 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
  35. 171026 10:20:30 [Warning] You need to use --log-bin to make --binlog-format work.
  36. 171026 10:20:30 [Note] Plugin 'InnoDB' is disabled.
  37. /usr/local/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
  38. 171026 10:20:30 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
  39. 171026 10:20:30 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
  40. 171026 10:20:30 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
  41. 171026 10:20:30 [Note] Server socket created on IP: '0.0.0.0'.
  42. 171026 10:20:30 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/var/cloud.pid' (Errcode: 13)
  43. 171026 10:20:30 [ERROR] Can't start server: can't create PID file: Permission denied
  44. 171026 10:20:30 mysqld_safe mysqld from pid file /usr/local/mysql/var/cloud.pid ended
  45. 171026 10:20:58 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
  46. 171026 10:20:58 [Warning] You need to use --log-bin to make --binlog-format work.
  47. 171026 10:20:58 [Note] Plugin 'InnoDB' is disabled.
  48. /usr/local/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
  49. 171026 10:20:58 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
  50. 171026 10:20:58 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
  51. 171026 10:20:58 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
  52. 171026 10:20:58 [Note] Server socket created on IP: '0.0.0.0'.
  53. 171026 10:20:58 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/var/cloud.pid' (Errcode: 13)
  54. 171026 10:20:58 [ERROR] Can't start server: can't create PID file: Permission denied
  55. 171026 10:20:58 mysqld_safe mysqld from pid file /usr/local/mysql/var/cloud.pid ended
  56. 171026 10:28:18 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
  57. 171026 10:28:19 [Warning] You need to use --log-bin to make --binlog-format work.
  58. 171026 10:28:19 [Note] Plugin 'InnoDB' is disabled.
  59. /usr/local/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
  60. 171026 10:28:19 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
  61. 171026 10:28:19 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
  62. 171026 10:28:19 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
  63. 171026 10:28:19 [Note] Server socket created on IP: '0.0.0.0'.
  64. 171026 10:28:19 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/var/cloud.pid' (Errcode: 13)
  65. 171026 10:28:19 [ERROR] Can't start server: can't create PID file: Permission denied
  66. 171026 10:28:19 mysqld_safe mysqld from pid file /usr/local/mysql/var/cloud.pid ended
  67. 171026 10:31:01 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
  68. 171026 10:31:01 [Warning] You need to use --log-bin to make --binlog-format work.
  69. 171026 10:31:01 [Note] Plugin 'InnoDB' is disabled.
  70. /usr/local/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
  71. 171026 10:31:01 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
  72. 171026 10:31:01 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
  73. 171026 10:31:01 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
  74. 171026 10:31:01 [Note] Server socket created on IP: '0.0.0.0'.
  75. 171026 10:31:01 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/var/cloud.pid' (Errcode: 13)
  76. 171026 10:31:01 [ERROR] Can't start server: can't create PID file: Permission denied
  77. 171026 10:31:01 mysqld_safe mysqld from pid file /usr/local/mysql/var/cloud.pid ended
复制代码
美国VPS推荐： 遨游主机、Linode、LOCVPS、主机云、搬瓦工、80VPS、Vultr等美国VPS主机。中国VPS推荐： 阿里云、腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
回复

举报

旧日歌
 楼主| 发表于 2017-10-26 10:41:59 | 显示全部楼层


你好军哥，突然发现数据库连不上了，然后手动启动mysql，就提示这个错误
日志在上面，试了网上的很多方法，都解决不了。
当时发现，磁盘满了，腾出一部分后，就一直这样了
[root@cloud var]# service mysql stop
ERROR! MySQL server PID file could not be found!

[root@cloud var]# service mysql start
Starting MySQL. ERROR! The server quit without updating PID file (/usr/local/mysql/var/cloud.pid).
Linux下Nginx+MySQL+PHP自动安装工具：https://lnmp.org
回复 支持 反对

举报

licess
发表于 2017-10-26 13:53:49 | 显示全部楼层

检查 /usr/local/mysql/var/ 数据库目录权限
可以chown mysql:mysql -R /usr/local/mysql/var/ 后再重启看一下

腾空间动过mysql的文件吗
美国VPS推荐： 遨游主机、Linode、LOCVPS、主机云、搬瓦工、80VPS、Vultr等美国VPS主机。中国VPS推荐： 阿里云、腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
回复 支持 反对

举报

旧日歌
 楼主| 发表于 2017-10-26 15:48:10 | 显示全部楼层

回复 3# 的帖子




没动过mysql的任何文件
刚重做了系统，重新安装了1.4
安装进行了一部分了，就提示
Connection closed by foreign host
连续两次都这样，怎么回事儿？
Linux下Nginx+MySQL+PHP自动安装工具：https://lnmp.org
回复 支持 反对

举报

旧日歌
 楼主| 发表于 2017-10-26 17:53:22 | 显示全部楼层

Starting php-fpm [26-Oct-2017 17:52:28] ERROR: [pool www] cannot get uid for user 'www'
[26-Oct-2017 17:52:28] ERROR: FPM initialization failed
failed

安装完了，现在又报错。。。

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

举报

旧日歌
 楼主| 发表于 2017-10-26 17:53:39 | 显示全部楼层

Stoping LNMP...
Stoping nginx... nginx is not running.
ERROR! MySQL server PID file could not be found!
Gracefully shutting down php-fpm warning, no pid file found - php-fpm is not running ?
Starting LNMP...
Starting nginx... nginx: [emerg] getpwnam("www") failed in /usr/local/nginx/conf/nginx.conf:1
failed
Starting MySQL... SUCCESS!
Starting php-fpm [26-Oct-2017 17:52:28] ERROR: [pool www] cannot get uid for user 'www'
[26-Oct-2017 17:52:28] ERROR: FPM initialization failed
failed
回复 支持 反对

举报

licess
发表于 2017-10-27 10:18:01 | 显示全部楼层

Connection closed by foreign host  可能是网络原因

可能www用户被删除了
美国VPS推荐： 遨游主机、Linode、LOCVPS、主机云、搬瓦工、80VPS、Vultr等美国VPS主机。中国VPS推荐： 阿里云、腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
回复 支持 反对

举报

旧日歌
 楼主| 发表于 2017-10-27 11:34:02 | 显示全部楼层

原帖由 licess 于 2017-10-27 10:18 发表


可能www用户被删除了

www用户被删除了怎么解决，军哥。安装后就这样，自己创建么？
Linux下Nginx+MySQL+PHP自动安装工具：https://lnmp.org
回复 支持 反对

举报

licess
发表于 2017-10-28 09:37:20 | 显示全部楼层

回复 8# 的帖子



用脚本安装都是自动添加的，如果是新装的话上传安装日志看一下
美国VPS推荐： 遨游主机、Linode、LOCVPS、主机云、搬瓦工、80VPS、Vultr等美国VPS主机。中国VPS推荐： 阿里云、腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
回复 支持 反对

举报

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

本版积分规则

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

GMT+8, 2024-11-18 10:30 , Processed in 0.030242 second(s), 16 queries .

Powered by Discuz! X3.4

© 2001-2023 Discuz! Team.

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