hi Dhandapani, The 3306 port is not listening. But there are some connection whose state is FIN_WAIT_2 as you can see in my first letter.
After about 10 minutes I shutdowned mysql, I restarted mysql as root using: /usr/local/mysql/bin/mysqld_safe &. It worked. Before it, I did this as mysql and I got the error. Regards, Leo Huang 2006/3/28, [S] Dhandapani <[EMAIL PROTECTED] >: > > Hi Leo, > > check for cnf file for which port you have configured the port .If it is > in 3306 port then do netstat -an|grep LIST ,check for 3306 port is listening > on your system .If yes you mysql process has not shutdown properly. > > shutdown the mysql process completely and start the mysql process by > specifying your datadirectory. > > /usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my.cnf > --datadir=/usr/local/mysql/data/ --user=mysql & > > port = 3306 > socket = /tmp/mysql.sock > > Regards, > Dhandapani > > > leo huang wrote: > > hi, Lakshmi > > The mysql process had ended. I get it from both mysql err log and ps > output. > > regards, > Leo Huang > > 2006/3/28, Lakshmi M P > <[EMAIL PROTECTED]> <[EMAIL PROTECTED]>: > > Run ps -ef | grep mysql and see any mysql process is running and if so > kill the same and try to start mysql.It may help. > leo huang wrote: > > hi, > > I met the MySQL restart error today. > > First, I stopped the running mysql server using > /usr/local/mysql/bin/mysqladmin -uroot shutdown. > > After the server shutdowned, I restarted it using > > /usr/local/mysql/bin/mysqld_safe &. > > Then, I got this error: [ERROR] Can't start server: Bind on TCP/IP port: > Address already in use. > > There was no other process that was using the port 3306 which mysql > > server > > use. But there were some mysql connect did not release because the > > shutdown. > > The error log is followed: > 060328 8:20:45 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown > > 060328 8:20:47 InnoDB: Starting shutdown... > 060328 8:20:49 InnoDB: Shutdown completed; log sequence number 120 > > 2134241340 > 060328 8:20:49 [Note] /usr/local/mysql/libexec/mysqld: Shutdown > > complete > > 060328 08:20:49 mysqld ended > > 060328 08:21:15 mysqld started > 060328 8:21:15 [ERROR] Can't start server: Bind on TCP/IP port: Address > already in use > 060328 8:21:15 [ERROR] Do you already have another mysqld server > > running on > > port: 3306 ? > 060328 8:21:15 [ERROR] Aborting > > 060328 8:21:15 [Note] /usr/local/mysql/libexec/mysqld: Shutdown > > complete > > 060328 08:21:15 mysqld ended > > The netstat outputs are followed: > $ netstat -al > Active Internet connections (including servers) > Proto Recv-Q Send-Q Local Address Foreign > > Address (state) > > tcp4 0 0 bj.3306 s4.9405 FIN_WAIT_2 > tcp4 0 0 bj.3306 s4.5168 FIN_WAIT_2 > tcp4 0 0 bj.3306 s4.25007 FIN_WAIT_2 > > tcp4 0 0 bj.3306 s4.9940 FIN_WAIT_2 > tcp4 0 0 bj.3306 s4.3916 FIN_WAIT_2 > tcp4 0 0 bj.3306 s4.15229 FIN_WAIT_2 > tcp4 0 0 > bj.3306 s4.6479 FIN_WAIT_2 > tcp4 0 0 bj.3306 s4.7873 FIN_WAIT_2 > > Our mysql version is 4.1.18. It is running on FreeBSD 4.9-RELEASE. > > Any comment will be great thankful! > > > Regards, > Leo Huang > > > -- > regards, > Lakshmi.M.P. > DBA-Support > Sify Limited. > Ext:4134 > > ********** DISCLAIMER ********** > Information contained and transmitted by this E-MAIL is proprietary to > Sify Limited and is intended for use only by the individual or entity to > > which it is addressed, and may contain information that is privileged, > confidential or exempt from disclosure under applicable law. If this is a > forwarded message, the content of this E-MAIL may not have been sent with > > the authority of the Company. If you are not the intended recipient, an > agent of the intended recipient or a person responsible for delivering > the > information to the named recipient, you are notified that any use, > > distribution, transmission, printing, copying or dissemination of this > information in any way or in any manner is strictly prohibited. If you > have > received this communication in error, please delete this mail & notify us > > immediately at [EMAIL PROTECTED] > www.sify.com - your homepage on the internet for news, sports, finance, > astrology, movies, entertainment, food, languages etc > > >