MySQL Bugs: #15292: Add --instance option to mysql client

Bug #15292	Add --instance option to mysql client
Submitted:	28 Nov 2005 17:06	Modified:	2 May 2006 3:39
Reporter:	Kolbe Kegel	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	5.0	OS:	Linux (Linux, Any)
Assigned to:	Mike Hillyer	CPU Architecture:	Any

Description:
Even though Instance Manager makes it easy to manage multiple instances of a server, there is no easy way to manage multiple client configurations to connect to those instances.

How to repeat:
n/a

Suggested fix:
I suggest a --instance option to the mysql command line client (and other MySQL command line utilities) that would cause the utility to read from a corresponding section of the defaults file.

This would be particularly handy if a user needed to use different username/password combinations for a given server, not to mention a variety of hostname, port, and/or socket options.

Separate explicit sections in my.cnf for each client that could be accessed using different arguments to the --instance option would be the preferred method of implementation.

Already documented at http://dev.mysql.com/doc/refman/5.0/en/option-files.html

As that seems like the most appropriate place I'm leaving it alone.