see if there is a /tmp/mysql.sock file, is there a mysqld process running (#ps -ef), also you could use #netstat -a to see if there is a process utilizing port 3306, also has there been any file corruption due to the outage ( #fsck), does the rest of the machine work well as expected, try a reboot if nothing works .......
Kishore Jalleda On 2/8/06, Michael Satterwhite <[EMAIL PROTECTED]> wrote: > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > 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 > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.1 (GNU/Linux) > Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org > > iD8DBQFD6e3IjeziQOokQnARAu+mAJ4siupByeMHMhWQmO+8K1n67WslWgCaAjU/ > QNpXeN3/paVlicOVFRW4paQ= > =qnEs > -----END PGP SIGNATURE----- > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
