NETGEAR is aware of a growing number of phone and online scams. To learn how to stay safe click here.
Forum Discussion
Quikdav
Sep 29, 2013Aspirant
Mysql server start and stop as soon
Hi all I have a problem to start the mysqlserver !! I have installed FW 4.1.12 and when I try to start it, it seems to start a few second and then stop. Here is the command I use : start-stop...
Quikdav
Sep 30, 2013Aspirant
ok I found some interesting information.. I tried running the server with option "--log-error=/c/mysql.log" and here is the result :
/usr/sbin/mysqld, Version: 5.0.24a-Debian_3.infrant1-log. started with:
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
Time Id Command Argument
130930 23:11:31 InnoDB: Started; log sequence number 0 126948287
130930 23:11:31 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
130930 23:11:31 [ERROR] Do you already have another mysqld server running on port: 3306 ?
130930 23:11:31 [ERROR] Aborting
130930 23:11:31 InnoDB: Starting shutdown...
130930 23:11:33 InnoDB: Shutdown completed; log sequence number 0 126948287
130930 23:11:33 [Note] /usr/sbin/mysqld: Shutdown complete
So I checked what happen with port 3306 with "netstat -a -t -n" and I found this line :
tcp 0 0 127.0.0.1:3306 127.0.0.1:3306 ESTABLISHED
I tried to kill an eventualy server with "start-stop-daemon --stop -x /usr/sbin/mysqld" and I had this result : "No /usr/sbin/mysqld found running; none killed."
So I wonder who is using this port !!
Thanks for your help
David
/usr/sbin/mysqld, Version: 5.0.24a-Debian_3.infrant1-log. started with:
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
Time Id Command Argument
130930 23:11:31 InnoDB: Started; log sequence number 0 126948287
130930 23:11:31 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
130930 23:11:31 [ERROR] Do you already have another mysqld server running on port: 3306 ?
130930 23:11:31 [ERROR] Aborting
130930 23:11:31 InnoDB: Starting shutdown...
130930 23:11:33 InnoDB: Shutdown completed; log sequence number 0 126948287
130930 23:11:33 [Note] /usr/sbin/mysqld: Shutdown complete
So I checked what happen with port 3306 with "netstat -a -t -n" and I found this line :
tcp 0 0 127.0.0.1:3306 127.0.0.1:3306 ESTABLISHED
I tried to kill an eventualy server with "start-stop-daemon --stop -x /usr/sbin/mysqld" and I had this result : "No /usr/sbin/mysqld found running; none killed."
So I wonder who is using this port !!
Thanks for your help
David
Related Content
NETGEAR Academy
Boost your skills with the Netgear Academy - Get trained, certified and stay ahead with the latest Netgear technology!
Join Us!