/usr/local/mysql/var不小心删除了/usr/local/mysql/var下面的一个叫vps457988 pid类似的文件

lilo520

/usr/local/mysql/var不小心删除了/usr/local/mysql/var下面的一个叫vps457988 pid类似的文件
现在
Reload LNMP...
Reload Nginx configure...
the configuration file /usr/local/nginx/conf/nginx.conf syntax is ok
configuration file /usr/local/nginx/conf/nginx.conf test is successful
Nginx program is reloding!
ERROR! MySQL manager or server PID file could not be found!
Starting MySQL. ERROR! Manager of pid-file quit without updating file.
Shutting down php_fpm . done
Starting php_fpm  done
-bash-3.2#
-bash-3.2# service mysqld restart
mysqld: unrecognized service
-bash-3.2# service mysql restart
ERROR! MySQL manager or server PID file could not be found!
Starting MySQL. ERROR! Manager of pid-file quit without updating file.
-bash-3.2#
请问怎么办？！！！！

lilo520

我重启VPS之后，执行
-bash-3.2# service mysql status
SUCCESS! MySQL running (1225)
mysql的端口不是3306了   现在
Reload LNMP...
Reload Nginx configure...
the configuration file /usr/local/nginx/conf/nginx.conf syntax is ok
configuration file /usr/local/nginx/conf/nginx.conf test is successful
Nginx program is reloding!
Shutting down MySQL. SUCCESS!
Starting MySQL. SUCCESS!
Shutting down php_fpm . done
Starting php_fpm  done
-bash-3.2#
-bash-3.2#

lilo520

但是现在发现一个问题   重启前我安装了denyhosts，结果现在怎么都putty不了了，只能VPN，怎么回事？怎么办？  求高手解决！

lilo520

重启mysql之后
多了两个文件vps457948.err和vps457948.pid
好像刚刚我就是因为删除了vps457948.pid这个文件才这样的（我在删除mysql日志的时候以为这个也是日志……
现在vps457948.err里面的内容
110325 20:10:45 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
110325 20:10:45 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
110325 20:10:45 [ERROR] Do you already have another mysqld server running on port: 3306 ?
110325 20:10:45 [ERROR] Aborting

110325 20:10:45 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

110325 20:10:45 mysqld_safe mysqld from pid file /usr/local/mysql/var/vps457948.pid ended
110325 20:13:15 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
110325 20:13:15 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
110325 20:13:15 [ERROR] Do you already have another mysqld server running on port: 3306 ?
110325 20:13:15 [ERROR] Aborting

110325 20:13:15 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

110325 20:13:15 mysqld_safe mysqld from pid file /usr/local/mysql/var/vps457948.pid ended
110325 20:25:16 mysqld_safe mysqld from pid file /usr/local/mysql/var/vps457948.pid ended
110325 20:25:55 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
110325 20:25:55 [Note] Event Scheduler: Loaded 0 events
110325 20:25:55 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
110325 20:33:33 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

110325 20:33:33 [Note] Event Scheduler: Purging the queue. 0 events
110325 20:33:33 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

110325 20:33:33 mysqld_safe mysqld from pid file /usr/local/mysql/var/vps457948.pid ended
110325 20:33:34 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
110325 20:33:34 [Note] Event Scheduler: Loaded 0 events
110325 20:33:34 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

vps457948.pid里面的内容2140

lilo520

现在查看了一下端口    好像又是3306了    很奇怪     虽然问题没了，但是心结没打开   高手解答！！:)
-bash-3.2# lsof -i:3306
COMMAND  PID  USER   FD   TYPE DEVICE SIZE NODE NAME
mysqld  2140 mysql    3u  IPv4   6173       TCP *:mysql (LISTEN)

licess

vps457988 pid 是当前mysql的进程ID的保存文件，误删没事，重启会自动生成。

lilo520

嗯  现在已经好了  多谢