| 1 |
Michael Sullivan wrote: |
| 2 |
> I am having trouble with /etc/init.d/mysql. I rebooted my system, and |
| 3 |
> when it finished rebooting I tried to connect to the mysql daemon and |
| 4 |
> failed. I looked in /var/log/mysql: There was a file there called |
| 5 |
> mysql.err. The contents were: |
| 6 |
> |
| 7 |
> 050831 15:47:29 mysqld started |
| 8 |
> 050831 15:47:30 Can't start server: Bind on TCP/IP port: Address already |
| 9 |
> in use |
| 10 |
> 050831 15:47:30 Do you already have another mysqld server running on |
| 11 |
> port: 3306 ? |
| 12 |
> 050831 15:47:30 Aborting |
| 13 |
> |
| 14 |
> 050831 15:47:30 /usr/sbin/mysqld: Shutdown Complete |
| 15 |
> |
| 16 |
> 050831 15:47:30 mysqld ended |
| 17 |
> |
| 18 |
|
| 19 |
|
| 20 |
|
| 21 |
check the output of ps aux |
| 22 |
look for mysqld processes in the list - if it is running then try |
| 23 |
killing the mysqld processes or restarting the machine |
| 24 |
|
| 25 |
> |
| 26 |
> I tried netstat | grep '3306': |
| 27 |
> |
| 28 |
> bullet mysql # netstat | grep '3306' |
| 29 |
> bullet mysql # |
| 30 |
|
| 31 |
netstat -n | grep 3306 |
| 32 |
|
| 33 |
or |
| 34 |
|
| 35 |
netstat | grep mysql |
| 36 |
|
| 37 |
might be better |
| 38 |
|
| 39 |
> |
| 40 |
> The output was blank, so I assume that port 3306 is NOT in use. Any |
| 41 |
> ideas? |
| 42 |
> |
| 43 |
|
| 44 |
Do you have something else that could be using the port - a rootkit or |
| 45 |
someone else running a service on the box? |
| 46 |
|
| 47 |
-- |
| 48 |
Tim Igoe |
| 49 |
tim@×××××××.uk |
| 50 |
http://tim.igoe.me.uk - Personal Site |
| 51 |
http://tv.igoe.me.uk - UK TV Guide |
| 52 |
|
| 53 |
"Computers are like Air-con, open windows and they stop working!" |
Archives