MySQL

huck

Registered
Can't start server: Bind on TCP/IP port: Address already in use
020409 11:39:29 Do you already have another mysqld server running on port: 3306 ?

What does this mean...and how do i fix it?
 
I don't know the answer, but try posting your question on press3.com there are not enough questions there so you are sure to get an answer quickly
 
... there's something else already using that port. It could be that you already have MySQL started. You could try telnetting to that port to see if there's something there, or you could use the port scan tool in Applications/Utilities/Network Utility to see if that port is open. If so, you have to find out what is using that port (the telnet *may* give you some info) and then stop that process first before trying to start MySQL.

Now, if it actually is MySQL that's already running, then look for mysqld in the process listing (either ps -aex | grep mysqld | grep -v grep) or you can have a look in the Process Viewer appliacation in Applications/Utilities (I think that's what its called, anyway). You should be able to use the mysql utility programms to restart or stop the process. If that doesn't work, then kill it with kill -9 {PID} ... where {PID} is the process ID of the mysqld process.

Hope that helps.

C
 
Does MySQL still have trouble stopping? I installed it some time ago but the stop script could not shut down the daemon.
 
try running the command mysql from a command line. Do you enter Mysql? If so there is already a mysql running.

Mysqdladmin stops the mysql daemon. Try checking the man for the commands. The non stopping thing has not been an issue for me and I think it has been a dead issue for awhile. I could be wrong though.

If none of this works, check out Marc Liyanage's site:

http://www.entropy.ch/software/macosx/mysql/

He has some detailed instructions on installing, removing, and upgrading MySQL.

Good Luck.:)
SA
 
Originally posted by gdanko
This is a known issue with MySQL and OS X.

The MySQL shutdown issue with Mac OS X has been fixed at least a couple releases back. I forgot the actual version number, but this can be verified at www.mysql.com.
 
Back
Top