/usr/local/mysql/var不小心删除了/usr/local/mysql/var下面的一个叫vps457988 pid类似的文件
/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_fpmdone
-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#
请问怎么办?!!!! 我重启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_fpmdone
-bash-3.2#
-bash-3.2# 但是现在发现一个问题 重启前我安装了denyhosts,结果现在怎么都putty不了了,只能VPN,怎么回事?怎么办?求高手解决! 重启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 Can't start server: Bind on TCP/IP port: Address already in use
110325 20:10:45 Do you already have another mysqld server running on port: 3306 ?
110325 20:10:45 Aborting
110325 20:10:45 /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 Can't start server: Bind on TCP/IP port: Address already in use
110325 20:13:15 Do you already have another mysqld server running on port: 3306 ?
110325 20:13:15 Aborting
110325 20:13:15 /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 Event Scheduler: Loaded 0 events
110325 20:25:55 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48'socket: '/tmp/mysql.sock'port: 3306Source distribution
110325 20:33:33 /usr/local/mysql/libexec/mysqld: Normal shutdown
110325 20:33:33 Event Scheduler: Purging the queue. 0 events
110325 20:33:33 /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 Event Scheduler: Loaded 0 events
110325 20:33:34 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48'socket: '/tmp/mysql.sock'port: 3306Source distribution
vps457948.pid里面的内容2140 现在查看了一下端口 好像又是3306了 很奇怪 虽然问题没了,但是心结没打开 高手解答!!:)
-bash-3.2# lsof -i:3306
COMMANDPIDUSER FD TYPE DEVICE SIZE NODE NAME
mysqld2140 mysql 3uIPv4 6173 TCP *:mysql (LISTEN) vps457988 pid 是当前mysql的进程ID的保存文件,误删没事,重启会自动生成。 嗯现在已经好了多谢
页:
[1]