why dont i see the port listening?
 

i have started mysql server
i can use the mysql terminal monitor
but yet i cant find out the port 3306 when i type the command netstat -ntpl
i have read the my.cnfand the port used is 3306
why dont i see the port listening?

Post the Output for below command and check whether port is listening on port number 3306 (mysql)


arun@arun-desktop:~$ netstat -apn | grep "mysql"
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
unix 2 [ ACC ] STREAM LISTENING 6921 - /var/run/mysqld/mysqld.sock

arun@arun-desktop:~$ netstat -apn | grep :3306
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN -
arun@arun-desktop:~$

Are you executing netstat -ntpl as root or as normal user? You should do this as root, running it as normal user will not show all, only those associated with that specific user.

is it because skip-networking is enabled in my.cnf?

---------- Post added 08-14-12 at 06:11 AM ----------

yes i am executing metstat -ntpl as the user root
but still i cannot find the port
is it because of skip networking?

I guess so: Source: http://dev.mysql.com/doc/refman/5.1/...r-options.html

thanks a lot it was because of skip networking
:)