下午在VM上装了个ubuntu 7.10 server, 在启动mysql的时候失败. 日志记录如下
Jan 21 11:42:51 bigcomic mysqld_safe[5761]: started
Jan 21 11:42:51 bigcomic mysqld[5765]: 080121 11:42:51 InnoDB: Started; log sequence number 0 43655
Jan 21 11:42:51 bigcomic mysqld[5765]: 080121 11:42:51 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
Jan 21 11:42:51 bigcomic mysqld[5765]: 080121 11:42:51 [ERROR] Do you already have another mysqld server running on port: 33306 ?
Jan 21 11:42:51 bigcomic mysqld[5765]: 080121 11:42:51 [ERROR] Aborting
Jan 21 11:42:51 bigcomic mysqld[5765]:
Jan 21 11:42:51 bigcomic mysqld[5765]: 080121 11:42:51 InnoDB: Starting shutdown...
Jan 21 11:42:53 bigcomic mysqld[5765]: 080121 11:42:53 InnoDB: Shutdown completed; log sequence number 0 43655
Jan 21 11:42:53 bigcomic mysqld[5765]: 080121 11:42:53 [Note] /usr/sbin/mysqld: Shutdown complete
Jan 21 11:42:53 bigcomic mysqld[5765]:
Jan 21 11:42:53 bigcomic mysqld_safe[5795]: ended
google 了一下 https://bugs.launchpad.net/ubuntu/+source/network-manager/+bug/104466 Alexander的回答让我茅塞顿开.
我在装系统的时候没有配置网卡. 安装好系统配置网卡的时候顺手注释了两行
#auto lo
#iface lo inet loopback
这导致127.0.0.1 PING不通. 而my.cnf里bind的ip正是127.0.0.1 自然也就启动失败了. 注释去掉
/etc/init.d/networking restart
/etc/init.d/mysql start
至此问题解决