Forgive me if this has been discussed previously. I'm only just starting to use MySQL on Windows. I've looked but have not found an answer...

I've installed MySQL and it's working OK. I want to run the client, mysql.exe from within the MingW shell, and here I have a problem. Most of what mysql.exe displays on a console window does not show up in the MingW shell. So the effect is, I start the client, and I never see a prompt. I can type commands, and sometimes I see a response. For example if I type 'use mysql;' I get no reply, but the command is processed. Then if I type 'show tables;' I will actually get the list of tables, but again no prompt. In other words I can tell that mysql.exe is working, but I'm not getting enough feedback from it. If I run it in the regular old DOS window (you know, the command prompt), then it works fine.

But what I _really_ want to do is run it within emacs. I want the M-x sql-mysql command to work. And currently it's showing the same behavior as in the MingW shell. I've set the sql-mysql-options variable, so that's not the problem.

I think I know what the problem is, though. I suspect mysql.exe using the CONS (windows-specific console thingy) instead of stdout or stderr. Now why would it do that? I haven't looked at the source to check. But if that's the case, I'd like to request that a future version uses stdout instead of CONS, or at least has a command line option to force that.

Of course my suspicion could be wrong. Has anyone else encountered this? Is there a workaround?

BTW, I've installed cygwin and tried mysqlc.exe. It shows the same behavior. The cygwin shell has no problems running either mysql.exe or mysqlc.exe, presumably because it runs within the regular windows DOS console, unlike MingW (actually, MSYS) shell and emacs.

In case it matters, I'm using recent versions of everything... mysql.exe Ver 12.22 Distrib 4.0.20a, for Win95/Win98 (i32) mysqlc.exe Ver 9.23 Distrib 3.22.7b-beta, for pc-cygwin32 (i386) emacs: GNU Emacs 21.3.1 (i386-mingw-nt5.0.2195) msys, mingw, cygwin: embarrassingly, I don't know how to determine the versions of these products, except that msys installed under a directory called "1.0". All three were downloaded and installed in the last 2 days. And oh yeah, its Windows 2000.

Thanks for any help on this,

-Dave