Home / server / Questions / 46777
In Process
Will
Asked: 2009-07-28 16:55:06 +0800 CST

MySQL Unable to bind to any port intermitently on Windows 2003 Server

  • 772

Every few days, we have a server that has the MySQL service stop working. If you try to restart it, it says that another instance of MySQL may already be running on that port. The problem is, there isn't another instance of MySQL running. Additionally, nothing is touching that port according to both TCPView and Netstat. A socket connection to the port fails as if nothing is listening as well. Upon server restart, everything works correctly.

We've tried resetting the TCP/IP stack and upgrading MySQL. If we change the MySQL configuration to run on a different port, no matter what port we chose, it has the same issue. Not sure where to go from here and would love some suggestions.

windows-server-2003 mysql

2 Answers

  1. Most likely the mysql lock file still exists, and is being stored in a temporary directory (thus the reboot fixing things). Find this file (it's at the config variable $lock_file_path and is called mysql.lock usually) and delete it before you restart the service.

    • 0

  2. This would happen if the mysql server exits abnormally. Can you check the mysql server logs.

    • -1