Re: no output in sql mode of GNU Emacs on WinXP

[sparkw]

Koocyton wrote:
> ;; set MySQL
> (setq sql-mysql-program "d:/mysoft/mysql5/bin/mysql")
> (setq sql-mysql-options '("-C" "-t" "-f" "-n" "--port=22222"))

when I added "--port=22222", I can't connect to the local mysql server
which is using the default 3306 port. The erros message is

ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost'
(10061)

Process SQL exited abnormally with code 1


> ;; truncate lines for long tables
> (add-hook 'sql-interactive-mode-hook
>     (function (lambda ()
>          (setq truncate-lines t))))
> (setq auto-mode-alist
>       (append
>        (list
>         ;; insert entries for other modes here if needed.
>         (cons "\.sq$" 'sql-mode))
>        auto-mode-alist))
> (add-hook 'sql-mode-hook 'font-lock-mode)
>
> "sparkw" <jieqiwang@gmail.com>
> ??????:1155369154.208955.98080@i42g2000cwa.googlegroups.com...
> >I am using WinXP, GNU Emacs 23, MySQL 5.
> > When I start a mysql process with `sql-mysql' in emacs, no output is
> > displayed in the buffer until I quit or kill the process.
> >
> > After I add the following line into the initialization file of emacs,
> >
> >
> > (setq sql-mysql-options '("-C" "-t" "-f" "-n"))
> >
> > the output comes out, but the status line still doesn't show up. (e.g.
> > 1
> > row in set (0.02 sec))
> >
> > What's worse, I try to log the session with `\T logfile', but no
> > logfile
> > is generated. ( I check that with Google Desktop)
> >
> > Thanks for your help.
> >
> > Jieqi
> >
> >