connecting to mysql from cygwin

Question

I can successfully connect to MySQL from a DOS prompt, but when I try to connect from cygwin, it just hangs.

$/cygdrive/c/Program\ Files/MySQL/MySQL\ Server\ 5.1/bin/mysql -u root -p

What's wrong?

Answer 1

Assuming that you have a native Windows build of MySQL, there is a terminal emulation incompatibility between DOS (command prompt) windows and bash. The prompt for mysql isn't showing up.

To confirm this, type a command and return - it will probably work, but the prompt and the echo of the command (what you're typing) is getting lost.

There may be a workaround in either the CYGWIN sytem properties or in bash, but I've never taken the time to work this one out.

Answer 2

I posted a solution/workaround here:

http://stackoverflow.com/questions/202405/enter-key-sometimes-not-recognized-in-windows-apps-under-cygwin#334802