yesterday i post a querry "problem with my sql"
have recently installed mysql
when i run mysqld in terminal
the following occurs


can't start the server: bind on tcp/ip port: address already in use
do you have already another mysql server running on port :3306 ?

mysqld:shut down complete

please help me


jeremy replied

Sounds like either mysqld is already started or you have some other service started on port 3306. Try typing "netstat -avp --inet | grep mysql". What is listed under PID/Program name

but i did it
terminal shows the following
proto recQ sendQ local address forieign address


tcp 0 0 *:mysql *:* listen
783/mysqd

how it works????

Read documentation on www.mysql.org

Personally i would have gone for then killed of the mysql processes using the process IDs returned by the above command... Assuming there were any. Then attempted to start mysql again from the command line.

cheers

Jamie...