mysql安装端口3306报错,在端口3306上运行的另一个mysqld服务器错误

作者：寸_铁 | 2024-06-21 19:01:57

踩

do you already have another mysqld server running on port: 3306 ?

I have installed Mysql 5.1 on Mac OS X 10.7 Lion. For some reason, though, when I try starting the server with the command "mysqld" I get an error in the log file which says:

120328 21:32:40 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use

120328 21:32:40 [ERROR] Do you already have another mysqld server running on port: 3306 ?

120328 21:32:40 [ERROR] Aborting

If I run "netstat -nat | grep 3306" in my terminal, I get the following:

tcp4 0 0 *.3306 . LISTEN

UPDATE:

So here's the output for that.

mysqld 24645 sb1752 12u IPv4 0xffffff8010f6bde0 0t0 TCP *:mysql (LISTEN)

This is odd though! Because my mysql server is not started.

When I type "mysql" in command line, it says

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

I did install other version of mysql and uninstalled earlier today. Any idea what to do here?

解决方案

You could use netstat -lp | grep 3306 to find out what program is already listening on port 3306 (you should see PID/Program name in last column) and stop that (maybe mysql is already running?).

Alternatively you could start the newly installed server on a different port. (edit my.cnf and change the default port there)

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/寸_铁/article/detail/743944