mysql port issue

varun_saa · 10-22-2007, 10:33 AM

Hello,

I have Mandriva2008 installed.

I am not able to detect mysql port no.

The command : mysqladmin -u root -p variables

yields the following reults :

pid_file | /var/run/mysqld/mysqld.pid |
| port | 0 |
| preload_buffer_size | 32768

I have checked on Centos it show port no.

Can anybody tell me why is it not showing port as 3306 ???

Thanks

Varun

stickman · 10-22-2007, 08:56 PM

Is your mysql server using sockets for connections?

varun_saa · 10-22-2007, 11:06 PM

Is your mysql server using sockets for connections?

Can please explain.I am not sure I understand that.

Thanks advance

Varun

stickman · 10-30-2007, 07:33 AM

Quote:

Originally Posted by varun_saa

Is your mysql server using sockets for connections?

Can please explain.I am not sure I understand that.

Thanks advance

Varun

If your mysqld instance is configured to use a socket file for connections only local clients can connect. It will not listen on a port. Look in you my.cnf for "socket=" and check the output of netstat to see where mysqld is listening.