I updated mysql from 4.1.11 to 4.1.13 and the problem started.
when I type mysqld as root I get the following
050725 11:09:03 [Warning] Asked for 196608 thread stack, but got 126976
050725 11:09:03 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
050725 11:09:03 [ERROR] Do you already have another mysqld server running on port: 3306 ?
050725 11:09:03 [ERROR] Aborting
Make sure no other process of mysql is running. If there is, kill it.
Or simply restarting your server might correct the problem if you don't want to or know how to kill a process.
Make sure no other process of mysql is running. If there is, kill it.
Or simply restarting your server might correct the problem if you don't want to or know how to kill a process.
Then did you make sure that only one process of mysql is trying to start? Check your startup scripts.
Have you tried killing all mysql processes manually and then restarting only one process?