Subject: Re: bug#7664: sql.el: In interactive sql-<product> command, Add C-u to set connection port

From: Michael Mauger <[email-masked]>
Date: Tue, 21 Dec 2010 19:04:30 -0800 (PST)

In Emacs 24, SQL.el supports the port login parameter.  

By customizing `sql-mysql-login-params'  to include the atom `port' the port 
will be prompted for during login.  If you don't specify a value, it will not be 
specified when you connect so it will use the default.   You can also set a 
default value for port by customizing `sql-port'.

   (setq sql-mysql-login-params '(user password server port database))

Both MySQL and Postgres support the use of port during login. 

________________________________
From: Chong Yidong <[email-masked]>
To: Michael R. Mauger <[email-masked]>
Cc: Jari Aalto <[email-masked]>; [email-masked]
Sent: Tue, December 21, 2010 1:59:40 AM
Subject: Re: bug#7664: sql.el: In interactive sql-<product> command, Add C-u to 
set connection port

Jari Aalto <[email-masked]> writes:

> In production environments the database servers run in multiple ports,
> like
>
>     M-x sql-mysql
>
> It would be nice to be able to specify PORT number during interactive
> call, like:
>
>     C-u M-x sql-mysql
>     ...
>     Port: .....

Michael, could you take a look at this wishlist item?  Currently,
sql-mysql already uses a prefix argument to output into a new buffer.
If you decide this suggestion is worth implementing, there are a couple
of possibilities: (i) add another interactive command that prompts for a
port number, or (ii) change the interactive spec so that a prefix arg
prompts the user about whether to use a new buffer and what port to use.
I don't use sql.el, so I don't know which makes more sense.