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

lovegx999

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

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

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

licess

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

lovegx999

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

licess

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

lovegx999

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

101021 10:42:12 [Note] /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 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
101029 18:33:03 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
101029 18:33:03 [ERROR] Do you already have another mysqld server running on port: 3306 ?
101029 18:33:03 [ERROR] Aborting

101029 18:33:03 [Note] /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 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
101029 18:36:30 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
101029 18:36:30 [ERROR] Do you already have another mysqld server running on port: 3306 ?
101029 18:36:30 [ERROR] Aborting

101029 18:36:30 [Note] /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 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
101029 18:36:34 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
101029 18:36:34 [ERROR] Do you already have another mysqld server running on port: 3306 ?
101029 18:36:34 [ERROR] Aborting

101029 18:36:34 [Note] /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
101101  0:50:34 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
101101  0:50:34 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
101101  0:50:34 [ERROR] Do you already have another mysqld server running on port: 3306 ?
101101  0:50:34 [ERROR] Aborting

101101  0:50:34 [Note] /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
101101  0:51:23 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
101101  0:51:23 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
101101  0:51:23 [ERROR] Do you already have another mysqld server running on port: 3306 ?
101101  0:51:23 [ERROR] Aborting

101101  0:51:23 [Note] /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
101101  0:53:21 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
101101  0:53:21 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
101101  0:53:21 [ERROR] Do you already have another mysqld server running on port: 3306 ?
101101  0:53:21 [ERROR] Aborting

101101  0:53:21 [Note] /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
101101  0:54:37 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
101101  0:54:37 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
101101  0:54:37 [ERROR] Do you already have another mysqld server running on port: 3306 ?
101101  0:54:37 [ERROR] Aborting

101101  0:54:37 [Note] /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
101101  0:54:56 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
101101  0:54:56 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
101101  0:54:56 [ERROR] Do you already have another mysqld server running on port: 3306 ?
101101  0:54:56 [ERROR] Aborting

101101  0:54:56 [Note] /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
101101  0:57:24 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
101101  0:57:24 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
101101  0:57:24 [ERROR] Do you already have another mysqld server running on port: 3306 ?
101101  0:57:24 [ERROR] Aborting

101101  0:57:24 [Note] /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
101101  1:06:37 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
101101  1:06:37 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
101101  1:06:37 [ERROR] Do you already have another mysqld server running on port: 3306 ?
101101  1:06:37 [ERROR] Aborting

101101  1:06:37 [Note] /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

有老军哥啦

licess

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

端口被占用。

lovegx999

端口？
那怎么做呢

licess

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

lovegx999

[root@localhost ~]# lsof -i:3306
COMMAND   PID  USER   FD   TYPE  DEVICE SIZE NODE NAME
mysqld  10767 mysql    9u  IPv4 8321414       TCP *:mysql (LISTEN)


还是mysql

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

licess

/root/lnmp restart 或者/etc/init.d/mysql restart