That happens sometimes. Do a mysqladmin shutdown and then try to restart it. It should start just fine.
--ja On Wed, 8 Feb 2006, Michael Satterwhite wrote: > I use a local MySQL server (we're using 4.0) for development. It's been > running cleanly for months - and the configuration file has not changed. > This morning we had a major power problem causing the machine to come > down in an unorderly manner. I can no longer start MySQL, it stops as > soon as it starts. The log messages I'm seeing are: > > Feb 8 11:34:34 photon mysqld_safe[9615]: started > Feb 8 11:34:34 photon mysqld[9619]: 060208 11:34:34 Can't start server: > Bind on TCP/IP port: Cannot assign requested address > Feb 8 11:34:34 photon mysqld[9619]: 060208 11:34:34 Do you already have > another mysqld server running on port: 3306 ? > Feb 8 11:34:34 photon mysqld[9619]: 060208 11:34:34 Aborting > Feb 8 11:34:34 photon mysqld[9619]: > Feb 8 11:34:34 photon mysqld[9619]: 060208 11:34:34 /usr/sbin/mysqld: > Shutdown Complete > Feb 8 11:34:34 photon mysqld[9619]: > Feb 8 11:34:34 photon mysqld_safe[9621]: ended > > There shouldn't be anything running on port 3306 (there wasn't before > the power outage). My guess is that there is something from the previous > run of mysql that's in an indeterminant state - maybe a file that needs > to be cleared or deleted. Unfortunately, I have absolutely no idea where > to start on finding it. > > Would someone be so kind as to help? All help will be greatly appreciated. > > ---Michael > > > -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
