lovegx999 发表于 2010-10-29 12:53:03

lnmp status显示mysql失败，但实际是运行的

安装的lnmp 0.5的时候
系统内已有一个mysql
后来安装完成后 就使用lnmp的mysql
查看lnmp status 显示信息如下：

Nginx is runing!
MySQL is not running, but lock exists                      [失败]

但mysql是正常运行的
怎么把这个改为正常

licess 发表于 2010-10-29 13:57:43

回复 1# 的帖子

rm /var/lock/subsys/mysql
再 /root/lnmp restart试试

lovegx999 发表于 2010-11-1 01:23:55

毫无效果～～～～～～～～～～～～～～～～～～～～～～～～～～

licess 发表于 2010-11-1 09:20:11

回复 3# 的帖子

发/usr/local/mysql/var/主机名.err 的错误日志。

lovegx999 发表于 2010-11-1 10:03:28

101021 10:42:08 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
101021 10:42:10 '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
101021 10:42:12 Can't start server: Bind on TCP/IP port: Address already in use
101021 10:42:12 Do you already have another mysqld server running on port: 3306 ?
101021 10:42:12 Aborting

101021 10:42:12 /usr/local/mysql/libexec/mysqld: Shutdown complete

101021 10:42:12 mysqld_safe mysqld from pid file /usr/local/mysql/var/localhost.localdomain.pid ended
101029 18:33:03 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
101029 18:33:03 '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
101029 18:33:03 Can't start server: Bind on TCP/IP port: Address already in use
101029 18:33:03 Do you already have another mysqld server running on port: 3306 ?
101029 18:33:03 Aborting

101029 18:33:03 /usr/local/mysql/libexec/mysqld: Shutdown complete

101029 18:33:03 mysqld_safe mysqld from pid file /usr/local/mysql/var/localhost.localdomain.pid ended
101029 18:36:30 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
101029 18:36:30 '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
101029 18:36:30 Can't start server: Bind on TCP/IP port: Address already in use
101029 18:36:30 Do you already have another mysqld server running on port: 3306 ?
101029 18:36:30 Aborting

101029 18:36:30 /usr/local/mysql/libexec/mysqld: Shutdown complete

101029 18:36:30 mysqld_safe mysqld from pid file /usr/local/mysql/var/localhost.localdomain.pid ended
101029 18:36:34 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
101029 18:36:34 '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
101029 18:36:34 Can't start server: Bind on TCP/IP port: Address already in use
101029 18:36:34 Do you already have another mysqld server running on port: 3306 ?
101029 18:36:34 Aborting

101029 18:36:34 /usr/local/mysql/libexec/mysqld: Shutdown complete

101029 18:36:34 mysqld_safe mysqld from pid file /usr/local/mysql/var/localhost.localdomain.pid ended
101101 00:50:34 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
1011010:50:34 '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
1011010:50:34 Can't start server: Bind on TCP/IP port: Address already in use
1011010:50:34 Do you already have another mysqld server running on port: 3306 ?
1011010:50:34 Aborting

1011010:50:34 /usr/local/mysql/libexec/mysqld: Shutdown complete

101101 00:50:34 mysqld_safe mysqld from pid file /usr/local/mysql/var/localhost.localdomain.pid ended
101101 00:51:23 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
1011010:51:23 '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
1011010:51:23 Can't start server: Bind on TCP/IP port: Address already in use
1011010:51:23 Do you already have another mysqld server running on port: 3306 ?
1011010:51:23 Aborting

1011010:51:23 /usr/local/mysql/libexec/mysqld: Shutdown complete

101101 00:51:23 mysqld_safe mysqld from pid file /usr/local/mysql/var/localhost.localdomain.pid ended
101101 00:53:21 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
1011010:53:21 '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
1011010:53:21 Can't start server: Bind on TCP/IP port: Address already in use
1011010:53:21 Do you already have another mysqld server running on port: 3306 ?
1011010:53:21 Aborting

1011010:53:21 /usr/local/mysql/libexec/mysqld: Shutdown complete

101101 00:53:21 mysqld_safe mysqld from pid file /usr/local/mysql/var/localhost.localdomain.pid ended
101101 00:54:37 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
1011010:54:37 '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
1011010:54:37 Can't start server: Bind on TCP/IP port: Address already in use
1011010:54:37 Do you already have another mysqld server running on port: 3306 ?
1011010:54:37 Aborting

1011010:54:37 /usr/local/mysql/libexec/mysqld: Shutdown complete

101101 00:54:37 mysqld_safe mysqld from pid file /usr/local/mysql/var/localhost.localdomain.pid ended
101101 00:54:56 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
1011010:54:56 '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
1011010:54:56 Can't start server: Bind on TCP/IP port: Address already in use
1011010:54:56 Do you already have another mysqld server running on port: 3306 ?
1011010:54:56 Aborting

1011010:54:56 /usr/local/mysql/libexec/mysqld: Shutdown complete

101101 00:54:56 mysqld_safe mysqld from pid file /usr/local/mysql/var/localhost.localdomain.pid ended
101101 00:57:24 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
1011010:57:24 '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
1011010:57:24 Can't start server: Bind on TCP/IP port: Address already in use
1011010:57:24 Do you already have another mysqld server running on port: 3306 ?
1011010:57:24 Aborting

1011010:57:24 /usr/local/mysql/libexec/mysqld: Shutdown complete

101101 00:57:24 mysqld_safe mysqld from pid file /usr/local/mysql/var/localhost.localdomain.pid ended
101101 01:06:37 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
1011011:06:37 '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
1011011:06:37 Can't start server: Bind on TCP/IP port: Address already in use
1011011:06:37 Do you already have another mysqld server running on port: 3306 ?
1011011:06:37 Aborting

1011011:06:37 /usr/local/mysql/libexec/mysqld: Shutdown complete

101101 01:06:37 mysqld_safe mysqld from pid file /usr/local/mysql/var/localhost.localdomain.pid ended

lovegx999 发表于 2010-11-1 10:04:08

有老军哥啦 :lol

licess 发表于 2010-11-1 11:55:16

回复 6# 的帖子

Can't start server: Bind on TCP/IP port: Address already in use

端口被占用。

lovegx999 发表于 2010-11-1 20:04:17

端口？
那怎么做呢

licess 发表于 2010-11-2 09:34:17

回复 8# 的帖子

lsof -i:3306 看一下那个程序占用了，kill他，然后再重启msyql

lovegx999 发表于 2010-11-2 10:20:26

# lsof -i:3306
COMMAND   PIDUSER   FD   TYPEDEVICE SIZE NODE NAME
mysqld10767 mysql    9uIPv4 8321414       TCP *:mysql (LISTEN)


还是mysql

kill之后
再用什么方式重启？
使用lnmp里面的命令重启可以不？

licess 发表于 2010-11-2 11:33:38

回复 10# 的帖子

/root/lnmp restart 或者/etc/init.d/mysql restart
页: [1]
查看完整版本: lnmp status显示mysql失败，但实际是运行的