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 To: Michael R. Mauger Cc: Jari Aalto ; 7664@debbugs.gnu.org Sent: Tue, December 21, 2010 1:59:40 AM Subject: Re: bug#7664: sql.el: In interactive sql- command, Add C-u to set connection port Jari Aalto 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.