Bug #31002 specifying a tcp port on the command line may not always then use TCP...
Submitted: 13 Sep 2007 15:51 Modified: 9 Dec 2010 18:54
Reporter: Roger Pack Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Command-line Clients Severity:S4 (Feature request)
Version:5.0.22 OS:Any
Assigned to: CPU Architecture:Any
Tags: command line, tcp port
Triage: Needs Triage: D5 (Feature request)

[13 Sep 2007 15:51] Roger Pack
When running the mysql client thus:
mysql --port=5900
it may still not use that port, but reverts to the defaults.  I.e. I expected it to act like
mysql --port=5900 --protocol=TCP 
(which does work)
since I had specified a TCP port, I anticipated it getting used.
Note that the same thing is present in mysqladmin (you need to specify both port and protocol, at times, to get the port to work).
Thank you!

How to repeat:
Install mysql like normal.
Now create a second 'side by side' concurrently running daemon (on a different port)
create new.cnf:

# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).

# basedir left the same



now go to that data directory that you want, run 
mysql_install_db --user=roger --ldata=.

mysqld_safe --defaults-file=./my.cnf --user=roger --skip-locking & # maybe nohup this command ?

and it might (should) start it for you...I think....

/usr/bin/mysqladmin --port=8900 --protocol=TCP -u root password 'dbadmin' # works
/usr/bin/mysqladmin --port=8900 -u root password 'dbadmin' #  does not work, when you'd think it would.

Suggested fix:
One way to fix this would be to output a warning if a user specifies a TCP port on the command line and the port ever used ("warning tcp port specification ignored"), and/or to have a verbose mode showing exactly which port IS being used, to make debugging this less painful.
[9 Dec 2010 18:54] Valeriy Kravchuk
It would be nice to have some option (off by default, for backward compatibility) to force TCP instead of socket when --port is used. 

See also: bug #31577