VPS侦探论坛

标题: 安装了lnmp 0.7full后，mysql有点问题 [打印本页]

作者: paynezhou 时间: 2011-5-20 19:34
标题: 安装了lnmp 0.7full后，mysql有点问题
service mysql status 显示 runing，但是探针显示无法连接mysql，pureftp也提示Error: MySql server not found.

以下是错误日志

110520 21:19:31 mysqld_safe Starting mysqld daemon with databases from /usr/loca                                                                            l/mysql/var
110520 21:19:31 [ERROR] Can't start server: Bind on TCP/IP port: Address already                                                                            in use
110520 21:19:31 [ERROR] Do you already have another mysqld server running on por                                                                            t: 3306 ?
110520 21:19:31 [ERROR] Aborting

110520 21:19:31 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

110520 21:19:31 mysqld_safe mysqld from pid file /usr/local/mysql/var/l-2-173-05                                                                            11.pid ended
110520 21:19:32 mysqld_safe Starting mysqld daemon with databases from /usr/loca                                                                            l/mysql/var
110520 21:19:32 [ERROR] Can't start server: Bind on TCP/IP port: Address already                                                                            in use
110520 21:19:32 [ERROR] Do you already have another mysqld server running on por                                                                            t: 3306 ?
110520 21:19:32 [ERROR] Aborting

110520 21:19:32 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

110520 21:19:32 mysqld_safe mysqld from pid file /usr/local/mysql/var/l-2-173-05                                                                            11.pid ended
110520 21:25:55 mysqld_safe Starting mysqld daemon with databases from /usr/loca                                                                            l/mysql/var
110520 21:25:56 [ERROR] Can't start server: Bind on TCP/IP port: Address already                                                                            in use
110520 21:25:56 [ERROR] Do you already have another mysqld server running on por                                                                            t: 3306 ?
110520 21:25:56 [ERROR] Aborting

110520 21:25:56 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

110520 21:25:56 mysqld_safe mysqld from pid file /usr/local/mysql/var/l-2-173-05                                                                            11.pid ended
110520 21:25:59 mysqld_safe Starting mysqld daemon with databases from /usr/loca                                                                            l/mysql/var
110520 21:26:02 [ERROR] Can't start server: Bind on TCP/IP port: Address already                                                                            in use
110520 21:26:02 [ERROR] Do you already have another mysqld server running on por                                                                            t: 3306 ?
110520 21:26:02 [ERROR] Aborting

110520 21:26:02 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

110520 21:26:02 mysqld_safe mysqld from pid file /usr/local/mysql/var/l-2-173-05                                                                            11.pid ended
110520 21:34:07 mysqld_safe Starting mysqld daemon with databases from /usr/loca                                                                            l/mysql/var
110520 21:34:08 [Note] Event Scheduler: Loaded 0 events
110520 21:34:08 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.54-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distributio                                                                            n
110521  2:40:46 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

110521  2:40:46 [Note] Event Scheduler: Purging the queue. 0 events
110521  2:40:46 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

110521 02:40:46 mysqld_safe mysqld from pid file /usr/local/mysql/var/l-2-173-05                                                                            11.pid ended
110521 02:40:50 mysqld_safe Starting mysqld daemon with databases from /usr/loca                                                                            l/mysql/var
110521  2:40:50 [Note] Event Scheduler: Loaded 0 events
110521  2:40:50 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.54-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distributio                                                                            n
110521  3:05:35 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

110521  3:05:35 [Note] Event Scheduler: Purging the queue. 0 events
110521  3:05:35 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

110521 03:05:35 mysqld_safe mysqld from pid file /usr/local/mysql/var/l-2-173-05                                                                            11.pid ended
110521 03:05:36 mysqld_safe Starting mysqld daemon with databases from /usr/loca                                                                            l/mysql/var
110521  3:05:36 [Note] Event Scheduler: Loaded 0 events
110521  3:05:36 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.54-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distributio                                                                            n
110521  3:10:46 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

110521  3:10:46 [Note] Event Scheduler: Purging the queue. 0 events
110521  3:10:46 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

110521 03:10:46 mysqld_safe mysqld from pid file /usr/local/mysql/var/l-2-173-05                                                                            11.pid ended
110521 03:11:46 mysqld_safe Starting mysqld daemon with databases from /usr/loca                                                                            l/mysql/var
110521  3:11:46 [Note] Event Scheduler: Loaded 0 events
110521  3:11:46 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.54-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distributio                                                                            n

作者: licess 时间: 2011-5-20 19:49
已经有mysql在运行了，可能是原来就安装了mysql，ps aux看一下，kill 进程ID，再/etc/init.d/mysql start

作者: paynezhou 时间: 2011-5-20 20:38
标题: 回复 2# 的帖子
使用军哥的方法kill了一个进程后，错误日志变成这样了，
110521 04:26:49 mysqld_safe mysqld from pid file /usr/local/mysql/var/l-2-173-0511.pid ended
110521 04:27:24 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
110521  4:27:24 [Note] Event Scheduler: Loaded 0 events
110521  4:27:24 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.54'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
110521  4:28:48 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

110521  4:28:48 [Note] Event Scheduler: Purging the queue. 0 events
110521  4:28:48 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

110521 04:28:48 mysqld_safe mysqld from pid file /usr/local/mysql/var/l-2-173-0511.pid ended
110521 04:30:21 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
110521  4:30:21 [Note] Event Scheduler: Loaded 0 events
110521  4:30:21 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.54'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

但是phpmyadmin依然连接不上，pureftp依然显示 Error: MySql server not found.

作者: licess 时间: 2011-5-20 21:24
应该是进程没kill掉

作者: paynezhou 时间: 2011-5-20 22:10
标题: 回复 2# 的帖子
重装了一遍lnmp，phpmyadmin可以连接上mysql了，但是pureftp的问题依旧，求救

作者: licess 时间: 2011-5-20 22:20
pureftpd连不上可能是数据库连接信息问题

作者: paynezhou 时间: 2011-5-20 22:59
根据https://bbs.vpser.net/viewthread.php?tid=1796 这个帖子重装了一遍pureftpd，然后问题就解决了，多亏老大指点，感激不尽！

欢迎光临 VPS侦探论坛 (https://bbs.lnmp.com/)