×

mysql启动错误[Bind on TCP/IP port:...]

admin admin 发表于2022-04-11 00:17:53 浏览2834 评论0

抢沙发发表评论

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
# …


群贤毕至

访客