MySQL Bugs: #29758: mysqld should be able to dump system variables other than non-default port

Bug #29758	mysqld should be able to dump system variables other than non-default port
Submitted:	12 Jul 2007 14:01	Modified:	2 Feb 2013 14:25
Reporter:	Heng Sun	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Command-line Clients	Severity:	S4 (Feature request)
Version:	5.0.41	OS:	Linux (SuSE Enterprise 9)
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
If I have more than one mysql severs installed (listening different ports), there is no way to tell "mysqld --verbose --help" dump the variables on non-default ports. Specifying --defaults-file or --port, etc does not help.

How to repeat:
Install an mysql server on default port.
Install an mysql server on another port, in the same machine.
Start both servers.
Execute mysqld --verbose --help.
The variable values are all from the default port.
There is no way to see the variables from the other port.

To see what values a running MySQL server is using, type
'mysqladmin variables' instead of 'mysqld --verbose --help'.