NYCPHP Meetup

NYPHP.org

[nycphp-talk] MySQL reports that port 3306 is not free.

Tim Gales tgales at tgaconnect.com
Wed May 5 16:09:40 EDT 2004


when I run msqld_safe &

it says:
"Starting mysqld daemon with databases from /usr/local/mysql/data 040505
15:57:51  mysqld ended" 

jobs says: "jobs
[1]+  Stopped(SIGTSTP)        mysqld_safe  (wd: ../bin/mysqld_safe)
[2]-  Done                    ./bin/mysqld_safe

the last lines of the error log say:
040505 15:54:51  mysqld started
040505 15:54:51  Can't start server: Bind on TCP/IP port: Address already
in use 040505 15:54:51  Do you already have another mysqld server running
on port: 3306 ? 040505 15:54:51  Aborting

so I edited my.cnf 

to have 
#port		= 3308
#socket		= /tmp/mysql.sock

in both sections [client] and [mysqld]

and reran the safe start script 
exactly the same results

I haven't change any permissions on any 
directories anywhere (intentionally).

I am starting to think that the error logging 
is mis-reporting the stuff about the port being used.



Any advice would be appreciated

TIA


T. Gales & Associates
'Helping People Connect with Technology'

http://www.tgaconnect.com




More information about the talk mailing list