I have an ongoing issue on my Macbook Pro OS X 10.6.4.

Intermittently, my MySQL install will not create a socket on startup. Rebooting sometimes, but not always, solves the problem. Deleting the ib* files in /usr/local/mysql/data and then restarting sometimes, but not always, solves the problem.

My error logs tell me the following:

1. Plugin InnoDB init function returned error
2. Plugin InnoDB registration as a STORAGE ENGINE failed
3. Can't start server: Bind on TCP/IP port: Address already in use
4. Do you already have another mysqld server running on port: 3306?
5. Aborting

It then appears to attempt to start again and generates this error 20 - 30 times:

1. Unable to lock ./ibdata1, error 35
2. Check that you do not already have another mysqld process using the same InnoDB data or log files

Though the socket file is not created, I can connect to my MySQL db directly over localhost. Although, this does not help me from a PHP standpoint.

Any thoughts on what I can do to resolve the issue or debug further? I'm at a loss as to where to go from here.