Port number on local MySQL client?

[jimoblak]

I use MySQL-Front 2.5 as a remote client for MySQL. I know that the default port for my remote MySQL server is 3306 but is there a way to tell what port my local computer would be using to connect? Does it use the same 3306? Does it cycle through several local ports like FTP?

My connection was lost today and I suspect it is because our network administrator is locking down open ports. I would like to know which port(s) I should have him reopen.

- - picklefish - -
Why is everyone in this forum responding to me as picklefish?

 

[sleipnir214]

I don't understand.

MySQL listens, by default, on 3306.

MySQL client software, then, by default, must connect to that port on the server.



Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[jimoblak]

I may not understand myself. ...and my question could be corrected to ask:

I know that the default port for my remote MySQL server is 3306 but is there a way to tell what local outgoing port my local computer would be using to connect?

What little that I do understand is that while one connects to a default FTP port 21 on a remote system, the client computer may cycle through a range of local ports to make this connection and transfer.

So I am wondering what outgoing port I am using on my local computer to connect to port 3306 on the remote MySQL server.

- - picklefish - -
Why is everyone in this forum responding to me as picklefish?

 

[jetsoft]

There's no way to know what local port your connection will get. You connect to "well-known" port 3306, your local port is will be something between 1025 and 64000-something, whatever is free. "Listening" ports are fixed (ex. http=80, ftp=21, telnet=23, ssh=22, ...) all connections made to those ports will get a variable portnumber, depending on what local ports are still available.

You should talk to your Network Administrator and ask him to reopen port 3306 for outgoing connections, he probably closed that one by mistake.

Jet-Soft

 

[jimoblak]

The net admin had closed down all ports the other day because he realized that all were left open by the previous net admin. After monitoring outgoing connections and manually approving them, things are working fine now.

- - picklefish - -
Why is everyone in this forum responding to me as picklefish?