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