Re: Prompt for a Port Number when using sql-mysql

[jungbin@gmail.com]

On Aug 16, 11:52 am, Cristian <super.sgt.pep...@gmail.com> wrote:
> Hi. I've been using the sql-mysql function for a while to interact
> with our
> databases and it's worked out well. Recently a coworker set up another
> database on a separate port that I need to access, but I don't know
> how switch between the ports easily.
>
> Is there a way to have sql-mysql prompt you for a port number (and use
> the default if you don't specify one)?

Try to add follwoing line in your dot emacs file

(setq sql-mysql-options '("-C" "-t" "-f" "-n" "--
port=your_port_number"))

Let me know if it works.  I think I got it from some where on the net.