http://www.zhuoda.org/xiezhi/98178.html
mysql启动错误[Bind on TCP/IP port:...] 新装完的系统安装完mysql并且设置IP重启之后,mysql就怎么也启动不了,一直提示:
greatmoo:~# mysqld & [1] 3527 greatmoo:~# 081021 11:02:51 InnoDB: Started; log sequence number 0 43655 081021 11:02:51 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address 081021 11:02:51 [ERROR] Do you already have another mysqld server running on port: 3306 ? 081021 11:02:51 [ERROR] Aborting
081021 11:02:51 InnoDB: Starting shutdown...
greatmoo:~# 081021 11:02:54 InnoDB: Shutdown completed; log sequence number 0 43655 081021 11:02:54 [Note] mysqld: Shutdown complete 提示是 端口可能被占用,于是执行:
greatmoo:~# netstat -anp | grep "3306" 返回值为空,那么是IP错误~?感觉不太可能,于是上网查错误提示,到处都说是权限错误,但是却没有真正解决掉问题的,还是硬着头皮 chown mysql.myql N个文件,结果当然还是不行…
于是又把问题锁定在了IP和port上。
准备把port改成其它的例如3307之类的试一下,查看mysql设置:
greatmoo:~# vi /etc/mysql/my.cnf [client] port = 3307 # …
# …
[mysqld] # … port = 3307 # … 准备保存后启动mysql来着,却无意中发现了下面的设置:
# … bind-address = 127.0.0.1 # … 于是把 127.0.0.1 改为 192.168.1.10 后再启动 mysql 就成功了……哎~看来学习还是系统的学习比较好啊。 |