Port parameter at command line is ignored

[Ruben Gomez]

Hi I'm unsuccessfully trying to start a tunneled connection on mysql, after a bit of suffering I've discovered that the mysql client command is just ignoring the "--port=[n]" or "-P [n]" parameters.

BTW I'm on Hardy Heron beta amd64 arch.

Thanks

[Dustin Kirkland  (kirkland)]

Hi,

What do you mean by 'start a tunneled connection on mysql' ?

Generally, "tunneled connections" refer to stunnel or ssh port
forwarding. In which case, you'd ssh from one machine to your mysql
server and use "local port forwarding". See the ssh man page.

Or are you just simply trying to run the mysql client from one machine
to the other? First check to make sure you can connect to the server
from the server using the mysql against localhost. You might also
sanity check your settings in /etc/mysql/my.cnf

:-Dustin

[Dustin Kirkland  (kirkland)]

Thanks for the bug report and helping make Ubuntu better. We're going to need a bit more information about what you're doing to proceed.

[Ruben Gomez (rkg-morgan)]

Hi, I've used tunneled connections for a while, in several OS, just using SSH, evaluating the problem is quite simple, if you try an alternative (unused) port calling the mysql client executable at localhost, the connection should fail, but always starts OK. It's always using the default port ignoring the specified parameter.

[Mathias Gug (mathiaz)]

Could you post the exact command line you're using to connect to the mysql server ?

Note that the -P option should be used in conjunction with the -h option to specify which host to connect to and that using localhost as a host for -h will force the client to use the socket instead of the loopback address.

[Ruben Gomez (rkg-morgan)]

Oh, you're right Mathias using 127.0.0.1 everything is OK. A strange behavior anyway... Sorry about my wrong info.