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

旧日歌 发表于 2017-10-26 10:39:53

171026 10:13:37 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
171026 10:13:37 You need to use --log-bin to make --binlog-format work.
171026 10:13:37 Plugin 'InnoDB' is disabled.
/usr/local/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
171026 10:13:37 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
171026 10:13:37 Server hostname (bind-address): '0.0.0.0'; port: 3306
171026 10:13:37 - '0.0.0.0' resolves to '0.0.0.0';
171026 10:13:37 Server socket created on IP: '0.0.0.0'.
171026 10:13:37 /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/var/cloud.pid' (Errcode: 13)
171026 10:13:37 Can't start server: can't create PID file: Permission denied
171026 10:13:37 mysqld_safe mysqld from pid file /usr/local/mysql/var/cloud.pid ended
171026 10:14:04 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
171026 10:14:04 You need to use --log-bin to make --binlog-format work.
171026 10:14:04 Plugin 'InnoDB' is disabled.
/usr/local/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
171026 10:14:04 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
171026 10:14:04 Server hostname (bind-address): '0.0.0.0'; port: 3306
171026 10:14:04 - '0.0.0.0' resolves to '0.0.0.0';
171026 10:14:04 Server socket created on IP: '0.0.0.0'.
171026 10:14:04 /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/var/cloud.pid' (Errcode: 13)
171026 10:14:04 Can't start server: can't create PID file: Permission denied
171026 10:14:04 mysqld_safe mysqld from pid file /usr/local/mysql/var/cloud.pid ended
171026 10:18:22 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
171026 10:18:22 You need to use --log-bin to make --binlog-format work.
171026 10:18:22 Plugin 'InnoDB' is disabled.
/usr/local/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
171026 10:18:22 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
171026 10:18:22 Server hostname (bind-address): '0.0.0.0'; port: 3306
171026 10:18:22 - '0.0.0.0' resolves to '0.0.0.0';
171026 10:18:22 Server socket created on IP: '0.0.0.0'.
171026 10:18:22 /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/var/cloud.pid' (Errcode: 13)
171026 10:18:22 Can't start server: can't create PID file: Permission denied
171026 10:18:22 mysqld_safe mysqld from pid file /usr/local/mysql/var/cloud.pid ended
171026 10:20:30 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
171026 10:20:30 You need to use --log-bin to make --binlog-format work.
171026 10:20:30 Plugin 'InnoDB' is disabled.
/usr/local/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
171026 10:20:30 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
171026 10:20:30 Server hostname (bind-address): '0.0.0.0'; port: 3306
171026 10:20:30 - '0.0.0.0' resolves to '0.0.0.0';
171026 10:20:30 Server socket created on IP: '0.0.0.0'.
171026 10:20:30 /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/var/cloud.pid' (Errcode: 13)
171026 10:20:30 Can't start server: can't create PID file: Permission denied
171026 10:20:30 mysqld_safe mysqld from pid file /usr/local/mysql/var/cloud.pid ended
171026 10:20:58 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
171026 10:20:58 You need to use --log-bin to make --binlog-format work.
171026 10:20:58 Plugin 'InnoDB' is disabled.
/usr/local/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
171026 10:20:58 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
171026 10:20:58 Server hostname (bind-address): '0.0.0.0'; port: 3306
171026 10:20:58 - '0.0.0.0' resolves to '0.0.0.0';
171026 10:20:58 Server socket created on IP: '0.0.0.0'.
171026 10:20:58 /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/var/cloud.pid' (Errcode: 13)
171026 10:20:58 Can't start server: can't create PID file: Permission denied
171026 10:20:58 mysqld_safe mysqld from pid file /usr/local/mysql/var/cloud.pid ended
171026 10:28:18 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
171026 10:28:19 You need to use --log-bin to make --binlog-format work.
171026 10:28:19 Plugin 'InnoDB' is disabled.
/usr/local/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
171026 10:28:19 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
171026 10:28:19 Server hostname (bind-address): '0.0.0.0'; port: 3306
171026 10:28:19 - '0.0.0.0' resolves to '0.0.0.0';
171026 10:28:19 Server socket created on IP: '0.0.0.0'.
171026 10:28:19 /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/var/cloud.pid' (Errcode: 13)
171026 10:28:19 Can't start server: can't create PID file: Permission denied
171026 10:28:19 mysqld_safe mysqld from pid file /usr/local/mysql/var/cloud.pid ended
171026 10:31:01 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
171026 10:31:01 You need to use --log-bin to make --binlog-format work.
171026 10:31:01 Plugin 'InnoDB' is disabled.
/usr/local/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
171026 10:31:01 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
171026 10:31:01 Server hostname (bind-address): '0.0.0.0'; port: 3306
171026 10:31:01 - '0.0.0.0' resolves to '0.0.0.0';
171026 10:31:01 Server socket created on IP: '0.0.0.0'.
171026 10:31:01 /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/var/cloud.pid' (Errcode: 13)
171026 10:31:01 Can't start server: can't create PID file: Permission denied
171026 10:31:01 mysqld_safe mysqld from pid file /usr/local/mysql/var/cloud.pid ended

旧日歌 发表于 2017-10-26 10:41:59

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

# service mysql start
Starting MySQL. ERROR! The server quit without updating PID file (/usr/local/mysql/var/cloud.pid).

licess 发表于 2017-10-26 13:53:49

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

腾空间动过mysql的文件吗

旧日歌 发表于 2017-10-26 15:48:10

回复 3# 的帖子

没动过mysql的任何文件
刚重做了系统，重新安装了1.4
安装进行了一部分了，就提示
Connection closed by foreign host
连续两次都这样，怎么回事儿？

旧日歌 发表于 2017-10-26 17:53:22

Starting php-fpm ERROR: cannot get uid for user 'www'
ERROR: FPM initialization failed
failed

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

旧日歌 发表于 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: getpwnam("www") failed in /usr/local/nginx/conf/nginx.conf:1
failed
Starting MySQL... SUCCESS!
Starting php-fpm ERROR: cannot get uid for user 'www'
ERROR: FPM initialization failed
failed

licess 发表于 2017-10-27 10:18:01

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

可能www用户被删除了

旧日歌 发表于 2017-10-27 11:34:02

原帖由 licess 于 2017-10-27 10:18 发表 http://bbs.vpser.net/images/common/back.gif

可能www用户被删除了
www用户被删除了怎么解决，军哥。安装后就这样，自己创建么？

licess 发表于 2017-10-28 09:37:20

回复 8# 的帖子

用脚本安装都是自动添加的，如果是新装的话上传安装日志看一下

页: [1]

VPS侦探论坛's Archiver