MySQL InnoDB/socket issue on Mac OS X 10.6.4
- by user55217
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:
Plugin InnoDB init function returned error
Plugin InnoDB registration as a STORAGE ENGINE failed
Can't start server: Bind on TCP/IP port: Address already in use
Do you already have another mysqld server running on port: 3306?
Aborting
It then appears to attempt to start again and generates this error 20 - 30 times:
Unable to lock ./ibdata1, error 35
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.