Hi All, I've been trying to re-start the mysql server for a while now. A few days ago, I discovered that I couldn't connect to the database after entering my password. I got the usual "can't connect via the /tmp/mysql.sock" message.
I tried to restart the daemon with ./bin/safe_mysqld &, but that didn't work. So I check the my_host_name.err file in the /data and found this: "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" My 2 questions: 1. WHAT DO I DO???!!! :-) 2. I searched Google Groups and I came up with this message in a thread: Monty: "calling setsockopt() with SO_REUSEADDR on the server socket should solve this problem. On Linux ( possibly on other systems too) this can happen if the server dies without closing the socket, and the client is still connected. Killing all the clients should allow the server to bind the port again, even with the current code. -- Sasha Pachev" what is "setsockopt() and SO_REUSEADDR " and how do I use 'em? Many thanks,All. ===== ######################################### Warmest Regards, Simon K. Chan - [EMAIL PROTECTED] "Great spirits have always encountered violent opposition from mediocre minds." - Albert Einstein __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
