Specify a Port Number in Emacs sql-mysql,
I’ve been using Emacs’s sql interactive mode to talk to the MySQL db server and gotten to enjoy it. A developer has set up another db on a new non-default port number but I don’t know how to access it using sql-mysql.
How do I specify a port number when I’m trying to connect to a database?
It would be even better if Emacs can prompt me for a port number and just use the default if I don’t specify. Any chances of that?
After digging through the sql.el file, I found a variable that allows me to specify a port when I try to create a connection.
This option was added GNU Emacs 24.1.
List of login parameters needed to connect to MySQL.
I added this to my Emacs init file:
(setq sql-mysql-login-params (append sql-mysql-login-params '(port)))
The default port is 0. If you’d like to set that to the default MySQL port you can customize
(setq sql-port 3306) ;; default MySQL port
There is a
sql-*-login-params variable for all the popular RDMS systems in GNU Emacs 24.1.
sql-port is used for both MySQL and PostreSQL
That’s the answer Specify a Port Number in Emacs sql-mysql, Hope this helps those looking for an answer. Then we suggest to do a search for the next question and find the answer only on our site.
The answers provided above are only to be used to guide the learning process. The questions above are open-ended questions, meaning that many answers are not fixed as above. I hope this article can be useful, Thank you