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:~$

1 members found this post helpful.

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.

1 members found this post helpful.

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

1 members found this post helpful.

thanks a lot it was because of skip networking