Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have MAMP Pro running on OS X 10.7.2 and it uses port 3306 for MYSQL. It was running fine until this morning when I installed a trial of WebStart. I subsequently did not like Webstart and quit and uninstalled it. My problem now is that MAMP Pro will not Start MYSQL. The log shows:

Check that you do not already have another mysqld process using the same InnoDB data or   log files.

I ran this in terminal:

lsof -i:3306

... and it returned:

COMMAND  PID   USER   FD   TYPE             DEVICE SIZE/OFF NODE NAME
mysqld  3966 _mysql   10u  IPv4 0xffffff802505c880      0t0  TCP localhost:mysql (LISTEN)

However, I am not really sure what this means and what to do. I suspect that WebStart put this other process in place for port 3306.

share|improve this question

2 Answers 2

up vote 3 down vote accepted

There is already a MySQL Server Daemon process running on 3306 as PID 3966. It could easily be a leftover process from what appears to be a fairly unclean uninstall. You can kill the process in a variety of ways including (but not limited to):

pkill mysqld
kill -9 3966

You can verify it is gone by running the lsof command again or:

ps -ef | grep mysqld

Once you are sure the process is gone your MAMP instance of MySQL should be able to start.

share|improve this answer
1  
Only use kill -9 as a last resort! you should start with using the normal startup/shutdown scripts and/or commands like service to start or stop the processes. –  Zypher Apr 9 '12 at 18:50
    
@Zypher running under the assumption the normal scripts are gone since he uninstalled the application, but I otherwise agree. –  WerkkreW Apr 9 '12 at 18:52
    
Thanks I had to use `kill -9 3966' (had to switch to su), restarted my computer and MAMP Pro works normally now. Thanks! –  Danny Englander Apr 9 '12 at 19:02

You can also kill all pids running on a port with the following if you want to more blindly do it

fuser -k 3306/tcp
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.