安装了lnmp 0.7full后，mysql有点问题

paynezhou · 发表于 2011-5-20 19:34:34

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:02

已经有mysql在运行了，可能是原来就安装了mysql，ps aux看一下，kill 进程ID，再/etc/init.d/mysql start

paynezhou · 发表于 2011-5-20 20:38:29

使用军哥的方法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:02

应该是进程没kill掉

paynezhou · 发表于 2011-5-20 22:10:08

重装了一遍lnmp，phpmyadmin可以连接上mysql了，但是pureftp的问题依旧，求救

licess · 发表于 2011-5-20 22:20:29

pureftpd连不上可能是数据库连接信息问题

paynezhou · 发表于 2011-5-20 22:59:57

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

		自动登录	找回密码
密码			注册

安装了lnmp 0.7full后，mysql有点问题

回复 2# 的帖子

回复 2# 的帖子

军哥运维代购：http://shop63846532.taobao.com/