打印

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

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

复制内容到剪贴板
代码:
171026 10:13:37 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
171026 10:13:37 [Warning] You need to use --log-bin to make --binlog-format work.
171026 10:13:37 [Note] Plugin 'InnoDB' is disabled.
/usr/local/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
171026 10:13:37 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
171026 10:13:37 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
171026 10:13:37 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
171026 10:13:37 [Note] Server socket created on IP: '0.0.0.0'.
171026 10:13:37 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/var/cloud.pid' (Errcode: 13)
171026 10:13:37 [ERROR] 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 [Warning] You need to use --log-bin to make --binlog-format work.
171026 10:14:04 [Note] Plugin 'InnoDB' is disabled.
/usr/local/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
171026 10:14:04 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
171026 10:14:04 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
171026 10:14:04 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
171026 10:14:04 [Note] Server socket created on IP: '0.0.0.0'.
171026 10:14:04 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/var/cloud.pid' (Errcode: 13)
171026 10:14:04 [ERROR] 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 [Warning] You need to use --log-bin to make --binlog-format work.
171026 10:18:22 [Note] Plugin 'InnoDB' is disabled.
/usr/local/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
171026 10:18:22 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
171026 10:18:22 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
171026 10:18:22 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
171026 10:18:22 [Note] Server socket created on IP: '0.0.0.0'.
171026 10:18:22 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/var/cloud.pid' (Errcode: 13)
171026 10:18:22 [ERROR] 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 [Warning] You need to use --log-bin to make --binlog-format work.
171026 10:20:30 [Note] Plugin 'InnoDB' is disabled.
/usr/local/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
171026 10:20:30 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
171026 10:20:30 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
171026 10:20:30 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
171026 10:20:30 [Note] Server socket created on IP: '0.0.0.0'.
171026 10:20:30 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/var/cloud.pid' (Errcode: 13)
171026 10:20:30 [ERROR] 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 [Warning] You need to use --log-bin to make --binlog-format work.
171026 10:20:58 [Note] Plugin 'InnoDB' is disabled.
/usr/local/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
171026 10:20:58 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
171026 10:20:58 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
171026 10:20:58 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
171026 10:20:58 [Note] Server socket created on IP: '0.0.0.0'.
171026 10:20:58 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/var/cloud.pid' (Errcode: 13)
171026 10:20:58 [ERROR] 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 [Warning] You need to use --log-bin to make --binlog-format work.
171026 10:28:19 [Note] Plugin 'InnoDB' is disabled.
/usr/local/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
171026 10:28:19 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
171026 10:28:19 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
171026 10:28:19 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
171026 10:28:19 [Note] Server socket created on IP: '0.0.0.0'.
171026 10:28:19 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/var/cloud.pid' (Errcode: 13)
171026 10:28:19 [ERROR] 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 [Warning] You need to use --log-bin to make --binlog-format work.
171026 10:31:01 [Note] Plugin 'InnoDB' is disabled.
/usr/local/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
171026 10:31:01 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
171026 10:31:01 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
171026 10:31:01 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
171026 10:31:01 [Note] Server socket created on IP: '0.0.0.0'.
171026 10:31:01 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/var/cloud.pid' (Errcode: 13)
171026 10:31:01 [ERROR] 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

TOP

你好军哥,突然发现数据库连不上了,然后手动启动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).

TOP

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

腾空间动过mysql的文件吗

TOP

回复 3# 的帖子

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

TOP

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

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

TOP

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

TOP

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

可能www用户被删除了

TOP

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


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

TOP

回复 8# 的帖子

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

TOP